So, let's say you've got an input message:
"Zapier is the best company in the world. They'll probably be bigger than Apple one day"
Now say you've got a Google Sheet table as such:
Find | Replace
1 | Apple | @Apple
2 | Bentley | @Bentley
3 | We Work | @WeWork
4 | Zapier | @Zapier
We want to compare the input message with this find/replace table and make swaps where appropriate.
In case of the example, the output would be:
"@Zapier is the best company in the world. They'll probably be bigger than @Apple one day".
The problem - how do I do this without massive task usage?
Breaking the input message into single words and comparing with the table is task-intensive and won't handle "Find" values of more than a single word.
Looping every row on the Google Sheet and comparing to the input message is also task-intensive (in real life, the sheet has 130+ rows and growing daily).
Anyone got any smart ideas here?
Best answer by ikbelkirasanView original