Text in columns

[BPP]

Hi to all.

I need to generate a routine that separates into columns texts that contain words separated by a comma "," as shown in the image.

Is this possible? Thanks in advance

[Fred_Kohlhepp]

---

@BPP wrote:

Hi to all.

I need to generate a routine that separates into columns texts that contain words separated by a comma "," as shown in the image.

Is this possible? Thanks in advance

---

The answer is yes, although it may be more challenging in Mathcad than some other programs.  If you have to do this only a few times (and can allow a "manual" method) I'd suggest (in Prime) an EXCEL component:

• Input variable for DATA,
• Open EXCEL, text to column with coma delimiter
• Output variable from EXCEL

This begs the question:  Why are you using Mathcad to manipulate text?

[LucMeekes]

What's wrong with using READCSV ?     (Read Comma Separated Values)

Otherwise READTEXT could be your friend.

Success!
Luc

[LucMeekes · Accepted solution]

I thought I'd better try it out:

Prime 3.1 file attached.

Success!

Luc:

[BPP]

Normally to manipulate text I use excel, but I had doubts if there was a way to do it directly in mathcad, exactly as LucMeekes proposes, with READCSV, I did not know that command.
Thank you very much for the help.