Regular Expression help needed to find and replace specific numbers in a text file.
Posted on 2016-07-18
I have a very large text file, hundreds of thousands of rows, that repeats the same 10 types rows for each new record in the file, where each row contains different information about a given record. The file is a combination of nearly 200 other text files that I combined to prevent our employees from having to deal with hundreds of files. Combining the file means I have to renumber specific lines in the file to be sequential. Each row I need to find begins with HL.
Here's an example of a few rows I have to find and renumber:
I have to replace the numeric value found after the first *, so 65, 104, 8 and 1052 in the examples shown above. The rest of the strings has to be left alone.
Does anyone know how to do this?
Note - I'll be doing this find and replace in a C#.NET console application.