Remove thousands separator

[Former Member]

Post Author: Nick7

CA Forum: Formula

I have a formula which adds the * symbol at the beginning and end of a number. I then change the font to read as a barcode. My problem is the number contains a thousands separator, which is dividing the barcode into two sections, meaning it cannot be scanned.

How can I edit my formula to remove the thousand seperator? It curently looks like this:

''+ totext({OrderLine.OrderNumber},0) + ''

Hope someone can help.

Thanks

[Former Member]

Post Author: Nick7

CA Forum: Formula

Many thanks, adding the double quotes did the trick...

[Former Member]

Post Author: SKodidine

CA Forum: Formula

''+ totext({OrderLine.OrderNumber},0,'') + ''

[Former Member]

Post Author: sleahcim

CA Forum: Formula

Hi Nick,

This is just a guess, but have you tried putting double-quotes around the zero? "0"

Also, is your barcode number based on UPC? Since UPC is a 12-digit number, try replacing the "0" with "000000000000" .

-Michael