RegEx converting one column with text and date

[mikael_hyensjo]

I have the below text in one column.

Adobe,7/24/20209432*0.7*99[7]

Microsoft,7/11/20209988*0.1*99[7]

Would like to have:

Adobe, 2009-07-24, 432, 0.7, 99, 7

[ShankerV]

Hi @mikael_hyensjo 

To derive the solution, please use Regex.

Then use the date time tool to convert the date to the desired format.

Then using formula tool, combine with , separator.

Many thanks

Shanker V

[ShankerV]

Hi @mikael_hyensjo 

Please find the expected result.

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

[ShankerV]

Hi @mikael_hyensjo 

Step 1: Input

step 2: Regex

(.+\,)(.{9})(.+)

Step 3: Formula

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

[ShankerV]

Hi @mikael_hyensjo 

Step 4: 

Step 5:

Step 6:

[RegExOut1]+[Date]+","+[RegExOut31]+","+[RegExOut32]+","++[RegExOut33]+","+Left([RegExOut34],1)

[RegExOut1]+[Date]+","+[RegExOut31]+","+[RegExOut32]+","++[RegExOut33]+","+Left([RegExOut34],1)

Step 7: select tool

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

[grazitti_sapna]

@mikael_hyensjo , If you are looking for the below output then you can use this workflow. Not sure if this was what you needed. Do let me know if it was helpful You can use it to add single delimiter in your data instead of numerous as you have in your input.