How to use text to column methods but without manually renaming all the splited columns afterwards?

shazaaliah — Sat, 10 Jun 2023 23:34:00 GMT

How do I use the "text to column" method but without manually renaming all the splitted columns afterwards?

Re: How to use text to column methods but without manually renaming all the splited columns afterwards?

txnelson — Fri, 16 Jul 2021 07:05:14 GMT

How would you want the new columns named?

Re: How to use text to column methods but without manually renaming all the splited columns afterwards?

brady_brady — Fri, 16 Jul 2021 14:18:17 GMT

Hi,

There are a few ways to do this.

Scripting:

Names Default To Here(1);

dt = open("ExTable.jmp");

//find column position of column to be split
columnPosition = contains(dt << get column names(string), "CombinedFields");

//determine original number of columns
originalNumCols  = ncol(dt);

//new names here...
newColNames = {"Model", "Country", "Type"};

//split the column
dt << Text to Columns( columns( :CombinedFields ), Delimiters( "," ) );

//how many new columns are there?
numColsCreated = ncol(dt) - originalNumCols;

//loop through the new columns, using original column's position as an offset, and change names
for(i = 1, i<=numColsCreated, i++,
	column(dt, columnPosition + i) << set name(newColNames[i])
);

Cut and paste:

Place the new column names in a single column of a table, select them all, and copy them with a CTRL-C (CMD-C on Mac).

Perform the Text To Columns operation, then select the new columns and press CTRL-V to paste the new names.

Using Recode Column Names

First, use Text To Columns to split the column of interest.

Next, Select Cols > Column Names > Recode Column Names... from the main menu.

Enter the new column names as desired, then click the Recode button to finish.

Table and script attached.

Cheers,

Brady

topic Re: How to use text to column methods but without manually renaming all the splited columns afterwards? in Discussions

How to use text to column methods but without manually renaming all the splited columns afterwards?

Re: How to use text to column methods but without manually renaming all the splited columns afterwards?

Re: How to use text to column methods but without manually renaming all the splited columns afterwards?