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

Business Impact Analysis(BIA): Assessing the Potential Impact of a Cybersecurity Incident on Business Operations
In today’s highly interconnected society, businesses depend on technology even more than before. While offering opportunities for innovation and creativity, businesses are exposed to various cybersecurity threats that can disrupt operations, damage reputation, and result in substantial financial losses. It is crucial to carry out a comprehens...
In today's ever-evolving market, businesses must adapt swiftly to remain competitive and meet the needs of a fast-paced digital economy. Among the various business strategies available, digital transformation, customer-centricity, and sustainability have emerged as top priorities. Let’s explore why these strategies are critical for busine...
The Cisco Certified Network Associate (CCNA) certification is a pivotal credential for networking professionals, validating your skills in networking fundamentals, security, automation, and programmability. Preparing for the CCNA exam can be challenging, but with the right strategy, resources, and mindset, you can successfully achieve this certific...

 



Upcoming Live Webinars




 

Copyright 2006-2024 by Modern Analyst Media LLC