I have made a data scraping process that takes data from a word document and outputs it to Excel. The scraping of the data is fine, but I have noticed that a lot of the values are followed by \r, \n, \a,or \t. I have got a Regex.Replace working on one String value.
The Regex I am using is:
this is the value of a string without using regex
this is the value using regex
I tried putting an Array of Strings into where the String Variable name goes, but it gave me a validation error, saying that 1-dimensional array of string can’t be converted to string.
Can I modify the Regex to replace everything in the array? If so, how do I do that? Any help is appriciated