05-27-2016 03:07 PM
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.
05-27-2016 03:49 PM
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));
Need further help from the community? Please ask a new question.