Regex find anything before string XY

[SSchmitz (Simon Schmitz)]

Hello Guys,

First: Thanks for helping so fast all the time!
I got another Regex Problem:
In the attached file I want to find the number 155987 it’s always followed by a -ÜZ and always 6 digits.
How do I find it?
Thanks!

[SSchmitz (Simon Schmitz)]

Einzahlungen.txt (345 Bytes)

[Pradeep_Shiv]

.*(?=-ÜZ)

[srdjan.suc]

As @Pradeep_Shiv said you can use \d{6}(?=- ÜZ)

[Pradeep_Shiv]

@SSchmitz

nks for helping so fast all the time!

Yes
@srdjan.suc

[Pradeep_Shiv]

if its working fine mark this as a solution and close this thread @SSchmitz

[Dipanshu (Dipanshu Rastogi)]

@SSchmitz:

You can also try (?<=-UZ).*

or for specific digit
((?<=-UZ)\d{6})
or for your data
\d{6}.*(?=-UZ)

[Pradeep_Shiv]

it’s going to give him the forward value of a string

[SSchmitz (Simon Schmitz)]

Hey Guys, Only with i get a solution. But I want to make sure only 6 digit numbers are grabbed. Thanks!

[srdjan.suc]

Then use the one that I posted.

[kadiravan_kalidoss (Kadiravan K)]

Hi @SSchmitz,

Try this,

(?<=(\n|\s))\d{6}(?=-ÜZ)

This will fetch only 6 digit numbers…!

regex6DigitNum.xaml (7.0 KB) Einzahlungen.txt (345 Bytes)

Thanks!