Hi all,
Would like to enquire advise to remove certain series number in 1 column where only want numbering start from 1 onwards using string manipulation. Can advise how to input the expression to remove the remaining in regex replace.
there are a few, easy ways to accomplish that. beforehand, it would be good to know if the data can be like
”123456 / 459725 / 147852”
”123456 / 123456 / 123456”
and what your desired output should look like in that case.
I would recommend cell splitting and then processing the columns. Alternatively, you can convert the column straight into an array and process that.
Simple regex extraction ala (.*)(\d*)(.*) and extracting group 2 should work just fine if you need only one group
Do you only want the first group of numbers or all groups which begin with 1?
All groups which begin with 1
This should work for you. You can replace the original columns if you want. I kept them so you can see what’s happening.
1 Like
I tried but it appeared error as per below screenshot upon trying.
Another enquiry, does it have to be table creator? as i’m using excel reader in the beginning.
Did you try my workflow as I posted it? It works fine for me. The input should make no difference assuming your data is in string format. Can you share your Excel workbook?
Example_1.xlsx (13.8 KB)
Attached example of my excel
You didn’t answer my question. Did the workflow I posted run for you?
the workflow unable to run due to the final execution failed.
i added row filter to remove the first 2 empty row.
You still haven’t answered my question. Did the workflow I posted run for you?
Sorry i don’t quite get what you mean. The workflow run for me means the execution did tried to run through right?
Simply run the workflow with no changes,
yes, i run the workflow with no changes. just followed exactly according to your workflow.
Hi,
I meant to remove 459725 (group number) instead to rename into same group number.
Also i installed regex extraction but it doesn’t shows in the node.
I’m trying to determine where the problem is. Did my workflow run correctly with my data? Could you explain your business case? The Excel workbook is totally different from your original screenshot. Are you trying to split the #BNR column?
You’re getting the error message with your data because of the missing values. You’ve got to change them to blanks.
1 Like
Hi,
A great thankyou. I finally manage to run the workflow.
Deeply appreciate your strong support.
If it worked for you please mark solved.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.