cworley
Member
Hi All,
I need to create a .DAT file to be transmitted. It is an 80 Char ASCII file with numbers needing to be zero filled. I need to format the data as YYYYMMDD. I have written a report to do this, but do not know how to zero fill a number and how to force the date into the needed format.
Also, whenever I choose the output to CSV file, JDE takes me to Excel which plays havoc with my data layout. (Since some of my numeric data is quite long, it throws it into scientific notation or something similar). At this point, I could save it to text, but I would have to reformat all my Excel columns to get my proper file layout back. Does anyone have a suggestion on an easier way to do this, or had a similar situation?
Thanks.
I need to create a .DAT file to be transmitted. It is an 80 Char ASCII file with numbers needing to be zero filled. I need to format the data as YYYYMMDD. I have written a report to do this, but do not know how to zero fill a number and how to force the date into the needed format.
Also, whenever I choose the output to CSV file, JDE takes me to Excel which plays havoc with my data layout. (Since some of my numeric data is quite long, it throws it into scientific notation or something similar). At this point, I could save it to text, but I would have to reformat all my Excel columns to get my proper file layout back. Does anyone have a suggestion on an easier way to do this, or had a similar situation?
Thanks.