Hi Andy Could it be that your CSV file is wrapping some of the paths (with spaces in them) in quotes, and others (without spaces) not??
HTH David Sanders Remedy Solution Architect Enterprise Service Suite @ Work ========================== ARS List Award Winner 2005 Best 3rd party Remedy Application See the ESS Concepts Guide tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Monday, April 30, 2007 2:04 PM To: [email protected] Subject: Re: AR Import It's even weirder than I first thought. After closer examination I have found that it only does this to approximately 30% of the records. I can not find any pattern to it and it appears to be totally random at this time. I am exporting data from Remedy to .csv, making some modifications then importing back into Remedy via the import tool. After the import the "\"'s are missing from the paths on about 30% of the records. I have tried creating another temp char field and importing it, but I got the same results. >Andy L. Mayfield >System Operation Specialist >Alabama Power Company Office: 8-226-1805 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Vyom Labs - ITSM Support Sent: Thursday, April 26, 2007 12:23 PM To: [email protected] Subject: Re: AR Import Hi I am having ARsystem 7.x and gone through the same query that is one of the fields contain path (F:/ab/cd/efg/) and then exported the data & then by using AR Import tool imported the same on a new form but i have not found any error in this process, that is i have got the same path (F:/ab/cd/efg/) without removal of /'s. So please let me know the actual process in which you are facing the problem. Thanks, Rakesh -- [EMAIL PROTECTED] www.vyomlabs.com Consulting | Oursourcing | Training || BMC Remedy BSM | ITIL | IT Governance Mayfield, Andy L. wrote: > Ok, I am stumped. I used AR Import to import some data to a new form. > One of the fields contains paths i.e.. F:/abc/def/ghij/, but after > the import process removed the /'s and I am left with F:abcdefghij ? > Anyone know what I did wrong? > > Andy L. Mayfield > System Operation Specialist > Alabama Power Company > Office: 8-226-1805 > > ________________________________________________________________________ _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" > > ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
