Need help to string manipulate a single address into multiple lines

Hi @fazewalker

will splitting on comma with count work?

like say you string is

str = "HELLENIC BANK 173 Athalassa Ave., 2025 Strovolos, Nicosia, Cyprus."

will be your first bank details
str.Split(","c)(0)

Last is Country
Str.SPlit(","c)(Str.SPlit(","c).Count-1)

Last but two is your state
Str.SPlit(","c)(Str.SPlit(","c).Count-2)

Remaining goes into street address as one by using a replace activity …you already have which are separated do a replace of them and remaining is the required street details

Or

If you have a list then we have to create a look up on the list

cheers