Hello Everyone,
How can we get the data from Excel Sheet which is in the below format in a Sheet
Organization Code : AXKK
Address: US
Reference: Website
So we need to get AXKK,US
Hello Everyone,
How can we get the data from Excel Sheet which is in the below format in a Sheet
Organization Code : AXKK
Address: US
Reference: Website
So we need to get AXKK,US
Hi @anmita
Are the organization code and the value are in different columns if yea then please read the datat in datatable and use look up dattable
https://docs.uipath.com/activities/docs/lookup-data-table
Cheers
Hi @Anil_G
This is the Format
So how can we extract US and Asia depending on Org Code
A Reference Xml would be helpful
HI @anmita
Try out this
Use Read range activity β Store it as DTRead
Use Output Data Table activity β Pass the DtRead and store it as Outputval
Use Assign activity and try with Regex expression
Can you share the excel file. It would help to provide you the XAML file?
Regards
Gokul
Hi @Gokul001
Thanks for the Steps
This is the file need to extract the address , reference and date basically for each Org Code
Format (1).xlsx (5.1 KB)
Hi @anmita
Check out the XAML file
Excel Regex.xaml (8.7 KB)
You can try with Regex expression
System.Text.RegularExpressions.Regex.Match(YourString,"(?<=Organization Code\s\W)\S.*").Tostring
System.Text.RegularExpressions.Regex.Match(YourString,"(?<=Address\W)\S.*").Tostring
Regards
Gokul
Try with following steps it will work
Thanks
Varun
Hi @anmita
If you donβt have any question. Kindly close this topic by mark as solved.
Regards
Gokul
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.