Split comma separated values from Text component

[dmasterplan]

I have Name-Company,Name-Company value in my Text Component and I want to split it (split comma separated).
and make it
1. Name-Company
2. Name-Company
How/where can I do it? in Databand Before Print event?

[Lech Kulikowski]

Hello,

What do you need to do with these values after splitting?

Thank you.

[dmasterplan]

Hello,

What do you need to do with these values after splitting?

Thank you.

I want to display it again in the same component.
With the number before the text. e.g.
1. Name-Company
2. Name-Company
Great Thanks!

[Lech Kulikowski]

Hello,

You can use the following code in the BeforePrint event:

Code: Select all

var i = 1;
using (System.IO.StringReader sr = new System.IO.StringReader(Variable1.Replace(",","\n")))
{
	string line;
	while ((line = sr.ReadLine()) != null)
	{
    	Variable2 += i++.ToString() + ". " + line + "\n";
	}
}

or the following expression for split without numeration:
{Variable1.Replace(",","\n")}

Thank you.

[dmasterplan]

Hello,

You can use the following code in the BeforePrint event:

Code: Select all

var i = 1;
using (System.IO.StringReader sr = new System.IO.StringReader(Variable1.Replace(",","\n")))
{
	string line;
	while ((line = sr.ReadLine()) != null)
	{
    	Variable2 += i++.ToString() + ". " + line + "\n";
	}
}

or the following expression for split without numeration:
{Variable1.Replace(",","\n")}

Thank you.

This is my code. But I am not getting the correct output:

string Variable1 = dsPackages.Package_In_Charge;

var i = 1;
using (System.IO.StringReader sr = new System.IO.StringReader(Variable1.Replace(",","\n")))
{
string line;
while ((line = sr.ReadLine()) != null)
{
dsPackageInCharge.TextValue += i++.ToString() + ". " + line + "\n";
}
}

I have attached an image of the result.

[dmasterplan]

dsPackageInCharge.TextValue = "";
string Variable1 = dsPackages.Package_In_Charge;

var i = 1;
using (System.IO.StringReader sr = new System.IO.StringReader(Variable1.Replace("-","\n")))
{
string line;
while ((line = sr.ReadLine()) != null)
{
dsPackageInCharge.TextValue += i++.ToString() + ". " + line + "\n";
}
}

We solved it already. It's just not been reset, so we had added dsPackageInCharge.TextValue = "";
in the first line.

Great Thanks

[Lech Kulikowski]

Hello,

You are welcome.