Hi gang. When storing a new thing, I’m trying to do my users a favor and strip out the leading 4 characters ("The ") when its title begins with the word “The” I have a title and a sort-title. I’m attempting to store this truncated title in the sort-title field. In my Update a Thing step (conditio…

Have you tried :find & replace —> ‘The ’ for nothing. For order of operations and parentheses I use :arbitrary text a lot (you can convert to number back in the main expression if it’s numerical)… obviously native parenthesis will be great once they’re fully fledged though.

How to add parentheses to an update statement (trim first 4 chars)

Need help Database

mikeloc July 7, 2022, 4:11pm 2

Maybe try enabling the experimental parentheses feature?

Best…
Mike

1 Like