Extracting Tips & CC tips from notes

AppSheet AppSheet Q&A
1

I’m uploading timecards from When I work into appsheet, I want to be able to extract two different types of “tips” from their notes.

I want to extract the price to the RIGHT of “cc tips” from notes, and the price of regular tips also and have different workflows for them.

How can I get appsheet to simply read the “price” to the RIGHT of “cc tips”?

RIGHT(LEFT( [notes], FIND(“cc tips”, [notes])+11),3) ?

2

Did you try this expression and it didn’t do what you need?

A generic technique that may be helpful is split-last-split-first. See an example in another recent conversation.