Extract Value using Reg Exr

Help Studio
21

Thank you for help

22

Item Material Description Unit Dispatch Date
Order Qty Price per unit Net value Vendor Mat. No

00010 309X185 XXXXXX YYYYYY KG 08/03/2019
300.000 310.00/1-KG 93,000.00

OUTPUT:

  1. 00010
  2. 309X185
  3. XXXXXX YYYYYY
  4. KG
  5. 08/03/2019
  6. 300.000
  7. 310.00/1-KG
  8. 93,000.00

ITS THIS CORRECT EXPRESTION OR NOT :

“(?\d+)\s+(?\S+)\s+(?.+?)\s+(?[A-Za-z]+)\s+(?\d+/\d+/\d+)\s+(?[.,\d]+)\s+(?[.,\d]+\s+.\d\s[A-Za-z]+)\s+(?[.,\d]+)\s+”

23
  1. 310.00/1-KG
  2. 93,000.00

OutPut not display

Can you help me plz ?

24

Item Material Description Unit Dispatch Date
Order Qty Price per unit Net value Vendor Mat. No

00010 309X185 XXXXXX YYYYYY KG 08/03/2019
300.000 310.00/1-KG 93,000.00

OUTPUT:

  1. 00010
  2. 309X185
  3. XXXXXX YYYYYY
  4. KG
  5. 08/03/2019
  6. 300.000
  7. 310.00/1-KG
  8. 93,000.00

ITS THIS CORRECT EXPRESTION OR NOT :

“(?\d+)\s+(?\S+)\s+(?.+?)\s+(?[A-Za-z]+)\s+(?\d+/\d+/\d+)\s+(?[.,\d]+)\s+(?[.,\d]+\s+.\d\s[A-Za-z]+)\s+(?[.,\d]+)\s+”

can you help me plz?

  1. 310.00/1-KG
  2. 93,000.00

OutPut not display