General questions about using TextPad
Moderators: AmigoJack, bbadmin, helios, Bob Hansen, MudGuard
-
steve1040
- Posts: 39
- Joined: Fri Oct 13, 2006 2:19 am
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