Warren, would it be possible to create three fields for the three bits of information and then combine them into the "real" field using a filter?
Drew SCAB Honduras On Thu, Feb 20, 2014 at 8:45 AM, Warren R. Baltimore II < warrenbaltim...@gmail.com> wrote: > ** > Thanks folks! John, the quotes were added by excel. I tried taking them > out to see if that affected it, but no go.... > > Fred, I'll pull a .arx and see if I can't replicate it. > > Warren > > On Wed, Feb 19, 2014 at 5:18 PM, Reiser, John J <john.j.rei...@lmco.com>wrote: > >> ** >> >> 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 <arslist@ARSLIST.ORG>] *On Behalf Of *Warren >> R. Baltimore II >> *Sent:* Wednesday, February 19, 2014 4:08 PM >> *To:* 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 >> >> >> >> >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> > > > > -- > Warren R. Baltimore II > Remedy Developer > 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"
