hi there!
how do it do the following?
i have a list
ACME WAREHOUSE
CYBERELECTRONICS
ENGINES AND SONS and so on
i would like to show only 6 letters from the beginning and the rest convert in dots:
ACME W........
CYBEREL.........
ENGINE. ... ....
thanks,
marti
CUT and REPLACE
Moderators: AmigoJack, bbadmin, helios, Bob Hansen, MudGuard
-
- Posts: 2461
- Joined: Sun Mar 02, 2003 9:22 pm
Tricky!
But you can do it using a conditional expression in the replacement expression:
But you can do it using a conditional expression in the replacement expression:
Look for Conditional expressions in the help under Reference | Replacement Format Syntax.Find what: (^.{6})|(.)
Replace with: ?1$1:?2.
[X] Regular expression
[X] Replacement format
Options
[X] '.' does not match a newline character