How to replace a String at the end when Building a String with multiple Data?

Question

HI all i am Building A string Which looks like this

 [Anil Kumar K,Niharika,Raghu,/4,0,0,/3,0,0,/1,1,1,/1,0,0,]

i am building this string with this data

public JsonResult ResourceBugReports()
    {
        int projectid;
        int Releasphaseid;
        projectid = 16;
        Releasphaseid = 1;
        var ResourceReports = db.ExecuteStoreQuery<ResourceModel>("ResourceBugReports @ProjectId,@ReleasePhaseId", new SqlParameter("@ProjectId", projectid), new SqlParameter("@ReleasePhaseId", Releasphaseid)).ToList();
        DataSet ds = new DataSet();        

        var model1 = new WeeklyBugCount
        {
            Resources = ResourceReports
        };
        foreach (var row in model1.Resources)
        {
            ResourceName1 = ResourceName1 + row.EmployeeName + ",";
        }
        foreach (var row in model1.Resources)
        {
            BugsCount = BugsCount + row.Assignedbugs + ",";
        }
        foreach (var row in model1.Resources)
        {
            BugsCount1 = BugsCount1+ row.Closedbugs + ",";
        }
        foreach (var row in model1.Resources)
        {
            Bugscount2 = Bugscount2 + row.Fixedbugs + "," ;
        }
        foreach (var row in model1.Resources)
        {
            BugsCount3 = BugsCount3 + row.Reopenedbugs + ",";
        }

        ComboinedString = ResourceName1 + "/" + BugsCount + "/" + BugsCount1 + "/" + Bugscount2 + "/" + BugsCount3;

        return Json(ComboinedString, JsonRequestBehavior.AllowGet);
    }

my

ComboinedString =[Anil Kumar K,Niharika,Raghu,/4,0,0,/3,0,0,/1,1,1,/1,0,0,]

but i want this string

 ComboinedString =[Anil Kumar K,Niharika,Raghu/4,0,0/3,0,0,/1,1,1/1,0,0]

i want to remove this "," before the "/" in this strin or replace it..can any one help me

Hardik Mishra · Accepted Answer · 2012-09-05 04:04:30Z

1

Add this statement

I hope it will help you

String CombinedString1 = CombinedString.Replace(",/", "/");

edited Sep 5, 2012 at 4:04

Hardik Mishra

14.9k9 gold badges63 silver badges98 bronze badges

answered Aug 30, 2012 at 15:08

Sadda-shutu

1,3092 gold badges19 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

akton · Accepted Answer · 2012-08-30 15:03:25Z

1

A simple solution is a search and replace on the string replacing ",/" with "/".

A better solution is, rather than using a for() loop and appending a comma at the end of each value, is use String.Join(). For example, replace:

    foreach (var row in model1.Resources)
    {
        ResourceName1 = ResourceName1 + row.EmployeeName + ",";
    }

with

    ResourceName1 = string.Join(",", model1.Resources.ToArray())

This will remove the trailing comma.

answered Aug 30, 2012 at 15:03

akton

14.4k3 gold badges46 silver badges48 bronze badges

Comments

user1542652 · Accepted Answer · 2012-08-30 15:08:45Z

0

A simple solution would be to use String.EndsWith() function i.e.

string str = "ksjf,sjsfj,sfs,";
        if (str.EndsWith(","))
        {
            str = str.Remove(str.Length - 1);

        }

answered Aug 30, 2012 at 15:08

user1542652

711 silver badge9 bronze badges

Comments

Drewman · Accepted Answer · 2012-08-30 15:40:55Z

0

Off the top of my head, you could try to replace with a simple regular expression:

string input = "dsgd,sdgsdg,dsgsdg,sdg,";
string output = Regex.Replace(input, ",$", "");
//output: "dsgd,sdgsdg,dsgsdg,sdg"

@user1542652's solution is simple and works just as well.

answered Aug 30, 2012 at 15:40

Drewman

94711 silver badges23 bronze badges

Collectives™ on Stack Overflow

How to replace a String at the end when Building a String with multiple Data?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related