Login

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 5: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 6: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

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

Community Blog - Latest Posts

Bekka Ball
Bekka Ball

Recipe Redesign: There Is No Box, Only Possibilities

I have always loved cooking. I learned from my Grandma June and her kitchen was her sanctuary, a small, warm sunlit space filled with jars of spices, stacks of cookbooks, and the comforting smell of something always on the stove or baking in the oven. Grandma June was as great a cook as she was a teacher to me. She never followed a recipe “to...
Lenny Steinman
Lenny Steinman

BPO Explained: A Smart Guide for Today’s Leaders

Now, I know, I don’t know what kind of new intro BPO may require, but at least I can promise you upfront that I have something different to say about Business Process Outsourcing or simply BPO. What is it? This hasn't been a call center job or a sales job as we all think. It is a mammoth profile, and firms are grappling to ge...
Victoria Ogunsanya
Victoria Ogunsanya

Leveraging Blockchain Technology for Enhanced Data Security in Business Operations

Leveraging Blockchain Technology for Enhanced Data Security in Business Operations
In an age where data breaches and cyberattacks are becoming more frequent and sophisticated, businesses are searching for robust solutions to safeguard their data. Blockchain technology has emerged as a promising tool in this quest, offering a way to secure data with unparalleled reliability. Although initially known for powering cryptocurrencies l...

 



Upcoming Live Webinars




 

brought to you by Modern Analyst Media LLC enabling practitioners & organizations to achieve their goals using:

Copyright 2006-2025 by Modern Analyst Media LLC