How to replace custom format string?

Question

I am searching for a long time on net. But no use. Please help or try to give some ideas how to achieve this.

In my SQL Database, have a data:

Reason：%s与%s等预算科目的内容存在重复，核减%d万元

ResultS1：本科目镍铁中多元素样品前处理

ResultS2：本科目ICP测定法

ResultD：2.50

I want get a string：本科目镍铁中多元素样品前处理与本科目ICP测定法等预算科目的内容存在重复，核减2.50万元

use string interpolation : learn.microsoft.com/en-us/dotnet/csharp/language-reference/… — Bassie
– Bassie, Commented May 3, 2018 at 6:04
@sLw You would do it in the same way you do it with string.Format - you process the data before interpolating — Bassie
– Bassie, Commented May 3, 2018 at 6:09
@Bassie but why would you first use string.remove and then interpolate? that's hardcoding at its best — slow
– slow, Commented May 3, 2018 at 6:10
Maybe you could actually explain the rules of what you're trying to achieve, rather than just providing a single example in a language that will likely be unfamiliar to most. There are a hundred ways and more to get that result from that data but, unless we know what the actual rules are, we have no idea whether they would work for other data. In short, provide a FULL and CLEAR explanation of the problem. — jmcilhinney
– jmcilhinney, Commented May 3, 2018 at 6:14
@Foskill just use Regex.Replace() and you are good to go. You can specify that it only replaces the first occurrence. — slow
– slow, Commented May 3, 2018 at 6:20

Bassie · Accepted Answer · 2018-05-03 06:38:40Z

You can use the helpful extension method from this question (second answer down) ReplaceFirst:

public static string ReplaceFirst(this string text, string search, string replace)
{
    int pos = text.IndexOf(search);
    if (pos < 0)
    {
        return text;
    }
    return $"{text.Substring(0, pos)}{replace}{text.Substring(pos + search.Length)}";
}

and then call it like this

var reason = "%s与%s等预算科目的内容存在重复，核减%d万元";
var results1 = "本科目镍铁中多元素样品前处理";
var results2 = "本科目ICP测定法";
var resultd = "2.50";

var final = reason
    .ReplaceFirst("%s", results1)
    .ReplaceFirst("%s", results2)
    .ReplaceFirst("%d", resultd);

Where final is assigned

"本科目镍铁中多元素样品前处理与本科目ICP测定法等预算科目的内容存在重复，核减2.50万元"

Ryuk Lee · Accepted Answer · 2018-05-03 06:22:45Z

1

SELECT concat_ws('',ResultS1,'与',ResultS2,'等预算科目的内容存在重复，核减',ResultD,'万元') as Result 
FROM `yourtable`

Follow the answer concatenate string in c#

string key = String.Join("", new String[] { ResultS1,'与',ResultS2,'等预算科目的内容存在重复，核减',ResultD,'万元'});

edited May 3, 2018 at 6:22

answered May 3, 2018 at 6:05

Ryuk Lee

7445 silver badges12 bronze badges

4 Comments

slow Over a year ago

and how are you replaceing the %s? this is way too hardcoded

Foskill Over a year ago

Thank you for your answer, but have you implemented it in C#?

Foskill Over a year ago

Thank you for your answer, but my data [Reason] is var.This will not be realized.

Ryuk Lee Over a year ago

I think in c# you need to change %s and %d to parameters {0} , {1} , {2} and try that way :D. Hope that helps

Collectives™ on Stack Overflow

How to replace custom format string?

2 Answers 2

Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related