Choosing output based on certain Text String

[jacob_klimek]

Hello,

I have a dataset with a bunch of addresses, unfortunately they are all combined into one line and I need to parse out everything that comes after the person's name into one line.

Data that I have:

id         Name               address_line                                              city_state         zipcode

1          John Doe          john doe 123 Central Avenue                 New York, NY    12345

Data I want:

id         Name               address_line_1                                          city_state         zipcode

1          John Doe         123 Central Avenue                                 New York, NY    12345

I know I probably have to use index and substring or some combination of those, but I really have no idea where to start.

[Reeza]

Use the length of name as the second argument to substr function. It tells it where to start the substr and leaving out the third parameter tells it to take the rest of the string. 

Address = substr(address_line1, length(name));

[Astounding · Accepted solution]

That looks like the right set of tools, but I think you are looking for this:

address_line_1 = substr(address_line, length(name) + 2);