how to replace a comma with a space when it finds at every character

Question

1.00/5 (1 vote)

See more:

how to replace a comma with a space when it finds at every character
because my csv file contains comma in the data also

Posted 20-May-11 0:44am

lakshmichawala

Add a Solution

Comments

Sergey Alexandrovich Kryukov 20-May-11 21:17pm

Don't you understand that you don't formulate the problem?
You need to provide the information: how to tell the difference between comma as the delimiter between the data items and inside data. It may even happen that the data is invalid, so the problem may be non-solvable. How do we know that?
--SA

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Not Active · Answer 1 · 2011-05-20T00:53:00

Solution 1

There is no easy solution. Although you could use a simple string.replace it will find the commas in the data fields also not just the field separators.
You may want to look at this tool, http://www.filehelpers.com/[^]

Posted 20-May-11 0:53am

Not Active

Comments

Christoph Keller 20-May-11 8:26am

Thank you for the link, nice to know that such a library exists!
my 5+!

Have a nice day and happy coding,
Stops

**R. Giskard Reventlov** · Answer 2 · 2011-05-20T00:54:00

Solution 2

Read the file into a string and then content.Replace(",", " ") and save the result back to the file.

Posted 20-May-11 0:54am

R. Giskard Reventlov

Comments

[no name] 20-May-11 8:46am

That won't work. The OP has even said there are commas in the data. Think about it. If you have a scenario where there are three fields, id, name(first and last), date. and the name field is in the format last name, first name. How will string.Replace be able to determine the difference between the comma separating the ID and name field from the last name, first name data?

R. Giskard Reventlov 20-May-11 8:57am

Oops! You're right: my fault for not reading the question properly: good spot.