Ask Your Question
0

Remove last digit from a number if longer than 5 numbers?

asked 2019-03-16 06:52:41 +0200

Lika gravatar image

Greetings, Having problems understanding how to remove last digit from numbers inside a column.

172093
172069
17209
172182
172137
172116
172142
172283
172362
172344
17231
171474
171613
171632
171464
171311
171582
17152
171473
17116
171085
171241
171189
171328
171118
171295
17127

As you can se there are 5 digit numbers and those will stay unaltered, but what I am trying is to remove the last digit from the numbers with 6 digits. How?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-03-16 07:48:36 +0200

Using Find&Replace dialog's regular expressions:

Find ^(\d{5}).*

Replace with $1

image description

edit flag offensive delete link more

Comments

You wont believe how long I have tried to find a solution. I salute you and thank you dearest for helping me out. Regular expression is a must to learn I have noticed, powerful it is.

Lika gravatar imageLika ( 2019-03-16 07:53:56 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-03-16 06:52:41 +0200

Seen: 26 times

Last updated: Mar 16