Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

remove a comma from a field in Crystal 1

Status
Not open for further replies.

kdied

Technical User
Apr 12, 2012
7
US
(BarcodeC128Auto(cstr(totext({PV_ItemPacking.RollProducts} * {PV_ItemPacking.OuterUnitQty},0))))
This formula returns a barcode that scans with a comma. I need a formula that will delete the comma as is lengthens the barcode too much.
I can't do this in format field, because it is an integer field.
Any help would surely be appreciated! Thanks
 
I assume its this bit which introduces comma

totext({PV_ItemPacking.RollProducts} * {PV_ItemPacking.OuterUnitQty},0)

just add an extra argument

totext({PV_ItemPacking.RollProducts} * {PV_ItemPacking.OuterUnitQty},0, "")

This forces totext() to NOT use a thousand separator.

Ian
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top