String Manipulation Remove @ from string

[b4AMarkO]

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]

Like this:

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:

txt = txt.SubString2(txt.IndexOf("@") + 2, txt.Length)

Best regards.