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

I wanted to take a minute to write accolades for your employee Eric Lambeth. I have been calling on Eric for training and help in the Accuzip software since May and I want you to know that from a client standpoint, he is second to none! Eric has gone way above and beyond in helping me learn and navigate your software as well as helping us through some crazy situations we have encountered. It is clearly evident that he knows this software inside and out. It is also evident that Eric loves the customer and is willing to do whatever it takes to help – he has even answered emails and called me on the weekend to help through some stuff I was unsure of! I cannot express enough how wonderful Eric has been for our organization. I will tell you that I came to this organization with a background in BCC software with plans to transition to BCC software. Eric’s knowledge, guidance, training, and willingness to help at all hours of the day/week has sold me on Accuzip! Your software solution is more user friendly and the support staff far exceeds BCC! I am also looking forward to investigating your other software solutions.
S.M., Elmhurst, IL