hi jyw,
there are many ways of doing this pending on your further use. if there is always the same delimiter (such as "-") this method should do the trick.
otherwise it is not robust.
best,
ron
New Table( "Untitled",
Add Rows( 1 ),
New Column( "Column 1", Character, Nominal, Set Values( {"JN-36M-GRNNC"} ) ),
New Column( "Column 2",
Character,
Nominal,
Formula( Word( 1, :Column 1, "-" ) )
),
New Column( "Column 3",
Character,
Nominal,
Formula( Word( 2, :Column 1, "-" ) )
),
New Column( "Column 4",
Character,
Nominal,
Formula( Word( 3, :Column 1, "-" ) )
)
);