Warren, Are the double quotes that you displayed actually in the cell? I would think they encapsulate the CR.
Fred's idea is probably the best and not too hard to implement. Thank you, --- John J. Reiser Remedy Developer/Administrator Senior Software Development Analyst Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Wednesday, February 19, 2014 5:13 PM To: arslist@ARSLIST.ORG Subject: EXTERNAL: Re: ARS 6.3 import question ** I would convert it to an ARX format The difference between CSV and ARX is not that great. In ARX the line break is \n in the text. The separator is a space instead of a comma. (and there is a couple of extra header lines) Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Warren R. Baltimore II Sent: Wednesday, February 19, 2014 4:08 PM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: ARS 6.3 import question ** I have been batting this around for a bit. I feel like I've done this before, but I can't seem to figure it out. I've got a .csv file that needs to be imported into remedy. I'm using the arimport tool. It's a straightforward file with one exception. One row has a line break in each entry. It is VERY important that this be maintained in the exact same format it is being entered. For example, an entry may say: "Functional Role iPhone replace blackberry" It must be placed into the field so that a check can be run against it in an attempt to find a previous entry. The problem that I am having is that the import tool is treating the line break as the end of the entry. It then jumps to the next line (replace blackberry) and attempts to treat it as a separate entry. Any ideas on how I can handle this. I suspect that the .xml format is my answer, if so, any idea how I can (easily) convert the file? Thanks in advance! -- Warren R. Baltimore II Remedy Developer 410-533-5367<tel:410-533-5367> _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"