Perhaps it was a spelling mistake and "Textpad" was meant. .......................................................... Mit freundlichem Gruß / Kind regards Robert Kern Siemens AG Siemens VDO Automotive SV IO CW PD Sodener Straße 9 65824 Schwalbach Germany Tel. +49 619 687 2546 Fax +49 619 687 792 546 E-Mail: [EMAIL PROTECTED] Internet: http://www.siemensvdo.com
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mario Roehr Sent: Wednesday, September 13, 2006 8:54 AM To: [email protected] Subject: Re: saving data as csv file Hi Joanne, I searched the internet for this tool called taskpad but could not find it. Can you give me a link where to download this tool or any other way to find it. Thanks in advance. Regards Mario Joanne Mansur <[EMAIL PROTECTED] > To Sent by: "Action [email protected] Request System cc discussion list(ARSList)" Subject <[EMAIL PROTECTED] Re: saving data as csv file ORG> 12.09.2006 22:30 Please respond to [EMAIL PROTECTED] RG I open files using taskpad (freeware download) - it's easy to read and doesn't lose the formatting. We have a special field for emplid which can have leading zeros and often causes chaos when someone opens the import file in excel and saves it. All the zeros disappear. Since I've strongly encouraged the use of taskpad the havoc has been lessened. HTH Joanne Mansur Client Systems Analyst Northeastern University Phone\617.373.3295 Fax\617.373.5985 [EMAIL PROTECTED] Ron Fariss <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> To [EMAIL PROTECTED] RG 09/12/2006 04:22 PM cc Subject Please respond to Re: [ARSLIST] [email protected] saving data as csv file Mimi, There are 2 methods for opening a .csv file to see if your formatting is correct. More work / Easier to Read - Rename the .csv file to .txt and then open the new file in Excel and pay special attention to the format for each column. Less work / Harder to Read - Open the .csv file with notepad. Hope this helps. Ron Fariss AIG Technologies Remedy & TelAlert Administration Work: (713) 831-2365 Cell: (281) 782-0979 Ricki Haines <[EMAIL PROTECTED] To: [email protected] DICAL.COM> cc: Sent by: "Action Subject: Re: saving data as csv file Request System discussion list(ARSList)" <[EMAIL PROTECTED] ORG> 09/12/2006 03:08 PM Please respond to arslist Mimi, If you mean you're losing the formatting of the xls file when saving as a csv file, here's the fix. If you've already changed the cell formats in xls, do it again in the csv file (date formats, etc.). When everything looks the way you want it, save the csv file and DON'T OPEN it again to see if it's still formatted properly. If you do you'll see that the format has been lost and you'll need to format again. If you have a Case ID with leading zeroes, change the format of those to Custom and enter 000000000000000 (15 0's) or however many you have as your input length. It took me a while to get the hang of this, but now I have no problem importing into Remedy. HTH, Ricki Haines On Tue, 12 Sep 2006 12:00:18 -0700, Mimi Lakew <[EMAIL PROTECTED]> wrote: Hello, I am trying to convert an xls file to csv file so I can import the data in remedy as csv file. Can anyone tell me how can I convert the file please? Thanks! _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
