CSV string handling
Posted
by Christian Hagelid
on Stack Overflow
See other posts from Stack Overflow
or by Christian Hagelid
Published on 2008-08-07T05:49:04Z
Indexed on
2010/03/26
17:33 UTC
Read the original article
Hit count: 398
Typical way of creating a CSV string (pseudocode):
- create a CSV container object (like a StringBuilder in C#)
- Loop through the strings you want to add appending a comma after each one
- After the loop, remove that last superfluous comma.
Code sample:
public string ReturnAsCSV(ContactList contactList)
{
StringBuilder sb = new StringBuilder();
foreach (Contact c in contactList)
{
sb.Append(c.Name + ",");
}
sb.Remove(sb.Length - 1, 1);
//sb.Replace(",", "", sb.Length - 1, 1)
return sb.ToString();
}
I feel that there should be an easier / cleaner / more efficient way of removing that last comma. Any ideas?
Update
I like the idea of adding the comma by checking if the container is empty, but doesn't that mean more processing as it needs to check the length of the string on each occurrence?
© Stack Overflow or respective owner