Andy, Rename your .csv file to a .txt file.
Open Excel File: Open: name of the file. Use the delimited option and ensure that the Text field delimiter of " is set. At this point you should be able to read the data as it was produces Ron Fariss AIG Technologies Service Desk Automation 713-831-2365 (Office) 281-782-0979 (Mobile) -----Original Message----- From: "Action Request System discussion list(ARSList)" [mailto:[EMAIL PROTECTED] On Behalf Of "Mayfield, Andy L." Sent: Tuesday, May 01, 2007 7:43 AM To: arslist@ARSLIST.ORG Subject: Re: AR Import Ok, I have found out a few more details. You can't see it when viewing the .csv in excel, but when viewing in a text editor you can see that some of the paths are being enclosed in "". From what I can tell, it seems to be doing this to the paths that contain ","'s. It makes sense that it would since it is a , delimited file. It sees the "," in the cell and encloses the field in "'s. Now I have to figure out a way around it. So far I have been unsuccessful, but at least I know what and why it is doing it. Does anyone have any ideas as to how I can get around this? >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 David Sanders Sent: Tuesday, May 01, 2007 3:22 AM To: arslist@ARSLIST.ORG Subject: Re: AR Import 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: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG 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" ________________________________________________________________________ _______ 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"
