Issue with Positive look ahead

[devasaiprasad_K]

i am not getting exact result of Positive Look ahead… can some one help me with this.

pattern:
“(?<=invoice number-\d± [A-Z]±)\w+(?=-)”
Text:
“invoice number-098888-JJHDR-INR-XJIE0R”

but i am not getting any result

[rlgandu (Rajyalakshmi Gandu)]

@devasaiprasad_K

Please shate the sample input

[devasaiprasad_K]

@devasaiprasad_K

pattern:
“(?<=invoice number-\d± [A-Z]±)\w+(?=-)”
Text:
“invoice number-098888-JJHDR-INR-XJIE0R”

pattern:
“(?<=invoice number-\d± [A-Z]±)\w+(?=-)”
Sample Input:
“invoice number-098888-JJHDR-INR-XJIE0R”

[vrdabberu (Varunraj Dabberu)]

Hi @devasaiprasad_K

Can you share the expected output.

Regards

[rlgandu (Rajyalakshmi Gandu)]

@devasaiprasad_K

Please share output also

[rlgandu (Rajyalakshmi Gandu)]

@devasaiprasad_K

(?<=invoice\s*number\-\d+\s*\-[A-Z]+\-)\w+(?=\-)

I do some changes in the regex hope it works for you

[vrdabberu (Varunraj Dabberu)]

Hi @devasaiprasad_K

Check out the below regex if this is the output needed.

(?<=invoice number\-\d+\-?[A-Z]+\-)\w.*

or this:

(?<=invoice number\-\d+\-?[A-Z]+\-)\w+(?=-)

Regards

[pravallikapaluri]

Hi @devasaiprasad_K

(?<=invoice\snumber\-\d+\-[A-Z]+\-)\w+(?=-)

[devasaiprasad_K]

let me correct the INput
“invoice number-098888-JJHDR-INR-90000”

now i need amount after INR… how many digits it could be

[lrtetala (Lakshman Reddy)]

Hi @devasaiprasad_K

Try this

(?<=INR.)(\d+)

[vrdabberu (Varunraj Dabberu)]

Hi @devasaiprasad_K

Try this:

(?<=invoice number\-\d+\-?[A-Z]+\-\w+\-?)\d+

Regards

[pravallikapaluri]

@devasaiprasad_K

invoice number-098888-JJHDR-INR-90000

@devasaiprasad_K

(?<=invoice\snumber\-\d+\-[A-Z]+\-\w+\-)\d+

[lrtetala (Lakshman Reddy)]

@devasaiprasad_K

[vrdabberu (Varunraj Dabberu)]

Hi @devasaiprasad_K

If the regular expression works for you, please mark my post as solution to close the loop or if you have any queries, I’m happy to help.

Regards

[devasaiprasad_K]

thanks for the shortest sol