Hi Ron! CSVed is a small freeware tool and automatically keeps the leading zeroes. As a consultant working across many projects where you are confronted with requests to import data into Remedy from various legacy systems (that can only provide .csv files), you frequently get a lot of .csv files that must be checked for data quality and possibly minor manual correction before it can be fed to the Import Tool. So, I was looking for a small app that could allow me to view & edit .csv files without having to have to use Excel with all it's overboard automatic features such as truncating zeroes . CSVed was the closest thing I could find. It is function-rich, but it's version of "direct editing" is not as direct as I would like. I use it every now and then if I get large .csv files that I browse but do not need to edit.
Best Regards, Theo Sent from my Black/Silver Personal Computer .... "Try not to become a person of success, but a person of value." - Albert Einstein From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ron Tavares Sent: 29 June 2011 21:20 To: arslist@ARSLIST.ORG Subject: Re: Excel frustration with AIE and Data Imports ** All, Thank you for your responses. Michelle, thanks for listing out the steps. I was somewhat aware of this process, but felt there were too many clicks to make it worth the effort. BUT, you are correct, once I do it enough times, it becomes second nature. This is especially useful with large files. Theo, This tool looks pretty cool and could be exactly what I am looking for. I looked over the website, but I cannot download it where I am currently working. Will need to give it a try when I am home. Have you used it? Can you confirm that it can retain the leading zeros without having to go through a bunch of steps? Also, is there a cost or is this freeware? Thanks, .ron On Wed, Jun 22, 2011 at 1:39 PM, Theo Fondse <t...@remex.co.za<mailto:t...@remex.co.za>> wrote: ** Hi Ron! You could try CSVed to see if it works for you: http://csved.sjfrancke.nl/index.html Best Regards, Theo Sent from my Black/Silver Personal Computer .... "Try not to become a person of success, but a person of value." - Albert Einstein From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of Ron Tavares Sent: 22 June 2011 15:31 To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Excel frustration with AIE and Data Imports ** Good Morning Listers, You how when you open a .csv file in Excel, Microsoft will do it's magic and start changing the format of certain values? As an example, it will drop the leading zeros form a value because it assumes it is numeric, (like a serial number). So you have to fix the data, format the column as 'text' and save the file. Then, the next time you open the file, the process starts all over again. I know I can use notepad to edit, but that is a pain. So I have two questions: 1) Is there a way to set a preference in Excel to say "Hey! don't do that!" 2) Assuming the answer to question one is no, is there another tool out there that works like Excel but is geared toward developer geeks? Sort of like what Notepad is for Windows, except it would display the data in column/row. I know I would really like a tool like that. Thanks, .ron _attend WWRUG11 www.wwrug.com<http://www.wwrug.com/> ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com<http://www.wwrug.com/> ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
