Add Decimal and remove '

General questions about using TextPad

Moderators: AmigoJack, bbadmin, helios, Bob Hansen, MudGuard

Post Reply
steve1040
Posts: 39
Joined: Fri Oct 13, 2006 2:19 am

Add Decimal and remove '

Post by steve1040 »

I have 2000+ rows of data that looks like this

'01000'
'01010'
'V4582'
'32729'
'3602'
'0066'

In every row I need to place the last 2 digits behind a decimal and remove the '

Thanks
ak47wong
Posts: 703
Joined: Tue Aug 12, 2003 9:37 am
Location: Sydney, Australia

Post by ak47wong »

Find what: '(.*)(..)'
Replace with: $1.$2
steve1040
Posts: 39
Joined: Fri Oct 13, 2006 2:19 am

Post by steve1040 »

Thanks!
That worked fine
Post Reply