Splitting a string into 3 vars

Discussion created by chronister on Apr 23, 2014
Latest reply on Apr 24, 2014 by steve_ssh

Hello all,


Got a question about splitting a string. I have been searching for this and I am sure it is easy and I am hoping you gurus can help me out once again. I need to split a string into 3 variables. Each piece is seperated by a hyphen. Here are examples of the strings I need to split. This is running in a script to import data from one table to another.


Gildan - Heavy Blend™ Hooded Sweatshirt - 18500
Hanes - PrintProXP Ultimate Cotton® Hooded Sweatshirt - F170

Gildan - DryBlend™ Hooded Sweatshirt - 12500


As it loops through the records that contain these lines, I am aiming to set these as 3 variables....






If there is a 1 line solution, that is great, but if it needs to be set in 3 pieces (3 set variable script steps), that is cool too.


Any help is appreciated.


Thanks folks,