separate a string with a limiter string

[elaadani]

Hello, good afternoon.
I would like to know if someone can help me.
I have an address PO BOX 82 STREET MD.
I would like to be able to take this string and store PO BOX then 82 then STREET and finally MD as I show in the image

Each address is structurally different, so I tried to use Cell Splitter with STREET as a token in the first instance, but it deletes everything on the left.
Thanks in advance

[FtmhRahimi]

Hi @elaadani
I think you can do this using the “ُString Manipulation” node. See the attached example:
split address.knwf (14.2 KB)

[elaadani]

Thank you very much for your kindness ! @FtmhRahimi

[elaadani]

@FtmhRahimi May I ask one last question?
How can I separate SUITE with numbers and STREET with numbers in different cells in the case that the address has
STREET 82 MD CALI SUITE 110 , CL

[FtmhRahimi]

@elaadani Feel free to ask
You can do this again using the “ُString Manipulation” node. see the attached example:
split address2.knwf (12.9 KB)

[ipazin]

Hello @elaadani,

in general this kind of address parsing/splitting requires (often complex) regex to be written. So you should check all the possibly combinations of your addresses, extract rules from it and convert them to one regular expression in Regex Split node for example

Br,
Ivan

[Daniel_Weikert]

depending on your data it might look different. As ipazin suggested
Regex Split does the job

bR