Extracting Right of a Delimiter

[win_anthony]

I have been playing around with Subfield but it is not resulting in the output that I was expecting. The problem is that the delimiter starts at different indexes as well as the number of characters that I am trying to extract from the string. 

How would you approach this? Below is an example of what I am trying to achieve.

Address	Expected Output
123 Main Street, Sydney AUS	Main Street, Sydney AUS
50 69650 Ave - Sao Paulo BRZ	69650 Ave - Sao Paulo BRZ
ABW45 Frontage Road Chicago IL USA	Frontage Road Chicago IL USA

[Saravanan_Desingh · Accepted solution]

Can u try this?

LOAD *, Mid(F1,Index(F1,' ')+1) As F2 INLINE [
F1
123 Main Street, Sydney AUS,
50 69650 Ave - Sao Paulo BRZ, 69650 Ave - Sao Paulo BRZ
ABW45 Frontage Road Chicago IL USA
];

[win_anthony]

Outstanding! Thank you!!! Exactly what I was hoping to achieve! 😃

[Saravanan_Desingh]

Updated:

LOAD *, Mid(F1,Index(F1&' ',' ')+1) As F2 INLINE [
F1
123 Main Street, Sydney AUS,
50 69650 Ave - Sao Paulo BRZ, 69650 Ave - Sao Paulo BRZ
ABW45 Frontage Road Chicago IL USA
Nothing
];