Parsing from right to left

[BautistaC888]

Hello,
I need help parsing an address.
Example:
- Input.

- Output:

Thank you.

[afv2688 · Accepted solution]

Hello @BautistaC888 ,

you can use the regex replace function for that for example:

Output1
REGEX_Replace([Field1], '(.*),(.*)', '$1')
Output2
REGEX_Replace([Field1], '(.*),(.*)', '$2')

Hope that helps 🙂

Regards