Hello,
This is a sample of my data:
*********************************
MILLER-FINCH
BUTLER
MALDONADO1
DIXON1
MILLER-FINCH
MILLER-FINCH
BLUE SKY
ERDOGLYAN
TOLAND
MILLER-FINCH
CRAIG1
MOORE1
MILLER-FINCH
MILLER-FINCH
**********************************
I am trying separate the 11th character and on. For example:
MILLER_FIN CH
BUTLER
MALDONADO1
DIXON1
MILLER_FIN CH
MILLER_FIN CH
ERDOGLYAN
..........
With a Macro or Replace comand
Can anyone help...
Thanks,
Sam
10 Characters only
Moderators: AmigoJack, bbadmin, helios, Bob Hansen, MudGuard
-
Thomas Schremser
Re: 10 Characters only
Hi Sam!
You can use the following regular expression
Find what: \(.\{10\}\)\(.*\)
Rplace with: \1 \2
Greetings from Austria
Thomas
You can use the following regular expression
Find what: \(.\{10\}\)\(.*\)
Rplace with: \1 \2
Greetings from Austria
Thomas
-
Roy Beatty
Re: 10 Characters only
Consider a minor improvement: anchor the find string to the beginning of the line.
Find:::: ^\(.\{10\}\)\(.*\)
Replace:: \1 \2
Find:::: ^\(.\{10\}\)\(.*\)
Replace:: \1 \2
-
Susan Hunt
Re: 10 Characters only
can also do much easier: (for non techies)
set wrap off, block mode on
highlight the columns u want moved over,
& on down thru last line to be affected
& with the box still highlighted,
either press u tab key, or the right indent button on u toolbar.
this tabs the whole box over however wide u tab default is.
highlight u inserted tabs
ctrl-h (replace)
& replace the tab
with the # of spaces u really want here.
set wrap off, block mode on
highlight the columns u want moved over,
& on down thru last line to be affected
& with the box still highlighted,
either press u tab key, or the right indent button on u toolbar.
this tabs the whole box over however wide u tab default is.
highlight u inserted tabs
ctrl-h (replace)
& replace the tab
with the # of spaces u really want here.