You’re offline. This is a read only version of the page.
Announcements
Hello,
My question is in the image i have uploaded(list),1) i want to split the the number and the text and get them into two separate columns in a data table. The split action is not splitting the text correctly and getting them as a continuous list, which i do not want to happen. 2) Please let me know how to split the text in a way that only the number and text should be separate. tried using the space delimiter on split text action but it's splitting the text too. Please Help.
Kind Regards,
Surya
Hi @suryasriram
see the below demo flow which helps to extract the values and put in seperate columns.
Assume the datatable has the following structure
Column 2 and Column 3 should store number and state name respectively.
Now see how the flow is designed.
1. For demo purposes, I have created a datatable variable NewVar by using set variable action as shown below
2. Use another set variable action to set the row index variable initializing to zero
3. Loop through each row of datatable using for each
Inside the loop, follow the below steps
3.1- Use parse text action to get the number component from the column1 as shown below
3.2- Use Replace Text action to replace the number component from column 1 value and store in new variable.
3.3- use set variable to update the column2 with number_1 and column3 with State_name as shown below
3.4- use increment variable to increment rowindex
At the end see the datatable as shown below
Hope this helps !
Nived N 🚀
LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs
🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌
Share
Report
All responses (
Answers (
18,136
