Sage 100

During a VI export, how can I remove the remove the decimal from the dollar amount? I still want the full amount (dollars and cents), just not the decimal in the exported file.

Try using a field that calculates from the field with the decimal. Then use a formula to strip out the decimal.

Or mulitply the amount by 100.

Create a temporary field. Use STP() function to strip the decimal

Oh @JeffSchwenk just said that :-)

I've used this to replace line feed characters annd assume it would work for other characters too: In the export, export the field to a Temp001$ variable using the operation Assign. In the Calculation field for Temp001$, enter SUB(table.field,""."","""") A period in the middle set of quotes, and nothing in the last set. Without testing, you might have to convert the number to a string value first before applying this sub formula.

Thanks everyone for the quick responses! Got it. Cindy

What was the ultimate solution?

Jeff-Since I'll be adding perform logic to sum this numeric field, I opted to use the multiply by 100 calc to remove the decimal.

I won. :-)

The group is not a competition, it is about sharing ideas so that the rising tide raises all boats. I actually liked the simplicity of your idea better. It reminds me of Access PTQ's and Pivot tables............

Jeff - Do you do anything other than Access PTQs and Pivot Tables?

He just likes to mention them whenever possible.... ;-)

Yes, he posts snarky posts. And visits Mickey and taunts others about it.

No Access PTQ's and Pivot tables have allowed me to live the good life! Time to drink the Kool Aid. Come on in, the water is warm! And believe it or not, I did NOT see Mickey this time. Snarky? This is snarky?

Snarky is your middle name. Jeffrey Snarky Schwenk.

At least, spell my first name correctly, please!

Sorry! Jeffro.

Apparently, Schwenk is Prussian for Snarky too. :)

Sigh!

What's wrong with snarky???

When I'm not being sarcastic or ironic, I'm usually being snarky myself.

There is a high correlation coefficient between facial hair and snarkiness.

Oops. I've reexamined the data. There is a perfect correlation coefficient between facial hair and snarkiness.