I am having rows like:
abtycfgv, 00075673, -00000000009765
I want to delete any string with this pattern “,000XXXXX” and the result i want is:
Please help to guide me how should i do this with string manipulation node
You can achieve this with:
note: you data is a bit dirty with inconsistent usage of spaces so if you clean it up a bit in advance than a simpler regex is also sufficient
Hope this helps!
Actually I just simply put the example above with space and 3 “000”
I do a little bit of adjustment below (please refer to image below) :
Thanks for your help again
They’re the same, so what is that showing?
@bruno29a … I think it’s showing this:
Hi guys, sorry my bad
It should be:
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.