Simple RegEx question

Help Activities
, , ,
1

Hello,
I’m just starting with RegEx, seems like a great thing but unfortunately my knowledge is limited…
i need to read through invoices and enter some info to a spread sheet.

  1. Invoice No. 7334/00148461
    i don’t know how to overcome “.”? It is always after No
    Without dot this one is good, what do i need to add?:

(?<=Invoice\sNo\s)(.*?(?=\s))

  1. Job
    994 HUNTERS HILL Page 1 of 1

i need to enter job name, in this instance “994 HUNTERS HILL”
word “job” is always on the own line.
And page number is aways on the same line as a job name.
Job names can be absolutely different, from just numbers to a sentence.

Any help will be greatly appreciated!!

2

Hi @natasha6 ,

The period can be escaped using a forward slash like so →
image

(?<=Invoice No\.\s).*

As for the second text, you can detect the required section using this pattern →

image

(?<=Job\r?\n).*(?=\sPage)

Kind Regards,
Ashwin A.K

1 Like
3

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