I faced challenges in UiPath excel automation. here are my problem statements which are related to the excel attachment:
In attached file “Route” Column (B column) has a statement, which need to be split into 2 columns (should be separated by either “ - ” or “ to ”). Usually we use “Text to column” option in excel to do this split. How can I split it in UiPath?
“In J column” , End customer name is mentioned either “ End Customer: BDCOM” or “ End User: BBTS. Ref CLTS ID: 2068. Already Commissioned.” How can I separate only “BDCOM” or “BBTS” from these 2 statements in UiPath?
Many thanks for your support.
Extract Data V.2.xlsx (12.9 KB)