tag:blogger.com,1999:blog-2807403883562053852.post503269627643617593..comments2024-03-27T08:40:31.785-06:00Comments on Clayton Cramer.: Modest Request for HelpClayton Cramerhttp://www.blogger.com/profile/03258083387204776812noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-2807403883562053852.post-35230887568583158922018-10-05T07:25:04.045-06:002018-10-05T07:25:04.045-06:00Is the output format for Access also CSV? If so th...Is the output format for Access also CSV? If so this shouldn't be too hard to do.<br /><br />Can you post examples of the input and of some of your desired output (preferably an example of each of the possible input variations).<br /><br />This should be fairly straightforward to write in Python, which has a csv module for importing and exporting.<br /><br />You say one of the fields is a list of comma separated types. How are these expressed in the original csv, are they quoted so that they end up in one csv 'field'?<br /><br />coderpunkhttps://www.blogger.com/profile/15780416627307204084noreply@blogger.comtag:blogger.com,1999:blog-2807403883562053852.post-12529541997890088662018-10-05T06:01:28.256-06:002018-10-05T06:01:28.256-06:00Clayton,
You might want to give DataWrangler ...Clayton,<br /><br /> You might want to give DataWrangler a try. It is a tool developed at Stanford University, and is intended to help with data cleaning and transformation. The developers have moved on to a newer, commercial version, but their free tool may be of use to you.<br /><br /> http://vis.stanford.edu/wrangler/<br /><br /> Cheers,<br /> Rusty MillerRusty Millerhttps://www.blogger.com/profile/03991593634610308518noreply@blogger.comtag:blogger.com,1999:blog-2807403883562053852.post-61926198931324849472018-10-05T05:02:44.100-06:002018-10-05T05:02:44.100-06:00Clayton, would a Perl solution work for you? (I th...Clayton, would a Perl solution work for you? (I think you've mentioned having Linux around.)<br /><br />If so, could you clarify what you mean by "these two columns"? The preceding sentences only refer to a single column.<br /><br />If you would prefer to take this off-blog, please feel free to e-mail: sand.paul@gmail.comPaul Sandhttps://www.blogger.com/profile/06175388613093409161noreply@blogger.comtag:blogger.com,1999:blog-2807403883562053852.post-8690305060785576792018-10-05T00:11:49.359-06:002018-10-05T00:11:49.359-06:00I can help. Do you just need the file converted, o...I can help. Do you just need the file converted, or do you need the program (or script) itself so you can use it on other data sets? I can do either. My email is thenders1966@gmail.com. (I've helped out before on a couple of your other projects.)Timhttps://www.blogger.com/profile/02289300732340966056noreply@blogger.com