BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar
Benny

Community Member

Joined:

Aug 1, 2018

How to extract x ,y coordinate from string

Hello

 

i have list of coordinate  ( X,Y) which i want to have in one column X value and second Colum Y value

X and Y can be 1 of 2 dig and +/-

Thanks

Benny

 

 

2 REPLIES 2
txnelson

Super User

Joined:

Jun 22, 2012

Re: How to extract x ,y coordinate from string

The best way to do this is to use the Word() function

Create your new column and then use this as the formula for the column, to get the X value

Num( Word( 1, <:Coordinate Column Name>, "," ) );

For the Y column, just change the "1" to "2"

 

Details on the Num() and Word() functions can be found in the Scripting Index

     Help==>Scripting Index

 

Jim
Byron_JMP

Staff

Joined:

Apr 26, 2012

Re: How to extract x ,y coordinate from string

Without scripting or formulas...

 

Try, Cols Menu tab, Utilities, Text to Columns, add "," as a delimiter 

 

JMP Systems Engineer, Pharm and BioPharm Sciences