How to get the last value after the third underline "_"

Hi, guys. I’m trying to get the third word after “_” for each row in the excel
and print it by console.

image

For example.
Desired output

“Agregador”

and

“Centro”.
This is the file.
test - Copy.xlsx (8.1 KB)

Any idea, thanks.

Hi,

Can you try the following?

CurrentRow(0) = System.Text.RegularExpressions.Regex.Match(CurrentRow(0).ToString,"[^_]+$").Value

Sample20230120-1L.zip (8.5 KB)

Regards,

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.