Hello, How do I parse a column based on the last character that separates a string? In the example below, i want to create a column that grabs Detroit and Holland. Region/CityCityUnited States/Michigan/DetroitDetroitUnited States/Michigan/West Michigan/HollandHolland

Parsing based on character

Hello,

How do I parse a column based on the last character that separates a string? In the example below, i want to create a column that grabs Detroit and Holland.

*Region/City*	*City*
United States/Michigan/Detroit	Detroit
United States/Michigan/West Michigan/Holland	Holland

Common Use Cases

Accepted answers

Joe_Mako

Using (.*) as the capture group instead of (\w*) would capture all characters after the last slash, because sometimes a city has a space in its name, and the \w will return a Null in that case. See attached for example.

parse last.yxmd

All comments

NicoleJohnson

This regular expression ought to do the trick, in the RegEx tool:

.*/(\w*)$

Output method should be Parse or Replace (if replace, designate $1 as the marked group you want to keep). Does that work for you?

Cheers!

Thank you!

how would I alter this process to put what is before the last slash into it's own column? Using your example - take column Region/City and create 2 new columns - Region, City?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703