You might have to enclose this field in double quotes. You could possibly do this by creating a separate hidden field, Then I believe the /n's won't create separate lines.
Lisa ________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Redick, Kevin Sent: Tuesday, January 20, 2009 6:31 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Search data export to xls ** Hello, I haven't ran into this problem myself however here is a link to a handy web page that shows such problems are not Remedy specific and may help with your solving of them. .. ://www.creativyst.com/Doc/Articles/CSV/CSV01.htm<http://www.creativyst.com/Doc/Articles/CSV/CSV01.htm> To sum it up, apparently you should be avoiding using manual linefeeds if possible, or at least if you want to easily convert around... Also depending if they are getting added to the csv file correctly, then importing in excel you may need manually import (or setup a script to do such), that used specific options rather than the default Excel will default to importing \n as a new field I believe. To test do Data-> Import select your file, then selectee delimited, hit next and you should be able to select only the , option as the limiter (or other options as desired) and hit finish. (Instruction may vary depending on exact version of excel etc, if you are even using excel). You should now hopefully have your data with the "/n" in the same/full fields. Hope this helps a little bit at least. --Kevin ________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Manish SINGLA Sent: Tuesday, January 20, 2009 4:29 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Search data export to xls ** Thanks Joe for replysing, Yes of course it's CVS option. problem is when i export to cvs my description value (if it is multiple lines with '\n') break into multiple rows. Can you please share how you avoid such situation. Thanks Regards Manish ________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Monday, January 19, 2009 8:05 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Search data export to xls ** What do you mean exported to xls??? There is only a csv option and I didn't have any problems with using the csv option except that leading 0's get truncated if you manipulate the file later using Excel and as a workaround I use Access to do that. Joe ________________________________ From: Manish SINGLA <manish.sin...@st.com> To: arslist@ARSLIST.ORG Sent: Monday, January 19, 2009 7:40:13 AM Subject: Remedy Search data export to xls Hello List, There is issue of description field, which get copied in multiple rows when exported to xls, through search result reporting. Please note when we perform following: 1. Search field value based tickets on "Helpdesk" table 2. Run report on search results 3. Try exporting data to xls When data get exported to xls, "\n" there in "Description" field breaks "description" field value to multiple row. I need a solution through which I can export text fields like "Description" to single cell of xls. Thanks Regards Manish __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ Please visit us at http://www.teletech.com ............................................................ This EMAIL and any attachments may contain confidential, proprietary and/or privileged information. If you are not the intended recipient, please immediately notify the sender by return email, and delete this communication and any copies. Any dissemination or use of this information by a person other than the intended recipient is unauthorized and may be subject to criminal and civil proceedings. Unless otherwise stated, opinions expressed in this email are those of the author and are not endorsed by TeleTech Holdings. ............................................................ __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
