How to use text to column?

Help Studio
1

Hi :wave:
I have an excel file that have data in it and I want to do text to column whereby the result (as screenshot) would add a new column (“Team ID”) with the team ID and removing the brakcets “(” and “)”.

UiPath

Additional question: If the original column is not in Column A? Can this work if the column that I want to do text to column is in Column D.

2

Hi @Bonus ,

You can split the Team Members table (column A) into the Team Members & Team ID table (columns C&D) simply by using the regex functionality.
Please refer to this post it to better understand how to find your regex pattern and how to integrate it within the UiPath https://forum.uipath.com/t/regex-help-tutorial-megapost-making-your-first-regex-post-reusable-regex-patterns-regex-troubleshooting-sample-workflow-and-more/238791

Regarding the additional question, the answer is yes. You can make reference to a datatable column by its name.
It looks like: yourDT.Rows(yourDT.Rows.Count-1)("Team Members") - this is if you would like to add a new record at the bottom of a table which has the “Team Members” column

Hope this helps
Best regards,
Marius

2 Likes
3

Hi @Bonus

Please find the attached zip file for your reference. Feel free to reach us at any time if you have any doubt. Thanks.

Spliting String.zip (42.3 KB)

Happy Automation.

1 Like
4

Thanks. Looks like this is a popular option.

5

Thanks. This is simple and neat.

1 Like