Count characters in a string, find string location in a string, etc?
Is there still no way to count occurrences of a string within a string? Or to find the index of the first occurrence of a string within a string? The reason I ask is because this seems like a simple o...
You can perform any manner of text manipulation you want using script. Here is a demo that expands TLAs (Three Letter Acronyms) using oneRich Text Field:
(1) Any manner of text manipulation can be performed with script. I just happened to have this demo in the pipeline based on some other client work.
(2) The script as written performs these substations:
AMA: 'Ask Me Anything', BAE: 'Before Anyone Else', BFF: 'Best Friends Forever', BTW: 'By The Way', DM: 'Direct Message', FOMO: 'Fear Of Missing Out', FTW: 'For The Win', HW: 'Homework', ICYMI: 'In Case You Missed It', IMO: 'In My Opinion', IMHO: 'In My Humble Opinion', IRL: 'In Real Life', JIC: 'Just In Case', LMK: 'Let Me Know', MC: 'Man Crush', MT: 'Modified Tweet', NSFW: 'Not Safe For Work', NSFS: 'Not Safe For School', OMG: 'Oh My God', OOTD: 'Outfit Of The Day', OTT: 'Over The Top', RT: 'Retweet', SMH: 'Shaking My Head', TBH: 'To Be Honest', YOLO: 'You Only live Once', YSK: 'You Should Know'
Is there a way I could run this so it functions as a Formula - Text? For instance, I want to parse text from a summary field that changes based on the child records related. This example only updates if you manually change a value while editing a form.
