Formula to search text
Hi domo fam!
I am currently working on two ELT formulas: the first I am trying to search a string field column named Note for a specific text. However the way the text is stored in the row it is “Bankruptcy Record-then a break line-Dismissal Customer confirmed bankruptcy on 01-01-2021”
I want to search for all notations that has Bankruptcy Record Dismissal... the formula I was using is:
Case (when (str_contains(Note, ‘Bankruptcy Record Dismissal’ = ‘1’) then ‘Dismissal’ End)
The formulated column comes back null because of the line break in the notes. I know in sql you would query:
where Note like “Bankruptcy Record”+CHAR(10)+”Dismissal”
but I cannot input CHAR10 in the formula tile in ELT Mode. Anyway to search for “Bankruptcy Record Dismissal” knowing there is a line break after record?
Secondly trying to mask numbers in the same notes field. I used the remove digit formula however I wanted to replace any digit to be displayed as ####.
Your assistance with this is appreciated!