Who's On?

	Membership:
	Latest: Brady
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5274

	People Online:
	Visitors: 710
	Members: 0
	Total: 710

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1375
Roger French	1315
mark.cook	1244

Getting a garbage value 20202020202 .02 ,while printing to a CSV

5 Replies

0 Subscribed to this topic

68 Subscribed to this forum

Sort:

Author

Messages

Vijay S

Veteran Member Send Private Message

Posts: 174

5/3/2011 10:26 AM

Hello,

I am getting a garbage value 202020202.02 in the amount fields whose debit and credit values value are zeroes, while printing to a CSV file. I have already initialized that field in the CSV but not working. I checked, using display statements, it is picking up the correct values, also calcuating current values but while priniting it prints up 202020202.02 from nowhere. It is occuring for only those account values which have zero credit and debit account.

Any idea ?

Thanks- Vijay

John Henley

Posts: 3351

5/3/2011 12:21 PM

Sounds like the amount field is not being initialized although you say you did. Are you using a CSV workfile or is this a printfile you are saving as CSV?=

Vijay S

Veteran Member Send Private Message

Posts: 174

5/4/2011 2:53 PM

Thanks John, I am using a CSV file, Here i am calculating the Balance sheet amounts period wise for the current fiscal year, For the initial amounts whose balance sheet amounts are null these amounts are coming from nowhere, after that everything is coming out fine.

John Henley

Posts: 3351

5/4/2011 6:51 PM

What you are seeing is an uninitialized (i.e. NULL) amount, so you must not be initializing the CSV record at the beginning of your program.

Sampath S

Basic Member Send Private Message

Posts: 17

5/6/2011 8:20 AM

John is correct Vijay you need to initialize those two amount fields at last just before writing to CSV and only if the account values which have zero credit and debit account. See example below...

Eg: IF (WS-DEBIT-ACCT = 0)
MOVE 0 TO CSV-AMT-FIELD
ELSE
MOVE WS-VALUE TO CSV-AMT-FIELD
END-IF.

--Sam

Vijay S

Veteran Member Send Private Message

Posts: 174

5/6/2011 1:24 PM

Thanks John/Sam, I got it..... I just initialized the CSV records and the begining, it worked fine

!!!!