Regular Expression question

Help Activities
, ,
1

Hi I am using the following look behind
(?<=Employee No. ).*\s
This is getting all of the following “Employee No. 1201974 Last Pay $0.00”
I do not need anything after 1201974. How can I fix this?

Thank you,

2

@A_Learner
(?<=Employee No. )\d+(?=.*\s)

3

Hey @A_Learner
Try this regex

(?<=Employee No. )\d+
image

4

@A_Learner

(?<=Employee No. ).*(?=\s[A-Z]+[a-z]+)

Regards

5

Hi @A_Learner

(?<=Employee No. ).*(?= Last)

image

or

(?<=Employee No. )\d+(?=.*\s)

image

image

I hope it helps!!

1 Like
6

@A_Learner

If you got the solution for your question. Please mark as solution to close the thread.

Regards,

7

Employee number can be digits, alpha with dashes.

8

@A_Learner

Please try this

9

@A_Learner
Try this
(?<=Employee No. )[A-Za-z0-9-]+(?=.*\s)

11

@A_Learner Ohh then u can use this regex, IT WORKS for alphanumeric and other combinations also

(?<=Employee No. )([a-zA-Z0-9]+)
Below is the tested screenshots
image
image
image

Hope it helps!

12

Thank you @lrtetala

Thanks every one!!!

1 Like
13

Thank you @vrdabberu

14

Thank you @Vikas_M for the great Regex.

15

Thank you, @pravallikapaluri

16

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