IMPORTANT ANNOUNCEMENT

These forums were permanently set to read-only mode on July 20, 2022. From that day onwards, no new posting or comment is allowed on the site, but the historical content remains intact and searchable.

A new location for posting questions about PlanetPress Suite is now available:

OL Learn - PlanetPress Classic (opens in new tab)

Topic Options
#43195 - 04/22/13 05:31 AM REMOVE/TRIM in expressions
prexpresso Offline
OL Newbie

Registered: 01/10/12
Posts: 4
Loc: denmark
Hi, if i have a record like this:
eccobravo42-2349345

How do i get rid of "eccobravo42-" and just end up with "2349345"?

Can i do the same in the middle of a record name?
Eg. eccobravo42-2349345, where i want to get rid of "42",
and just end up with "eccobravo-2349345".

Top
#43197 - 04/22/13 08:52 AM Re: REMOVE/TRIM in expressions [Re: prexpresso]
Jeff_K
Unregistered


prexpresso,
The use of MID in logic can choose the values you indicate.
MID(Text, Start position, Size)

So something like:
MID([FIELD], 12, 7)
Will give you "2349345"

Appending the LEFT and MID will give you "eccobravo-2349345"
(LEFT([FILED],9)) & (MID([FIELD], , 7))

Please see the online help for more details on these instructions

http://help.objectiflune.com/en/printshop-mail-user-guide/Default_CSH.html#/463.html

http://help.objectiflune.com/en/printshop-mail-user-guide/Default_CSH.html#/459.html

Top
#43299 - 04/30/13 09:23 AM Re: REMOVE/TRIM in expressions [Re: ]
prexpresso Offline
OL Newbie

Registered: 01/10/12
Posts: 4
Loc: denmark
Hi Jeff, thanks a lot for helping me out,
with a good description.

Top