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

Topic		Replies	Views
Parenthesis Feature Request Idea	9	1683	April 29, 2022
Adding an ellipsis to truncated strings? Need help	3	3366	July 20, 2017
[SOLVED] How to use the :trimmed function? Database	4	5917	February 24, 2022
Help with a text trick Need help	12	490	April 19, 2022
Sorting fields when using Do a Search :Merge With and :Sort Database	4	279	January 15, 2024

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

Related topics