Our Training Programs

View all

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

All contents are copyright of their authors.

replace double quotes with single quotes in a csv file.

Home
Forums
Learn iOS Programming

replace double quotes with single quotes in a csv file.

Vikas Negi

8yAsked Sep 21, 2018, 3:48 AM1.3kLearn iOS Programming

Hi Folks ,

I have a request where we need to SFTP a CSV file after upting it. This CSV file consists of a column having XML data. This XML data is to be updated as below:

creating tags which works fine.but not able to replace " with '. Also "\"" splits the XML data.

if (line.Contains("<"))

{

line = line.Replace("<", "<");

}

if (line.Contains(">"))

{

line = line.Replace(">", ">");

}

if (line.Contains("\""))

{

line = line.Replace("\"", "\'"); (this wont work)

}

Can anybody help

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Amit Gupta8y ago
In addition, you don't have to put slash for using single quote, just put it in double quote and your issue will be resolved

Replace
line = line.Replace("\"", "\'"); (this wont work)
with
line = line.Replace("\"", "'");
Moreover, you don't have to check each line to replace each character, alternatively you can replace the whole text with your replacing character (if csv file is not too big)

Good Luck
Nitin Sontakke8y ago
A CSV file consists of a column having XML data. That sounds very very strange to me.

Can you please post the sample input file and an expected output.