Split a string in lines

[eduardomarchesin]

Hi team,

I have the following file with codes, in some cases, the field is with more than one code, I would like split this string in lines.

For instance line 4 in the picture, has 2 codes 526640 526639:

1-526070

2-526098

3-526445

4-526640

5-526639

Let me know if you have any question,

Rgds

Eduardo

[TheOC]

hey @eduardomarchesin 


For this you can use the text to columns tool, with the 'split by rows' option selected, and delimiting by a ' ' (space bar)

hope this helps!
TheOC

[atcodedog05]

Hi @eduardomarchesin 

Use text to column tool like below

Hope this helps : )

[TheOC · Accepted solution]

I've attached an example to get you started, just replace the text input tool with your data :) 

[binu_acs]

@eduardomarchesin 

[eduardomarchesin]

Hi TheOC,

Perfect, it worked.

Thank you very much for your help,

Rgds

Eduardo