Hhow to split datagridview column value in c# .net windows application?

Question

0.00/5 (No votes)

See more:

Hello,

I want to split one datagridview column value in six variable,

My Datagridview columna like this:-

"\Library\Daino Royal - A.jpg,\Library\Abc.jpg,\Library\DEF.jpg,\Library\GHI.jpg,\Library\TIVOLI_GREY_A.jpg,\Library\URBANA_GREY - C.jpg"

I want to fill only ".jpg" file in six variable like,

C#

string a = "Abc.jpg";

So, Please help me how can we split one datagridview column value?

Thanks
Ankit Agarwal
Software Engineer

Posted 10-Apr-13 2:17am

ankit.agg1984

Updated 10-Apr-13 2:41am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

v2

Add a Solution

Comments

[no name] 10-Apr-13 8:20am

Okay so use Split, SubString or a regular expression.

[no name] 10-Apr-13 8:22am

but how, can you give me the code according to datagridview column value split?

PrashantSonewane 10-Apr-13 8:30am

use something like this:

string str = DataGrid1.Column(X).Value;

str.Replace("\\Library\\","");
string[] lstImage = str.Split(',');
string img1 = lstImage[0].ToString();
string img2 = lstImage[1].ToString();
string img3 = lstImage[2].ToString();
string img4 = lstImage[3].ToString();
string img5 = lstImage[4].ToString();
string img6 = lstImage[5].ToString();

However \ will give you some trouble working with in C# as it is escape char. Check on that.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Answer 1 · 2013-04-10T02:38:00

Solution 1

Here's one way of doing it ...

C#

// copy the dgv value to a string e.g.
string dgvCell = dataGridView1.Rows[0].Cells[0].Value.ToString();

// Remove the /libary bits
dgvCell = dgvCell.Replace(@"\Library\", "");

//Use string.split to split on commas, store results in string array
string[] jpgList = dgvCell.Split(',');

// Do something with the results e.g. ...
foreach (string j in jpgList)
    if(j.Contains("jpg"))
        Debug.Print(j);

Posted 10-Apr-13 2:38am

CHill60

Updated 10-Apr-13 3:06am

v2

Comments

[no name] 10-Apr-13 8:53am

I need only image name .jpg,
I need not \Library\

[no name] 10-Apr-13 8:55am

I need only images name.
Daino Royal - A.jpg
Abc.jpg
DEF.jpg
GHI.jpg
TIVOLI_GREY_A.jpg
URBANA_GREY - C.jpg

CHill60 10-Apr-13 9:07am

I've added a call to .Replace to my solution - also see comment from PrashantSonewane

[no name] 10-Apr-13 9:34am

I have also commented PrashantSonewane's solutions before use your solution but did not run on my condition.
This code displayed "\Library\Abc.jpg"

CHill60 10-Apr-13 9:48am

Ah yes - he's using WPF I think. However, my revised solution listed the jpg files as per your comment when I tested it - is it not working for you?

Pallavi Waikar · Answer 2 · 2013-04-10T04:40:00

Solution 2

also try this regex code

string s = @"\Library\Daino Royal - A.jpg,\Library\Abc.jpg,\Library\DEF.jpg,\Library\GHI.jpg,\Library\TIVOLI_GREY_A.jpg,\Library\URBANA_GREY - C.jpg";
 MatchCollection matches = Regex.Matches(s, @"(\w*.jpg)");
// or use MatchCollection matches = Regex.Matches(s, @"(\w*?\s*?-?\s*?\w*.jpg)");
//or use MatchCollection matches = Regex.Matches(s, @"((\w*?\s*?-?\s*?){0,}\w*.jpg)");
 string[] imgFileName = new string[matches.Count];
 int i=0;
 foreach (Match match in matches)
{
   imgFileName[i] = match.Value;
   MessageBox.Show(match.Value);
   i++;
}

Posted 10-Apr-13 4:40am

Pallavi Waikar

Updated 10-Apr-13 6:57am

v5

Comments

CHill60 10-Apr-13 11:22am

URBANA_GREY - C.jpg is being returned as C.jpg for me

Pallavi Waikar 10-Apr-13 12:00pm

for that use regex as
MatchCollection matches = Regex.Matches(s, @"(\w*?\s*?-?\s*?\w*.jpg)");

CHill60 10-Apr-13 12:27pm

Yep - that's better. But also "Daino Royal - A.jpg" still returned as "Royal - A.jpg"

Pallavi Waikar 10-Apr-13 12:51pm

ok then try this one
MatchCollection matches = Regex.Matches(s, @"((\w*?\s*?-?\s*?){0,}\w*.jpg)");

Pallavi Waikar 10-Apr-13 12:55pm

this will also work
string[] arr = @"\Library\Daino Royal - A.jpg,\Library\Abc.jpg,\Library\DEF.jpg,\Library\GHI.jpg,\Library\TIVOLI_GREY_A.jpg,\Library\URBANA_GREY - C.jpg".Replace(",", "").Replace("\\Library\\", ",").Remove(0, 1).Split(',');
foreach (string m in arr)
{
MessageBox.Show(m);
}