JMP formula to transfer format

Question

Dear Expert,

I have some package data as show in col_1, but would be like to use JMP formula to transfer to the format as show on Col_2 and Col3. Can anyone advise which formula should I use? Thanks

Hu Pin

Package ( extraction )

Desired Format 1

Desired Format 2

P-BGA-416-10

BGA416

BGA-416

P-BGA-416-4

BGA416

BGA-416

PG-BGA-416-22

BGA416

BGA-416

PG-BGA-416-4

BGA416

BGA-416

PG-DIP-14-2

DIP14

DIP-14

PG-DSO-20-2

DSO20

DSO-20

PG-LQFP-144-23

LQFP144

LQFP-144

PG-LQFP-144-4

LQFP144

LQFP-144

PG-MQFP-80-7

MQFP80

MQFP-80

PG-OLQFN-76-3

OLQFN76

OLQFN-76

PG-TSSOP-28-1

TSSOP28

TSSOP-28

PG-TSSOP-28-16

TSSOP28

TSSOP-28

PG-TSSOP-28-2

TSSOP28

TSSOP-28

PG-WQFN-6-2

WQFN6

WQFN-6

Bill_Worley · Answer

Hi Hu Pin,

One other thought for you if you are using JMP 12.  Use the JMP Recode tool under Columns.  The new recode functionality allows you to group changes, and you can set up multiple recodes in the same recode dialogue.  You can then save the changes as a new column or as a formula column.  You can also save the recode as a script and use it again as new data comes in or transfer it to a new data table as needed.

Best,

Bill

Kevin_Anderson · Answer

I once read where Regular Expressions are "write only"...often, an author can't read the RegEx they wrote a short time ago!

Jeff_Perkinson · Answer

And, for those like me who still can't wrap their heads around regular expressions, the Word() function works well. In fact, it's the function I recommend most.

Word( 2, :Name( "Package ( extraction )" ), "-" ) || Word( 3, :Name( "Package ( extraction )" ), "-" )

Word( 2, :Name( "Package ( extraction )" ), "-" ) || "-" ||  Word( 3, :Name( "Package ( extraction )" ), "-" )

The top one will give you Desired Format 1 and the bottom is Desired Format 2.

-Jeff