G
Guest
I have a field, [Original], delimited by "/" that contains up to 10 segments (sometimes the field has less, it varies). The length of any given segment may vary also, depending upon the particular row and the particular segment (hence the "/"). If it is of significance, the final segment, does not have a "/" trailer.
I would like to separate [Original], but I can't seem to get beyond the first two segments. I simply used the example shown in Microsoft Article 115915 (http://support.microsoft.com/default.aspx?scid=kb;en-us;115915), and changed the field name, and the delimiter, from " " to "/".
Expr1: Trim(Mid([Names],InStr(1,[Names],"/")+1,InStr(InStr(1,[Names],"/")+1,[Names],"/")-InStr(1,[Names],"/")))
Expr2: Trim(Mid([Names],InStr(2,[Names],"/")+1,InStr(InStr(2,[Names],"/")+1,[Names],"/")-InStr(2,[Names],"/")))
I've tried to substitute increasing values for the 1's and 2's, hoping that they refer to the next segment, but I haven't had any luck yet.
Could anyone provide some code, or explain each part of the above expression?
I would like to separate [Original], but I can't seem to get beyond the first two segments. I simply used the example shown in Microsoft Article 115915 (http://support.microsoft.com/default.aspx?scid=kb;en-us;115915), and changed the field name, and the delimiter, from " " to "/".
Expr1: Trim(Mid([Names],InStr(1,[Names],"/")+1,InStr(InStr(1,[Names],"/")+1,[Names],"/")-InStr(1,[Names],"/")))
Expr2: Trim(Mid([Names],InStr(2,[Names],"/")+1,InStr(InStr(2,[Names],"/")+1,[Names],"/")-InStr(2,[Names],"/")))
I've tried to substitute increasing values for the 1's and 2's, hoping that they refer to the next segment, but I haven't had any luck yet.
Could anyone provide some code, or explain each part of the above expression?