RegEx separate into columns

[DanielCarro]

Hi Guys,

Need some help with RegEx formulation as I am struggling a bit with it.  I need to split the cell into different columns.

I have the following:

15 May 2024   AAA(01)             GB008     4,000              0.4971000           1,966.80     0.00    1,966.80

16 MAY 24     BBBBB.US@0.1   GB008    70,000          0.014500               1,015.00      0.00       1,015.00

16 December 2024  cc(US_CBS)  AU005           11,000        0.3751000           1,486.00    0.00    1,486.00

I need to following output:

15 May 2024	AAA(01)	GB008	4,000	0.4971000	1,966.80	0.00	1,966.80
16 May 24	BBBB.US@0.1	GB008	70,000	0.014500	1,015.00	0.00	1,015.00
16 December 2024	cc(US_CBS)	AU005	11,000	0.3751000	1,486.00	0.00	1,486.00

Much appreciated any assistance on this one.

Dan

[davidskaife · Accepted solution]

Hi @DanielCarro 

This should work based on your examples:

The Regex i've used is

(.+)\s(\u{2}.+)

[DanielCarro]

Hi @davidskaife ,

Works great, many thanks.  What does \u stand for?

[davidskaife]

Hi @DanielCarro 

\u refers to Uppercase letters only

You're welcome!