Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
Thread: Split A Folder Path
08-22-2012, 03:19 PM #1
- Join Date
- Jun 2011
- Swindon, England
- Thanked 9 Times in 9 Posts
Split A Folder Path
I am looking at an SQL database table where one thing I have found is I have a Folder path. I would like to split it out but have come to realise I have never even thought about splitting a field in a database before.
Effectively I have
Col 1, Col 2, Server, Path, Col 4, Col 5
What I would like is
Col 1, Col 2, Server, Parent, Child Lev 1, Child Lev 2, Col 4, Col 5
Unfortunately I have no set level either. so some folders obviously will be 1 level, others will be 9 others may be 15.
Any help would be apreciated.
LaurenceCareXipux Design (Currently Unavailable)
Laurence S Care