asked on Crystal Reports - Trim Data
Hello,
I’m wanting to trim a field.
I have a product code like the following:
100003.BLK.SML
104+YEL+LRG
1005-GRE-XLG
I need to trim the code so it appears like below taking into account the following characters . + / * -
100003
104
1005
The code length can’t exceed 16 characters.
Thank you
I’m wanting to trim a field.
I have a product code like the following:
100003.BLK.SML
104+YEL+LRG
1005-GRE-XLG
I need to trim the code so it appears like below taking into account the following characters . + / * -
100003
104
1005
The code length can’t exceed 16 characters.
Thank you
Crystal Reports
Last Comment
jspc
what's your backend database? are you able to manipulate the data from backend source instead?
ASKER
SQL Database
DO you just need the leading numeric part?
If so use
If you want it as a string use
mlmcc
If so use
Val({YourField})
If you want it as a string use
CStr(Val({YourField}),0)
mlmcc
ASKER
yes just front front part as per my example
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
My String formula will result in a comma
use
use
1:CStr(Val({YourField}),0,'')
ASKER
Bingo! Thanks