03-16-2021 09:29 AM
This seems like it should be trivial but its killing me rn. When I search a multi line string for lines starting with <something> how do I replace all of the text in that line of string with new text, not just the first word? The text in the lines(s) of the incoming string is not always the same length. Sometimes the number in the line is larger, also I'm not sure of how much white space there will be.
I see what's happening and why I'm getting:
apples 15 pass 26 fail
oranges 13 pass
grapes 12 pass
What I would like to end up with is:
apples 15 pass
oranges 13 pass
grapes 12 pass
Solved! Go to Solution.
03-16-2021 09:51 AM
Hi Brother,
@TheWolfmansBrother wrote:
When I search a multi line string for lines starting with <something> how do I replace all of the text in that line of string with new text, not just the first word?
Convert your input string into an array of "line" (using SpreadsheetStringToArray).
Then autoiterate that array and replace the whole line when you detect your "starting word"…
03-16-2021 10:05 AM
^apples.*$