changing the file format

[Former Member]

hi guys,

i hv a requirnment in which i need to read a file which is in .CGL format on a shared network path or application server which is nt possible to read directly so i need to first change the format of the file to .CSV and then read it using the FM KCD_CSV_FILE_TO_INTERN_CONVERT .

so plz tel me how to change the file extension

thanks

shivraj

[Jelena_Perfiljeva]

Not quite sure how you arrived at conclusion that CGL must be converted to CSV... CGL might turn out to be just a plain text file (e.g. many log files have .LOG extension but are just plain texts), in which case you can simply read it directly. Whether you'll be able to make sense of the file data - is another question and it depends on what is in that CGL file. Again, conversion to CSV might not even help.

If CGL file is a proprietary format, you might not be able to read it in SAP at all without using some third-party tool.

More info on CGL extension:

http://pcsupport.about.com/od/fileextensions/f/cglfile.htm

[Former Member]

actually this file is coming from concur and the client dont want 2 have any manual intervention while saving this file on the network path so our requirnement is to first change the file extension, also i tried to fetch data from .cgl file but i found it is not picking up all the data since its a very long file containing more than 38 columns

[Former Member]

answered by self