topic Re: File Conversion From XLS format to TEXT format in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/file-conversion-from-xls-format-to-text-format/m-p/5008018#M1165876 <HTML><HEAD></HEAD><BODY><P>Avik,</P><P></P><P>If your query has been resolved, please close the thread.</P><P></P><P>Regards,</P><P>Nitin.</P></BODY></HTML> Thu, 15 Jan 2009 06:53:30 GMT Former Member 2009-01-15T06:53:30Z File Conversion From XLS format to TEXT format https://community.sap.com/t5/application-development-and-automation-discussions/file-conversion-from-xls-format-to-text-format/m-p/5008011#M1165869 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>Could You please let me know if there is any standard program that can be used to convert XLS format input file to TEXT format..Other wise could you provide me a code for that .</P><P></P><P>Thanks &amp; Regards</P><P>Avik.</P></BODY></HTML> Thu, 15 Jan 2009 05:54:43 GMT https://community.sap.com/t5/application-development-and-automation-discussions/file-conversion-from-xls-format-to-text-format/m-p/5008011#M1165869 Former Member 2009-01-15T05:54:43Z Re: File Conversion From XLS format to TEXT format https://community.sap.com/t5/application-development-and-automation-discussions/file-conversion-from-xls-format-to-text-format/m-p/5008012#M1165870 <HTML><HEAD></HEAD><BODY><P>Hi Avik,</P><P></P><P>Try FM <STRONG>TEXT_CONVERT_XLS_TO_SAP</STRONG></P><P></P><P>Regards,</P><P>Nitin.</P></BODY></HTML> Thu, 15 Jan 2009 06:01:21 GMT https://community.sap.com/t5/application-development-and-automation-discussions/file-conversion-from-xls-format-to-text-format/m-p/5008012#M1165870 Former Member 2009-01-15T06:01:21Z Re: File Conversion From XLS format to TEXT format https://community.sap.com/t5/application-development-and-automation-discussions/file-conversion-from-xls-format-to-text-format/m-p/5008013#M1165871 <HTML><HEAD></HEAD><BODY><P>Hi...</P><P></P><P>use TEXT_CONVERT_XLS_TO_SAP as suggested by nitin..that from that internal table</P><P>use GUI_download to convert that into text..</P><P></P><P>regards</P><P>vivek</P></BODY></HTML> Thu, 15 Jan 2009 06:04:40 GMT https://community.sap.com/t5/application-development-and-automation-discussions/file-conversion-from-xls-format-to-text-format/m-p/5008013#M1165871 Former Member 2009-01-15T06:04:40Z Re: File Conversion From XLS format to TEXT format https://community.sap.com/t5/application-development-and-automation-discussions/file-conversion-from-xls-format-to-text-format/m-p/5008014#M1165872 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>try these below Funtion Modules,</P><P></P><P>TEXT_CONVERT_CSV_TO_SAP</P><P>TEXT_CONVERT_TEX_TO_SAP</P><P>TEXT_CONVERT_TXT_TO_SAP</P><P>TEXT_CONVERT_XLS_TO_SAP</P><P>TEXT_CONVERT_XML_TO_SAP</P><P></P><P>Regards,</P><P>Anki Reddy</P></BODY></HTML> Thu, 15 Jan 2009 06:09:18 GMT https://community.sap.com/t5/application-development-and-automation-discussions/file-conversion-from-xls-format-to-text-format/m-p/5008014#M1165872 Former Member 2009-01-15T06:09:18Z Re: File Conversion From XLS format to TEXT format https://community.sap.com/t5/application-development-and-automation-discussions/file-conversion-from-xls-format-to-text-format/m-p/5008015#M1165873 <HTML><HEAD></HEAD><BODY><P>hi</P><P></P><P>just open the file in excel and save as "text tab delimited file" and give the file extention as .txt.</P><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Aakash Banga</P></BODY></HTML> Thu, 15 Jan 2009 06:15:46 GMT https://community.sap.com/t5/application-development-and-automation-discussions/file-conversion-from-xls-format-to-text-format/m-p/5008015#M1165873 Former Member 2009-01-15T06:15:46Z Re: File Conversion From XLS format to TEXT format https://community.sap.com/t5/application-development-and-automation-discussions/file-conversion-from-xls-format-to-text-format/m-p/5008016#M1165874 <HTML><HEAD></HEAD><BODY><P>thank you</P></BODY></HTML> Thu, 15 Jan 2009 06:34:59 GMT https://community.sap.com/t5/application-development-and-automation-discussions/file-conversion-from-xls-format-to-text-format/m-p/5008016#M1165874 Former Member 2009-01-15T06:34:59Z Re: File Conversion From XLS format to TEXT format https://community.sap.com/t5/application-development-and-automation-discussions/file-conversion-from-xls-format-to-text-format/m-p/5008017#M1165875 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Upload Excel file and download GUI_DOWNLOAD as txt file.</P><P></P><P></P><P></P><P></P><P></P><P>Regards</P><P>Md.MahaboobKhan</P></BODY></HTML> Thu, 15 Jan 2009 06:51:16 GMT https://community.sap.com/t5/application-development-and-automation-discussions/file-conversion-from-xls-format-to-text-format/m-p/5008017#M1165875 Former Member 2009-01-15T06:51:16Z Re: File Conversion From XLS format to TEXT format https://community.sap.com/t5/application-development-and-automation-discussions/file-conversion-from-xls-format-to-text-format/m-p/5008018#M1165876 <HTML><HEAD></HEAD><BODY><P>Avik,</P><P></P><P>If your query has been resolved, please close the thread.</P><P></P><P>Regards,</P><P>Nitin.</P></BODY></HTML> Thu, 15 Jan 2009 06:53:30 GMT https://community.sap.com/t5/application-development-and-automation-discussions/file-conversion-from-xls-format-to-text-format/m-p/5008018#M1165876 Former Member 2009-01-15T06:53:30Z Re: File Conversion From XLS format to TEXT format https://community.sap.com/t5/application-development-and-automation-discussions/file-conversion-from-xls-format-to-text-format/m-p/5008019#M1165877 <HTML><HEAD></HEAD><BODY><P>Thanks all for the inputs .</P><P>Actually my req is to covert XLS to SWIFT MT940 format in text file does any body has a sample pgm that does it</P><P>It will be a real help.</P></BODY></HTML> Thu, 15 Jan 2009 07:10:52 GMT https://community.sap.com/t5/application-development-and-automation-discussions/file-conversion-from-xls-format-to-text-format/m-p/5008019#M1165877 Former Member 2009-01-15T07:10:52Z