B b4AMarkO Member Licensed User Longtime User May 13, 2013 #1 I have strings that have one thing in common IE; xxxx @ 1234 Some Street xxx @3456 Another Street xxx xxxxx @ 1243 Street View The x's represent possible words before the @ Im sure you got that Anyway I want to remove everything before the address using the @ as the delimiter .....
I have strings that have one thing in common IE; xxxx @ 1234 Some Street xxx @3456 Another Street xxx xxxxx @ 1243 Street View The x's represent possible words before the @ Im sure you got that Anyway I want to remove everything before the address using the @ as the delimiter .....
klaus Expert Licensed User Longtime User May 13, 2013 #2 Like this: Code: txt = "xxxx @ 1234 Some Street" txt = txt.SubString2(txt.IndexOf("@") + 1, txt.Length) If there is there always a blank character after @ you shold use: Code: txt = txt.SubString2(txt.IndexOf("@") + 2, txt.Length) Best regards. Upvote 0
Like this: Code: txt = "xxxx @ 1234 Some Street" txt = txt.SubString2(txt.IndexOf("@") + 1, txt.Length) If there is there always a blank character after @ you shold use: Code: txt = txt.SubString2(txt.IndexOf("@") + 2, txt.Length) Best regards.
