REMOVE/TRIM in expressions - Objectif Lune Tech Support Self Help

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)

You are not logged in. [Log In] Objectif Lune » Forums » PrintShop Mail Suite 7 » PrintShop Mail Design » REMOVE/TRIM in expressions

Topic Options

#43195 - 04/22/13 05:31 AM REMOVE/TRIM in expressions
prexpresso 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 OL Newbie Registered: 01/10/12 Posts: 4 Loc: denmark	Hi Jeff, thanks a lot for helping me out, with a good description.
Top

Previous Topic

Index

Next Topic

Hop to:

Moderator: Alex Banahene, cosimo, Jean-Cédric, OL Newsgroup Support, OL Newsgroup Training, Philippe F., Raphael Lalonde Lefebvre