Substring/parse question
Posted: Thu Feb 07, 2013 12:15 pm
Hi, thanks for reading. Any help is greatly appreciated.
I need help with parsing data in an input field.
If I have the following in my varchar 255 input filed
part1-part2-part3-part4-part5
I want to put part1 and part2 in one field and all other parts in another field. The dash between part2 and part3 is not needed because it's a delimiter, but I need to keep the dash between all other parts because it's part of the data. Any ideas on how to do this?
Below is what I'm trying to do
Newfield 1
part1-part2
Newfield 2
part3-part4-part5
I need help with parsing data in an input field.
If I have the following in my varchar 255 input filed
part1-part2-part3-part4-part5
I want to put part1 and part2 in one field and all other parts in another field. The dash between part2 and part3 is not needed because it's a delimiter, but I need to keep the dash between all other parts because it's part of the data. Any ideas on how to do this?
Below is what I'm trying to do
Newfield 1
part1-part2
Newfield 2
part3-part4-part5