How can i replace a string with the required

Question

Hi all i am having my data as follows

52201               1                   1         PPD1         111017111017   1111000020000003

Here i would like to replace the one with bold to 0000002 can any one help me. I used the following but i am unable to replace it

if (strBtchno1.StartsWith("5"))
{
    iBtchno = Convert.ToInt16(strBtchno1.Substring(87, 7));
    if (iBtchno > iBatchno)
    {
       iBtchno = iBtchno - 1;                      
       strBtchno1 = strBtchno1.Substring(0,87) + iBtchno.ToString() + strBtchno1.Substring(7,(strBtchno1.Length - 7));
     }                       
  }

You're starting your substring 87 spaces into the string. Shouldn't it be 37, or is the string actually bigger, than what you are showing? — Nicolai
– Nicolai, Commented Oct 17, 2011 at 12:38
I would like to replace the text from the character 87 to 94 my maximum length is 94 — Developer
– Developer, Commented Oct 17, 2011 at 12:38
If you mean replace the last 7 digits, xanatos answer is correct otherwise please explain better. — user447356
– user447356, Commented Oct 17, 2011 at 12:42
If you do the Convert.ToInt16 wont you loose all the leading zeros too? — Purplegoldfish
– Purplegoldfish, Commented Oct 17, 2011 at 12:43
@Nicolai formatting issue, I've edited with proper format now. — user447356
– user447356, Commented Oct 17, 2011 at 12:44

xanatos · Accepted Answer · 2011-10-17 12:46:42Z

3

string strBtchno1 = "52201               1                   1         PPD1         111017111017   1111000020000003";
int iBtchno = Convert.ToInt32(strBtchno1.Substring(strBtchno1.Length - 7));
iBtchno++;
strBtchno1 = strBtchno1.Substring(0, strBtchno1.Length - 7) + iBtchno.ToString("d7");

7 digits is an int, not a short!!!

And to format the number back with the padding you can use iBtchno.ToString("d7").

edited Oct 17, 2011 at 12:46

answered Oct 17, 2011 at 12:39

xanatos

112k13 gold badges209 silver badges296 bronze badges

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

Comments

Royi Namir · Accepted Answer · 2011-10-17 12:41:36Z

0

 string newS = System.Text.RegularExpressions.Regex.Replace(s, @"\*\*[0-9]+\*\*", "0000002");

but i dont know if you want regex solution

answered Oct 17, 2011 at 12:41

Royi Namir

149k145 gold badges502 silver badges833 bronze badges

3 Comments

Developer Over a year ago

What you mean by this will it replace the text as per i needed?

Royi Namir Over a year ago

@if your data contains '*' so yes. you didnt mentioned it

user447356 Over a year ago

The * were there to try and make the text bold - can't be used inside code block though.

Collectives™ on Stack Overflow

How can i replace a string with the required

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related