Support 805.461.7300
Sales
Our Technology. Your Success.

Insert a comma into a number when the number is larger than 999

Description

This command is used to place commas into a field when the number in the field is greater than 999.

The command will make the following types of changes:

It will change 1000 to 1,000

100000 to 100,000

10000000 to 10,000,000

The Command

Replace all fieldname with IIF(LEN(ALLT(fieldname))>6 ,LEFT(ALLT(fieldname),LEN(ALLT(fieldname))-6)+","+SUBSTR(ALLT(fieldname),LEN(ALLT(fieldname))-5),ALLT(fieldname))
Replace all fieldname with IIF(LEN(ALLT(fieldname))>3,LEFT(ALLT(fieldname),LEN(ALLT(fieldname))-3)+","+SUBSTR(ALLT(fieldname),LEN(ALLT(fieldname))-2),ALLT(fieldname))

In this command, FIELDNAME represents the field that contains the number. Change the word fieldname to the name of the field in your database that you want this command applied to. Before running this command, make sure your field is wide enough to hold at least two extra characters. Pull down the Edit menu to Fields to find out.

« Back to Commands

You guys have indeed been great partners in aiding us with getting our mailings processed through your software and out the door.  I want to say we’ve been with you guys for at least 12 years now, if not longer.  Find something good you stick with it is how I see it.
P.H., Colorado Springs, CO