Regex Function for the string


#1

Hi all,

please explain the regex function to extract the data present in string with bold letters:

Input Data:
Line Item GTIN Supplier Stock # Color Size Quantity Ordered UOM Pack Cost Extended Cost
001 615235199 8906008456554 (GTIN-13) 8906008456554 30G 1 CA 288 / 1 9665.0800 9665.08
Item Description BLEACHGOLD 30G
002 616829169 8906008459487 (GTIN-13) 8906008459487 350 ML 1 CA 72 / 1 10269.1600 10269.16
Item Description SHAMPOO HAIRFAL REPAIR 350ML
003 980005237 8907122006571 (GTIN-13) 8907122006571 50G 1 CA 96 / 1 10738.9800 10738.98
Item Description FACIAL KIT HALDI & CHANDAN 50G

Output Data:
variable 1: 001, Variable 2:615235199,Variable 3: 8906008456554 (GTIN-13)
Variable 4: 30G ,Variable 5: CA Variable 5: 1 Variable 5: 288/1
Variable 5: 9665.0800 Variable 5: 9665.08 and similarly others