Split a string in lines

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

Input

Custom Tools

Expression

Accepted answers

TheOC

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

eduardomarchesin.yxmd

All comments

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 : )

str split.yxmd

TheOC

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

eduardomarchesin.yxmd

Hi TheOC,

Perfect, it worked.

Thank you very much for your help,

Rgds

Eduardo

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703