Getting values into their own row

[Deano478]

Hi all,

A colleague of mine provided me with a messy extract where they multiple values stuffed into one row like so:

Is there any way to separate these values out into their own row?

My head is beyond melted with this.

Cheers for any help provided.

Input:

400.00 21.00 138.19 401.53 727.72 891.44
329.57
1500.00 60.00 28.20 9.99 117.27 9.99 1920.00
2130
8.00 21.00 541.42 362.55 1100.00 406.41 143.92
1250.00 125.00 891.44 727.72
88.00 189.00 329.57 64.2 400.00 15.00 159.25
9.99 29.99
65.00 200.00 200.00 2581.00 21.00 8.00 2700.00
28.0 891.44 130.59 76.27 2900.00 2590.00 3050.00 238.46 126.36
200.00 2.00 329.57 9.99 120.00 12.60 486.17

[binuacs]

@Deano478 Can you give a sample output? 

[Deano478]

Hey @binuacs it would look something like this that's just the first few lines:

400
21
138.19
401.53
727.72
891.44
329.57
1500
60
28.2
9.99
117.27
9.99
1920

I appreciate this probably isnt so straightforward so i appreciate the hand

[FinnCharlton · Accepted solution]

Hi @Deano478 , I would do it like this: 

[binuacs · Accepted solution]

@Deano478 use the tokenize option in the regex tool

[ahsanaali · Accepted solution]

Here are my two cents.

[Deano478]

@binuacs , @ahsanaali  @FinnCharlton Cheers guys that worked like a charm I have one more column I forgot to add into the input my apologies. This column I feel it impossible to parse because its dates but here it is:

31 Dec 2021 4 Jan 2022 6 Jan 2022 7 Jan 2022 10 Jan 2022 11 Jan 2022 12 Jan 2022 13 Jan 2022

14-Jan-22

14 Jan 2022 17 Jan 2022 18 Jan 2022 19 Jan 2022 20 Jan 2022 21 Jan 2022 24 Jan 2022 25 Jan 2022 26 Jan 2022

27 Jan 2022 28 Jan 2022

28 Jan 2022 31 Jan 2022 1 Feb 2022 2 Feb 2022 3 Feb 2022 4 Feb 2022 7 Feb 2022

9 Feb 2022 10 Feb 2022 11 Feb 2022

11 Feb 2022 14 Feb 2022 15 Feb 2022 16 Feb 2022 17 Feb 2022 18 Feb 2022 21 Feb 2022 22 Feb 2022

23 Feb 2022 24 Feb 2022 25 Feb 2022

25 Feb 2022 28 Feb 2022 1 Mar 2022 2 Mar 2022 3 Mar 2022 4 Mar 2022 7 Mar 2022

7 Mar 2022 8 Mar 2022 9 Mar 2022 10 Mar 2022 11 Mar 2022

11 Mar 2022 14 Mar 2022 15 Mar 2022 16 Mar 2022 21 Mar 2022 23 Mar 2022 24 Mar 2022 25 Mar 2022

[binuacs · Accepted solution]

@Deano478 One way of doing this