How to add numbers to string in a file?

ValoChele

8y1.1kVisual Basic .NET

I have a text file called sample.txt and its contents look like

John Howard Carpenter @#@ born in Carthage, New York,

to mother Milton Jean (Carter) and father Howard Ralph Carpenter.

His family moved to Bowling @#@, Kentucky, @#@ his father, a professor,

was @#@ of the music @#@ at Western Kentucky University.

How do I replace all @#@ by the numbers starting from 1, then incremented by +1 till no @#@ is left in the file.

I've tried

string x=File.ReadAllText(@"C:sample.txt");
string y="@#@";
int i=1;
MatchCollection matches = Regex.Matches(x, y, RegexOptions.IgnoreCase);
if (matches.Count>0)
{
foreach (Match m in matches) {
string n=x.Replace(y,i.ToString());
i++;
File.WriteAllText(y,n);
}
}
MessageBox.Show("Done");

It does not do anything

BTW: The expected output is

John Howard Carpenter 1 born in Carthage, New York, to mother Milton Jean (Carter) and father Howard Ralph Carpenter. His family moved to Bowling 2, Kentucky, 3 his father, a professor, was 4 of the music 5 at Western Kentucky University.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nilesh Shah8y ago
Accepted answer
I modified your code a bit, it is working fine as per my testing:
string inputText = File.ReadAllText(@"C:\temp\sample.txt");
            string findText = "@#@";

            int matchCount = inputText.Split(findText.ToCharArray()).Length - 1;

            if (matchCount > 0)
            {
                for (int counter = 1; counter <= matchCount; counter++)
                {
                    var regex = new Regex(Regex.Escape(findText));
                    inputText = regex.Replace(inputText, counter.ToString(), 1);
                }
            }

            Console.Write(inputText);
            Console.ReadKey();
+1
Nilesh Shah8y ago
int matchCount = inputText.Split(findText.ToCharArray()).Length - 1;

so what I'm doing here is finding the no. of occurances of the string "@#@".

how?

I'm splitting all your original text from file by the string "@#@" so we get the string components before and after "@#@" in an array, then I'm taking the array length, then I'm doing minus 1 in that (as the last line we don't consider it)

that's how I find the no. of times "@#@" is found in file text.

then I loop that no. of times and replace it by 1,2,3...
+1
ValoChele8y ago
Hi Nilesh,
Could you explain the below line in your code in detail (I'm a newby...)
int matchCount = inputText.Split(findText.ToCharArray()).Length - 1;
Thanks.
+1
Karthik Elumalai8y ago
Hi I have looked into your requirement and written code by hoping , it will help for you.

Here is the code:
StringBuilder sb = new StringBuilder();

string input = @"John Howard Carpenter @#@ born in Carthage, New York,

to mother Milton Jean (Carter) and father Howard Ralph Carpenter.

His family moved to Bowling @#@, Kentucky, @#@ his father, a professor,

was @#@ of the music @#@ at Western Kentucky University.";

string[] splittedinput = input.Split(' ');

int i = 1;

string temp = string.Empty;

foreach (string arrayvalue in splittedinput)

{

temp = arrayvalue;

if (arrayvalue == "@#@" || arrayvalue == "@#@,")

{

temp = i.ToString();

i++;

}

sb.Append(" " + temp);

}

Console.WriteLine(sb);

output
This is full and full my way of thinking, and you can get n no of solution for the same problem.

Hope it will give some guidance

Thanks

Karthik
-1