Split data using regex or any other tools

[mihaicom20]

Hello,

There is a simple question, but I don't know how to apply it with regex or any other tools.

I would like to split a number like in the following example:

 Input: 579824.13596816.79

Col1: 579824.13

Col2: 596816.79

Basically I want to split the number in 2 Col, taking the 2 digits after "."

Thank you in advance!

[atcodedog05 · Accepted solution]

Hi @mihaicom20 

Here is how you can do it.

Workflow:

Hope this helps : )

[binuacs · Accepted solution]

@mihaicom20 Another Regex Tokenize 

[mihaicom20]

Thank you so much @atcodedog05 

After I posted the topic I tried also this one and it worked, but I will use the one provided by you. Idk how sensitive is mine lol :

[MarqueeCrew · Accepted solution]

@mihaicom20 ,

I just wanted to show you a non-RegEx approach.  Look at the data and use the decimal (.) as a delimiter.  You're left with 3 columns of data.  Col1 + . + the first 2 digits of Col2 is one answer and so on....

Use a Text To Columns tool:

• Split your field using . as a delimiter
• Number of columns = 3

ToNumber([1]+"."+Left([2], 2))

and

ToNumber(Substring([2],2)+"."+[3])

Cheers,

Mark

[atcodedog05]

Hi @mihaicom20 

Your method should work too. Its similar to @binuacs method

Happy to help : )

Cheers and have a nice day!