cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can change your system assigned username to something more personal in your community settings. X

Text in columns

BPP
7-Bedrock
7-Bedrock

Text in columns

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.

EXAMPLE_BPP_01.PNG

Is this possible? Thanks in advance

1 ACCEPTED SOLUTION

Accepted Solutions
LucMeekes
23-Emerald III
(To:BPP)

I thought I'd better try it out:

LM_20190127_ReadCSV.png

Prime 3.1 file attached.

Success!

Luc:

 

View solution in original post

4 REPLIES 4
Fred_Kohlhepp
23-Emerald I
(To:BPP)


@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.

EXAMPLE_BPP_01.PNG

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
23-Emerald III
(To:BPP)

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

Otherwise READTEXT could be your friend.

 

Success!
Luc

LucMeekes
23-Emerald III
(To:BPP)

I thought I'd better try it out:

LM_20190127_ReadCSV.png

Prime 3.1 file attached.

Success!

Luc:

 

BPP
7-Bedrock
7-Bedrock
(To:LucMeekes)

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.

Top Tags