Hello,
How can I create a List of String from a CSV String?
For example, from:
"New York, London ,Lisbon ,Car,C# "
I would get a list with the following items:
"New York", "London", "Lisbon", "Car", "C#"
So I would take all words but ignore the spaces before and after a
comma but not the ones between words.
Should I make this with Regex?
Thanks,
Miguel 11 6779
On Thu, 26 Jun 2008 17:29:48 -0700, shapper <md*****@gmail.comwrote:
How can I create a List of String from a CSV String?
[...]
Should I make this with Regex?
I suppose you could. But IMHO, the Split() and Trim() methods of String
provide everything you need:
public List<stringCSVToList(string strInput)
{
string[] rgstrRecord = strInput.Split(new char[] { ',' });
List<stringlstrRet = new List<string>(rgstrRecord.Length);
foreach (string strColumn in rgstrRecord)
{
lstrRet.Add(strColumn.Trim());
}
return lstrRet;
}
No doubt there's a LINQ way to do all that that looks much nicer, but I've
been slacking and still can't write it off the top of my head. I'll learn
LINQ one day. :)
Pete
shapper wrote:
How can I create a List of String from a CSV String?
For example, from:
"New York, London ,Lisbon ,Car,C# "
I would get a list with the following items:
"New York", "London", "Lisbon", "Car", "C#"
So I would take all words but ignore the spaces before and after a
comma but not the ones between words.
Fundamentally:
Split
Trim
assign
C# 2.0:
public static List<stringSpecialSplit20(string s)
{
List<stringres = new List<string>();
foreach(string part in s.Split(','))
{
res.Add(part.Trim());
}
return res;
}
C# 3.5:
public static List<stringSpecialSplit30(string s)
{
return new List<string>(from part in s.Split(',') select
part.Trim());
}
Arne
On Jun 26, 5:29*pm, shapper <mdmo...@gmail.comwrote:
Hello,
How can I create a List of String from a CSV String?
For example, from:
"New York, London * ,Lisbon * *,Car,C# * *"
I would get a list with the following items:
"New York", "London", "Lisbon", "Car", "C#"
So I would take all words but ignore the spaces before and after a
comma but not the ones between words.
Should I make this with Regex?
Thanks,
Miguel
Miguel,
There are a number of CSV readers freely available. Here's my
favorite: http://www.codeproject.com/KB/databa...ricParser.aspx
I believe this one can read directly into a List<stringand includes: http://www.codeproject.com/KB/database/filehelpers.aspx
-Jay
On Jun 27, 1:44*am, "Peter Duniho" <NpOeStPe...@nnowslpianmk.com>
wrote:
No doubt there's a LINQ way to do all that that looks much nicer, but I've *
been slacking and still can't write it off the top of my head. *I'll learn *
LINQ one day. *:)
strInput.Split(',').Select(x =x.Trim()).ToList()
:)
Jon
On Jun 27, 1:52*am, Arne Vajhřj <a...@vajhoej.dkwrote:
<snip>
Just wearing my version number pedantry hat:
C# 3.5:
It's C# 3, not 3.5. I've got an article about the version numbers at http://csharpindepth.com/Articles/Ch.../Versions.aspx
(I know I've been doing a lot of this recently. I can understand if
it's slightly annoying, but I think it's for the best in the long run.
If other groupies would rather I stopped, please let me know.)
* * * * *public static List<stringSpecialSplit30(string s)
* * * * *{
* * * * * * *return new List<string>(from part in s.Split(',') select
part.Trim());
* * * * *}
I've just posted my version as a reply to Pete's post - I tend not to
bother with a query expression if I'm just using one operator (just
select, or a where followed by a no-op select). And ToList is
goodness :)
Jon
On Thu, 26 Jun 2008 22:54:58 -0700, Jon Skeet [C# MVP] <sk***@pobox.com>
wrote:
Just wearing my version number pedantry hat:
>C# 3.5:
It's C# 3, not 3.5. I've got an article about the version numbers at http://csharpindepth.com/Articles/Ch.../Versions.aspx
(I know I've been doing a lot of this recently. I can understand if
it's slightly annoying, but I think it's for the best in the long run.
If other groupies would rather I stopped, please let me know.)
For what it's worth, I find the version corrections useful, even if it's
unlikely I'm ever going to get everything memorized. If anything, as more
incremental versions come out, and as there become more combinations of
CLR, C#, and .NET versions available, I think it's more and more important
to be precise about which features require which versions.
Heck, just the other day I had to unconfuse myself about which .NET
versions include the various Action delegates, since it turns out two
showed up in 3.0 and the other three showed up in 3.5! I find it helpful
to have other folks piping up to keep me honest.
That said, I realize opinions may vary. That's just my two cents. :)
Pete
about which .NET
versions include the various Action delegates, since it turns out two
showed up in 3.0 and the other three showed up in 3.5!
2.0, surely? I could well be wrong, but Action<Tis used in
List<T>.ForEach since 2.0?
Marc
Just wearing my version number pedantry hat:
Now if only we could fix the number of books touting C# 2008 ;-p
Marc
On Fri, 27 Jun 2008 00:27:05 -0700, Marc Gravell <ma**********@gmail.com>
wrote:
>about which .NET versions include the various Action delegates, since it turns out two showed up in 3.0 and the other three showed up in 3.5!
2.0, surely? I could well be wrong, but Action<Tis used in
List<T>.ForEach since 2.0?
Yes, sorry. Typo.
However, I was mistaken. Only Action<Twas in 2.0. The rest all appear
to not have shown up until 3.5 (I mistakenly assumed that the
parameterless Action type had been around as long as Action<T>).
Pete
On Jun 27, 8:57*am, "Peter Duniho" <NpOeStPe...@nnowslpianmk.com>
wrote:
On Fri, 27 Jun 2008 00:27:05 -0700, Marc Gravell <marc.grav...@gmail.com>*
wrote:
about which .NET
versions include the various Action delegates, since it turns out two
showed up in 3.0 and the other three showed up in 3.5!
2.0, surely? I could well be wrong, but Action<Tis used in
List<T>.ForEach since 2.0?
Yes, sorry. *Typo.
However, I was mistaken. *Only Action<Twas in 2.0. *The rest all appear *
to not have shown up until 3.5 (I mistakenly assumed that the *
parameterless Action type had been around as long as Action<T>).
Pete
Thank you all!
For now I think I will use the Linq version.
It is short and it solves my particular problem.
But the other suggestions might be handy in the future.
Thank You,
Miguel
On Fri, 27 Jun 2008 04:24:20 -0700, shapper <md*****@gmail.comwrote:
For now I think I will use the Linq version.
It is short and it solves my particular problem.
But the other suggestions might be handy in the future.
Except for possibly Jay's, probably not. Jon's LINQ suggestion is
essentially identical to the code examples posted to this thread. It's
just a lot more concise. :)
Pete This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: massimo |
last post by:
Hey,
I wrote this program which should take the numbers entered and sort them
out. It doesnšt matter what order, if decreasing or increasing.
I guess I'm confused in the sorting part. Anyone...
|
by: Kent |
last post by:
Hi!
I want to store data (of enemys in a game) as a linked list, each node will
look something like the following:
struct node
{
double x,y; // x and y position coordinates
struct enemy...
|
by: Robin Cole |
last post by:
I'd like a code review if anyone has the time. The code implements a basic
skip list library for generic use. I use the following header for debug
macros:
/*
public.h - Public declarations and...
|
by: JS |
last post by:
I have a file called test.c. There I create a pointer to a pcb struct:
struct pcb {
void *(*start_routine) (void *);
void *arg;
jmp_buf state;
int stack;
};
...
|
by: chellappa |
last post by:
hi
this simple sorting , but it not running...please correect error for
sorting using pointer or linked list sorting , i did value sorting in
linkedlist
please correct error
#include<stdio.h>...
|
by: drewy2k12 |
last post by:
Heres the story, I have to create a doubly linked list for
class, and i have no clue on how to do it, i can barely create a
single linked list. It has to have both a head and a tail pointer,
and...
|
by: AZRebelCowgirl73 |
last post by:
This is what I have so far:
My program!
import java.util.*;
import java.lang.*;
import java.io.*;
import ch06.lists.*;
public class UIandDB {
|
by: Atos |
last post by:
SINGLE-LINKED LIST
Let's start with the simplest kind of linked list : the single-linked list which only has one link per node. That node except from the data it contains, which might be...
|
by: kalyan |
last post by:
Hi,
I am using Linux + SysV Shared memory (sorry, but my question is all
about offset + pointers and not about linux/IPC) and hence use
offset's instead on pointers to store the linked list in...
|
by: QiongZ |
last post by:
Hi, I just recently started studying C++ and basically copied an example in the textbook into VS2008, but it doesn't compile. I tried to modify the code by eliminating all the templates then it...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |