Printing Only Numbers From Mixed Data 追蹤

0
Avatar
Legacy Poster

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

1 意見

0
Avatar
Michael Toupin (mtoupin
評論操作 永久連結

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.

登入寫評論。