Regex get string end with/not with number

Help
1

Hi,

PDF:

I have a string array and for each item,

I need to get all lines end with not a number (manager)
I need to get all lines end with a number (employee)

For the string array, it will be (not in array format below but that’s the idea)

1manager
employee1
employee2
employee3

2manager
employee4
employee5
employee6

and output to CSV

help please~

2

I got
^.\D$
^.\d$

test now~

3

Hi @lavint

To get the lines end with not a number use below regex

\d(.+)

To get the lines end with a number use below regex

(.+)\d

To try the above regex use https://regex101.com/

4

Hi,
for my expression, it didn’t work. Tested in that site too though…
I edited it to ^.*\d(.+) and returns nothing

For yours it only return the number, I need the whole line. can you help please?
Thanks

5

ok, I removed ^ and it works

6

image

image

see the above screenshots

7

Hi

Sorry, the whole thing is not exactly like that…
It is

Peter
Banana 1
Apple 2

Craig
Banana 4
Apple 5

I am able to get the ones with the number at the end but not the ones WITHOUT a number at the end.

I need to get Peter and Craig

And interesting thing is
.*\d(.+)

returns me

Banana 4
Apple 5
on UiPath

8

image

[A-Za-z]+(?=\n)

9

Hi,

hm

It is actually Peter, Smith
I tried .*\D(?=\n) and it doesn’t have a match… It matches on regex101.come though

anyway. can’t attach txt

Ander, Gary
dod, N’ona 7
Br, Judy 2
Nan, Kelly 2
Page, Deri 3
Perry, Robert P 1
Benson, Marry Rose, Michelle 1
Art, Ha

10

image

11

I will trim it and try again later. Thanks a lot