[veena_vb]

i have csv file witch contains 4 tableinfo
for example
csv file format is like this:
file:
dog details[keyword dog details is used in csv to identify dog details start after this]
dog1; AAA ;AAAA; AAA; AAAA
dof2; AAA ;AAAA ;AAA;AAAAA
CAt details [keyword cat details is used in csv to identify cat details start after this]
cat1; AAA ;AAAA; AAA; AAAA
cat2; AAA ;AAAA ;AAA;AAAAA
bAt details [keyword bat details is used in csv to identify bat details start after this]
bat1; AAA ;AAAA; AAA; AAAA
bat2; AAA ;AAAA ;AAA;AAAAA

output look;
dog1 AAA
dog2 AAA
cat1 AAA
cat2 AAA
bat1 AAA
bat2 AAA

how i could parse this csv file in C# to get each animal details separately based on keyword given? any idea?

This post has been edited by tlhIn`toq: 06 October 2012 - 12:15 PM

[tlhIn`toq]

looks like you just need to read the file and split at the ;

the output doesn't look hardly any different than the file.

have you coded anything? any attempt at all? what specific issue are you having with your code?

[AdamSpeight2008]

What about using TextFieldParser?

[veena_vb]

tlhIn`toq, on 06 October 2012 - 12:19 PM, said:

looks like you just need to read the file and split at the ;

the output doesn't look hardly any different than the file.

have you coded anything? any attempt at all? what specific issue are you having with your code?

yes i have done bit coding part but seems to messier
i could add the algorithm/steps wat i have used in my code...
1: read the file
2; read lines till end of stream
3: then split the line using delimiter ;
4: After split the line, check first string is dog or cat ot bat
5: then if it is cat i have written method to fetch dog info

butstill i m not happy with this,...is there any possibilities to do this in linq...can anyone guide me

[AdamSpeight2008]

What about my suggestion?

[Skydiver]

I think he didn't take time to read the documentation and see that TextFieldParser lets you configure the delimiters, including changing the default comma to a semicolon. Personally, I've been using the TextFieldParser ever since I was first clued into it a few years ago. It handles quotes and escapes which String.Split() does not.

[veena_vb]

AdamSpeight2008, on 09 October 2012 - 09:43 AM, said:

What about my suggestion?

thanks for the reply...but this csv is not well structured...in the sense it can be like for example
dfgdfgd
werwer
werwer
dog details
col1 col2 col3
dog1 dog2 dog3
cat details
col1 col2 col3
cat1 cat2 cat3

so in this case ....how i could create parser? each time im reading line and searching for striung and then add details...is this correct?can anyone guide me

[AdamSpeight2008]

If the data is delimited by the ; symbol then split on that.
Depending on the number of fields read in will indicate what type of data is.
Then examine them.

Also did you also look at Simple Scripting Language mentioned on the tutorial?

[veena_vb]

THANKS FOR THE REPLY...i ll checkit out...and i will post how i have done this...so u could have a look and comment on that