Home > IT Answers > AS/400 > CRTCSVDTA
RamvishakRamesh
1,955 pts.
 CRTCSVDTA
AS/400
I am making a CSV file from a PF which has a character field which holds a numeric decimal data. Eg 9,500.000000. But when it becomes a csv data, the value became 9.500.000000. (',' is converted to a period) I can see FLDDEL ',' and a RPLFLDDEL '.' as default. I dont want to convert the comma in the string which holds numeric data. Please help

Software/Hardware used:
AS400
ASKED: October 18, 2012  11:38 AM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question. Michael Tidmarsh   11,400 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

I dont want to convert the comma in the string which holds numeric data.
 
Then you can’t use FLDDEL ‘,’ and a RPLFLDDEL ‘.’. What alternatives are available for RPLFLDDEL?
 
If you can’t change RPLFLDDEL to *NONE or to some similar value, you must either not use CRTCSVDTA or not have numeric values in character fields that have commas in them. Remove the comma or use a different command.
 
Tom

TomLiotta
 108,105 pts.