Question

Hello,

I want to get the first word from a rollup. So I need a formula that slice the string before the comma. Slice string by symbol "," or something.

Thanks,
Notionasker

Comments

Please share an example of what you have and how you want it. To understand what slice means for you in that case with a before and after.

---

Here is the example
https://vv20.notion.site/Example-bebb9adceeaa4d35acdc451158fa065b

Answer 1

You will need to replace everything after the first comma with nothing. :)
slice only allows certain number of characters you specify. By using replaceAll, the number of characters before the first comma doesn't matter.

replaceAll(prop("Details"), ",.*", "")

Hope this helps!