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.