It would be enormously helpful in constructing documents to have find and replace. Even if it only works on text initially. If this feature already exists, I can’t seem to find it anywhere
Does RegexReplace do the job?
RegexReplace("Top Flat w/Parking (marina / cow hollow) $1200 1bd 800ft", "([$]\d+)", "$2000")
“Top Flat w/Parking (marina / cow hollow) $2000 1bd 800ft”
If learning/using regexes (regicies?) is not your thing you can also use Substitute which is simpler but less powerful.
Substitute("Hello world", "Hello", "Good morning")
“Good morning world”
thanks for the suggestion! that works for transforming columns in a table, but I’m not familiar with how that can apply to text as paragraphs, headers, code blocks, etc. outside a table column.
Ahh I see what you’re saying. I’ll play around with something and see what I can find
What is your goal with using find and replace? Are you looking to make a dynamic document, or are you just trying to fix errors on your page?
more like fixing errors. in my particular case, I’m writing a design document and my team has decided to rename something. Instead of searching for each occurence in the search bar, and manually replacing, I would like to specify the replacement.
Basically this feature from gdoc:
Ah yeah, that would definitely be a nice feature to have. For now, you might be able to use something like this chrome extension to get the job done.