Split the Information in a Row


I have a DataTable with the column (“Local”) where there is the address and the store number
“Carandiru Street 556”

I need to separate the street name and use only the information (“556”) to compare with another worksheet

How do I split the line and get just the correct index?

Hi @Hendrix_Santos
do the Local always ends with street info and also would it be number

also after splitting , do u need to store in seperate column

may i get few more details?

Thanks & Regards,
Nived N

This would be an Original Table Row:

From N.Mutum (0322_0001)

I just need the 322

The pattern (text_text) follows for all lines

I think this pattern would help u


Usar o Regex dentro do For Each in the Row funciona?

did not get u ?

I will try, thanks

1 Like

Let me know if it works :slight_smile: