text to columns help

[anselyuan]

I have a text and columns problem as below

ID    Description    date

1      abc d            7/12 

        efg                      

2      edskjc s        4/12

        sdffe

Field: 14

3      afsc d            7/12 

        efsg                      

4      edvfva s        4/12

        safe

Field: 15

first of all, I want to split it in to column, there are 2 problems.

1. the description column contains space

2. the description is not in the same row

then, Iwant to add a column call field.

[Joe_Mako · Accepted solution]

You can use the Regex tool set to Parse with the pattern:

(.*?)\s(.*)\s(\d{2}-\w{3}-\d{4})\s(.*?)\s([\d|\.]*)

[SeanAdams]

Hey @anselyuan

Did @gc and @Joe_Mako get you to a solution that worked or are you still struggling with this particular issue?

IF they managed to solve your problem - would you mind marking this as solved (using the green "Solution" button on this thread) or if you are still struggling with this particular case, feel free to reply and we can iterate with you as a community.

Cheers @anselyuan

Sean