Printing Only Numbers From Mixed Data
I have a database field that can show up as different mixtures or text and numbers. It can be in the following formats:
WALL-MART 2769
WAL-MART DC 6012A-ASM DIS
My question is how would I get only the numbers to print on my label? We previously had been simply stripping off a certain number of characters on the left and right but that no longer works for the first example, which we've only recently been seeing.
Many thanks for any and all help.
Jeff
0
-
If you only want the numbers, select the data object, go under Transforms, select the box next to Character Filter, and specify Numeric only. That will strip off any non-numeric characters from the data.
0
Vous devez vous connecter pour laisser un commentaire.
Commentaires
1 commentaire