topic changing the file format in Application Development and Automation Discussions

changing the file format

Former Member — Tue, 31 Aug 2010 17:34:22 GMT

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

Re: changing the file format

Jelena_Perfiljeva — Tue, 31 Aug 2010 21:10:37 GMT

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

Re: changing the file format

Former Member — Wed, 01 Sep 2010 03:23:12 GMT

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

Re: changing the file format

Former Member — Thu, 24 Mar 2011 07:50:13 GMT

answered by self