Get everything after "City:"

Hello there!

Im making an automation but i got a problem with extracting words.
To be exact I need everything after city in this response:
“Country: Netherlands (NL)
State: Zuid-Holland
City: Leidschendam-Voorburg”

Do any of you guys know how to fix this problem?

Hi @Vito

This can be done using Regex. See here for some examples:

Cheers
Gijs

How does this work for you? Capture group 1 will have your city. It uses the lookbehind for City: followed by 0 or 1 white space character

(?<=City:\s?)(.*)
1 Like

Thank you this works!

1 Like