How do replace a comma in a string

Question

3.00/5 (1 vote)

See more:

hi,
i have string like

"Employee Name:john,age:45,salary:$1,000.45"

.When i split the string with "," the result is showing like this.

C#

sAry[0]="Employee Name:john";
sAry[1]="age:45";
sAry[2]="salary:$1";
sAry[3]="000.45";

But the array result should be like this

C#

sAry[0]="Employee Name:john";
sAry[1]="age:45";
sAry[2]="salary:$1,000.45";

Please help me to resolve this .
thanks and Best Regards

Posted 30-Dec-15 0:39am

mohan jana

Updated 30-Dec-15 2:25am

Kenneth Haugland

v2

Add a Solution

Comments

Ralf Meier 30-Dec-15 7:02am

Is the string in the sample the complete string or are there following several items ?

mohan jana 4-Jan-16 2:19am

The actual string is not simple as in the Question,it will much longer like

"Subscriber: David Benedict 406001229459 | National Rural Electric Co-Op Assoc, 76411406 \r\nYou are viewing: In network Medical Benefits as of 01/01/2015 for David Benedict [sep]Copays\r\n\r\n$0.00,$0.00,$0.00,$0.00\r\nOffice Visit ,Urgent Care ,Emergency Room ,Hospital Admission \r\n\r\nMajor Medical\r\n\r\nBenefit Percentage\r\n90%,10%\r\nPlan pays,You pay\r\n[sep]Individual Annual Maximum, , ,Individual Lifetime Maximum, \r\nNot Applicable, , ,Not Applicable, \r\n, , ,\r\n, , ,\r\n, , ,\r\n \r\nIndividual Integrated Deductible, , ,Family Integrated Deductible, \r\nNot Applicable, , ,\"\r\n100%\", \r\n, , ,Applied*,Remaining,Max\r\n, , ,\"$4,000.00\",$0.00,\"$4,000.00\"\r\n, , ,*Applied amount includes $706.92 for prescriptions\r\n \r\nIndividual Integrated Out-of-Pocket, , ,Family Integrated Out-of-Pocket, \r\n\"\r\n100%\", , ,\"\r\n52%\", \r\nApplied*,Remaining,Max, , ,Applied*,Remaining,Max\r\n\"$2,000.00\",$0.00,\"$2,000.00\", , ,\"$2,093.40\",\"$1,906.60\",\"$4,000.00\"\r\n*Applied amount includes $126.52 for prescriptions, , ,*Applied amount includes $189.75 for prescriptions\r\n \r\n"

Raje_ 30-Dec-15 8:24am

One more thing you can do is you can build your string separated by | instead of comma.

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)

OriginalGriff · Accepted Answer · 2015-12-30T01:17:00

That's always going to be a problem, because your data is using the same symbol for two different purposes: as a data separator, and as an optional thousands indicator.
What I would probably do is set up a regular expression to do the break down instead:

Employee Name:(?<EmpName>.+?)\,age:(?<EmpAge>\d+)\,salary:(?<EmpSalary>.*)

The three groups then give you the info you need.

Maciej Los · Accepted Answer · 2015-12-30T03:17:00

An implementation of what OriginalGriff said, but with bit changed pattern:

C#

string s = @"Employee Name:john,age:45,salary:$1,000.45,Employee Name:joshua,age:38,salary:$1,200.88,Employee Name:johnattan,age:29,salary:$1,050.23";
 
string pattern = @"(Employee Name:\w*|age:\d+|salary:\$\b\d+\,\d{3}\.\d{0,2}\b)+";

System.Text.RegularExpressions.Regex searchTerm =
    new System.Text.RegularExpressions.Regex(pattern);
 
var data = Regex.Matches(s,pattern, RegexOptions.ExplicitCapture | RegexOptions.CultureInvariant)
		.Cast<System.Text.RegularExpressions.Match>()
		.Select(m => new
		{
			Property = m.Value.Split(':')[0],
			Value = m.Value.Split(':')[1]
		});

Console.WriteLine("{0}\t\t{1}", "Property", "Value");
foreach(var d in data)
{
	Console.WriteLine("{0}\t\t{1}", d.Property, d.Value);
}

Result:

Property Value
Employee Name john 
age 45 
salary $1,000.45 
Employee Name joshua 
age 38 
salary $1,200.88 
Employee Name johnattan 
age 29 
salary $1,050.23

How do replace a comma in a string

2 solutions

Solution 1

Solution 5

Add your solution here

Preview 0