Community

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

Hi Sam!

You can use the following regular expression

Find what: \(.\{10\}\)\(.*\)
Rplace with: \1 \2

Greetings from Austria
Thomas

Consider a minor improvement: anchor the find string to the beginning of the line.

Find:::: ^\(.\{10\}\)\(.*\)
Replace:: \1 \2

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.