Split data using regex or any other tools

Question

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 Answer

Hi @mihaicom20

Here is how you can do it.

Workflow:

Hope this helps : )

binu_acs · Accepted Answer

@mihaicom20 Another Regex Tokenize

MarqueeCrew · Accepted Answer

@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