Printing Only Numbers From Mixed Data

Legacy Poster

• 2014年04月03日 13:17

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

• 

  Michael Toupin (mtoupin

  ★ BarTender Hero ★

  • 2014年04月03日 22:06

  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

サインインしてコメントを残してください。