Unable to Extract the data from TEXT file

[sreene26]

Hi Team,

Im unable to extract the data from the text file (want to extract the 1440, 1080, 81, 8, 1, 320 values) please find the file
Original file.TXT (3.1 KB)

Thanks

[Parvathy (PS Parvathy)]

Hi @sreene26

Try this regex:

(?<=[A-Z]{1,}\d{1,}[A-Z]?\s+)\d{1,}(?=\s*\d{2,}\s{1,}\d*)

Hope it helps!!

[pravallikapaluri]

Hi @sreene26

(?<=[A-Z]{1,2}\d{1,}[A-Z]*\s+)\d+(?=\s+\d+\s+)

Hope it helps!!

[sreene26]

Can I Use this (?<=[A-Z]{1,}\d{1,}[A-Z]\s+)\d{1,}(?=\s\d{2,}\s{1,}\d*)
While L20231031AA
Please confirm

[Parvathy (PS Parvathy)]

Hi @sreene26
Your expression is right. Use this:

(?<=[A-Z]{1,}\d{1,}[A-Z]?\s+)\d{1,}(?=\s\d{2,}\s{1,}\d*)

Regards,

[sreene26]

its not working

[Parvathy (PS Parvathy)]

@sreene26

Try this:4

(?<=[A-Z]{1,}\d{1,}[A-Z]*\s+)\d{1,}(?=\s*\d{2,}\s{1,}\d*)

Regards

[vrdabberu (Varunraj Dabberu)]

Hi @sreene26

please use the below regex expression

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

Regards