Hi, guys. I’m trying to get the third word after “_” for each row in the excel
and print it by console.
For example.
Desired output
“Agregador”
and
“Centro”.
This is the file.
test - Copy.xlsx (8.1 KB)
Any idea, thanks.
Hi, guys. I’m trying to get the third word after “_” for each row in the excel
and print it by console.
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.