Extract sub-string

Hi team

i have multiple excels and i want to extract value of sub-total, gst and total
so how should i do it

JaneDoe_130792.txt (459 Bytes) JoeyTribbiani_281092.txt (1.2 KB) MonicaGeller_87654.txt (341 Bytes) RachelGreen_40874.txt (700 Bytes)

like in janedoe text file ->
subtotal = 17000
gst = 1360
total = 18360

I would suggest the following Regex:

  1. Subtotal: (?<=Sub Total ,)(.*)
  2. GST: (?<=GST 8% ,).*
  3. Total: (?<=,Total ,).*

that worked thankyou so much
:slight_smile:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.