How To Scrape Text Between Comma

[solstudioim 4]

Hello,

 

I am not sure if this has been discussed here on the forum. Please let me know of it is.

 

This is a text that I found on a webpage => 617-8 Avenue SW, Calgary, AB T2P1H1

 

The first is address then City then Post Code.

 

How can I scrape each text separated by comma using regex?

 

So I can get in separate:

617-8 Avenue SW

Calgary

AB T2P1H1

 

Apprecited for any feedback.

 

Thanks

Sol

[HelloInsomnia 1103]

Hi Sol,

 

If you know they will always be separated by a comma I think the best route to take is to split them into a list separated by a comma.

set(#address, "617-8 Avenue SW, Calgary, AB T2P1H1", "Global")
clear list(%address)
add list to list(%address, $list from text(#address, ","), "Delete", "Global")

When you go to use each list item make sure you use the $trim function to get rid of any leading or trailing spaces.

 

Regex is great, but in this case I don't think it is necessary!