Split the Information in a Row

Help Something Else
1

Hello,

I have a DataTable with the column (“Local”) where there is the address and the store number
Example:
“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?

2

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

3

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

4

I think this pattern would help u

image

5

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

6

did not get u ?

7

I will try, thanks

1 Like
8

Let me know if it works :slight_smile: