Separate Between Letters and Numbers

[faresghnaim]

Hello guys,

I am trying to separate between the letters and numbers in the sample data below:

I would want the final input to be 2 different columns one is : property plant and equipment and the other would be 7 928,789,952,954 and so on.  Would that be possible using Regex?

Thanks!

[pedrodrfaria · Accepted solution]

Hi @faresghnaim 

You need to use regex to clean it up. Use the WF attached to update your WF with the correct regex logic.

Pedro.

[faresghnaim]

@pedrodrfaria  Thank you so much for the fast solution!