Regex Range Excel

[anh.nguyen]

Hi all,
I have excel file. How I can get number : CONTAINER / SEAL NO.: TCNU6087868/HAS 1482677 → TCNU 608786-8

Result.xlsx (8.6 KB)

[arjunshenoy]

Hi @anh.nguyen

You can use the following RegEx pattern:

TCNU\d+(?=/)

Hope this helps,
Best Regards.

[anh.nguyen]

Hi,

How can I change for all number Con like that ?

[arjunshenoy]

@anh.nguyen

1. Read the excel file in a datatable.
2. Use a for each row in datatable activity to iterate through each row.
3. Inside the loop, use an assign activity to get the TCNU of each CurrentRow in a variable :

rowTCNU = System.Text.RegularExpressions.Regex.Match(CurrentRow(“ColumnName”).ToString,“TCNU\d+(?=/)”).Value

Hope this helps,
Best Regards.

[LAKSHMI_NARAYANA_PEMMASAN (LAKSHMI NARAYANA)]

Please find attached file
Strings2.xaml (12.8 KB)

Hope this is what you are looking for

Regards

[anh.nguyen]

Can get all num Con, why at start at row10? can you help me check file xaml and add Titles: Container Num. Thank

TestAutomation.xaml (13.6 KB)

[LAKSHMI_NARAYANA_PEMMASAN (LAKSHMI NARAYANA)]

in write cell try this

Hope now you should able to write from A1

Regards

[Manish540 (Manish Shettigar)]

Hi @anh.nguyen ,

Check this below workflow attached,
Uipath_RangeRegex.xaml (15.2 KB)

Output Screenshot:

Hope this might help you

[anh.nguyen]

Thank all, I use assign but do not show titles at A1
how can I add Titles

[vishal.kp (vishal)]

@anh.nguyen ,

You can write the title in the A1 cell position before the for each starts.

[arjunshenoy]

@anh.nguyen

Updated the workflow & attached the same for your reference. Please try the same & ley us know if it works for you.

RegExProcess.zip (143.8 KB)

Output:

Hope this helps,
Best Regards.

[anh.nguyen]

Thank you so much