Removing double quotes from the string array

Question

I am developing application that will convert csv files to xml files but the problem is with the input xml files,

Csv files : "a" ,"b","c"

Xml file : <A>"a"</A>

               <B>"b"</B>

------

 

Question : I am using string array for getting input csv files . How do we remove the "" from the string array? 

 

Answer 1

Hi,

you can use the .Trim() method of the String class like:

'Visual Basic 2008 - .net 3.5 - Any CPU
        Dim myStringArray As String() = {"""a""", """b"""}
        Dim trimCharArray As Char() = New Char() {""""c}
        For Each s As String In myStringArray
            s = s.Trim(trimCharArray)
        Next

 

---

Hannes

If you have got questions about this, just ask.

In a perfect world,
users would never enter data in the wrong form,
files they choose to open would always exist
and code would never have bugs.

C# to VB.NET: http://www.developerfusion.com/tools/convert/csharp-to-vb/

Answer 2

hii try this,

it may usefull for you

  string asda = @"<A>""a""</A>";
            var x=asda.Split('"');
            var xa = String.Join("", x);

---

By Sanz. -- If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".

Answer 3

Hi,

Try using it this way..

 strCSV.Replace('"',' ');
            string[] stringArray = strCSV.Trim().Split(',');

WHERE strCSV is your string from csv file.

Hope this helps.

Thanks!

---

Every day its a new learning. Keep Learning!!
If this post answers your question, please click Mark As Answer . If this post is helpful please click Mark as Helpful

Answer 4

Use a CSV library, such as this one.  There are a good many subtleties to CSV files - if you try to parse it yourself, you may be in for a long line of CSV files that are just not quite what your code was expecting.

---

-cd Mark the best replies as answers!