Missing decimal

cdb123 · Post by **cdb123** » Wed Jan 21, 2004 8:40 pm

I have some code that is reading from a text file. In this text file, there is a field called amount. The amount contains a decimal (ie. 25.50). I read the variable just fine. However, when I send the variable using

Send>%amount% to field in my desktop app, The decimal is no longer there and the amount is incorrectly entered as 2,550.00. It was only doing it on one machine and was not doing it on my test machine. Now it is doing it on my test machine. My test machine is WinXP. It just started today. Have been working for weeks.

Bob Hansen · Post by **Bob Hansen** » Wed Jan 21, 2004 11:10 pm

In this text file, there is a field called amount.

I don't associate text files with fields unless you are talking about a text data file that is delimited? Problem may actually be in the desktop app.

Could use some more info here. What is the source file using for a delimiter? What are you using as a delimiter? How are you processing this file? Is it possible that parsing is having a problem between commas and periods as delimiters? What is the desktop app you are sending to? What can you tell us about the formatting of the field in the receiving app?

A sample of the macro code and a sample of the text file showing multiple lines would probably be very helpful to us.