Forums for the Business Analyst

 
  Modern Analyst Forums  Business and Sy...  Data Analysis f...  Efficient Way to Clean csv File
Previous Previous
 
Next Next
New Post 6/13/2016 7:53 PM
User is offline Option2
1 posts
No Ranking


Efficient Way to Clean csv File 

Just wondering what would be an efficient way to clean up a .csv file where clients use comma in their data
For example, 123,456 or LastName, FirstName. These throws the whole conversion off and I have no better way other than import as delimited file first and manually dive in to delete the extra comma

Text qualifier would solve the issue but unfortunately that's not an option.

So what would be an efficient way to deal with this? 

 
New Post 6/14/2016 8:44 PM
User is offline NitWitNick
259 posts
5th Level Poster


Re: Efficient Way to Clean csv File 

For the number ... can't you import the data into Excel,

click on Format Cell,

Choose Number,

Decimal Places = 0

 

 Maybe too simple ... Just Guessing

 
Previous Previous
 
Next Next
  Modern Analyst Forums  Business and Sy...  Data Analysis f...  Efficient Way to Clean csv File

Community Blog - Latest Posts

Is Agile a reason to avoid documentation? I bet this question shows up again and again while working with product requirements. On one side, we have got long specifications, complicated diagrams, mystical technical design, too many prototypes and pretty obvious for engineers user guides (do we really need so much?). On the other side, can we actual...
The cloud-native application development has helped enterprises all around the globe reduce time-to-market, enhance performance, and develop agility and flexibility. Several enterprises are achieving these results by migrating their systems or traditional monolithic applications to the cloud. But to gain from the real benefits of cloud technology, ...
So you’ve found the perfect time and place to study and you’re ready to finally get some work done. You’ve pulled out your laptop, your textbook, and your notes, and four different highlighters. After five minutes of reading your textbook, you start zoning out and thinking about puppies. Then, you go on Tumblr and look at cut...

 



Upcoming Live Webinars




 

Copyright 2006-2021 by Modern Analyst Media LLC