Re: Most streamlined method to get data

So to give you a full sense of the ugliness of the CSV I am working with, here it is: (trying to add certain columns but because some columns have multiple "thousand dollar+ amounts, it throws doing an item count. Need to get rid of all dollar signs (easy) and all the commas that are part of a th

Re: Most streamlined method to get data

yikes. You probably did the same thing, but whenever I deal with this kind of scenario, I always work first to gain control of the delimiter without losing any data, So I set the rules of processing accordingly. Then when I know I have correctly changed the item delimiter, only then do I try to p

M1 Mac mini for LC: First Impressions

I'm finally getting a chance to post this, after setting up a brand new Mac mini recently to replace my old 2012 Mac mini. It's all about LC work, of course Origin: Made in Malaysia. If you need a Mac Not-Made-in-China, and can't afford Mac Pro, this is it! (Ethically sourcing my hardware n

Re: Most streamlined method to get data

On 8/1/21 12:39 PM, Skip Kimpel wrote: So to give you a full sense of the ugliness of the CSV I am working Urk. Any chance of getting the csv delivered to you as tab-separated instead of comma-separated? That would at least take some of the burden away. -- Mark Wieder ahsoftw...@gmail.com

Re: Most streamlined method to get data

It looks like all the "thousand dollar+" amounts are quoted - i.e. it's an example of a regular CSV file - ugly but predictable. Did you try the CSVToTab converter ? https://github.com/macMikey/csvToText Alex. On 01/08/2021 20:39, Skip Kimpel via use