Hi!
I’ ve encountered a possible Airtable quirk and was wondering if anyone has a hint how to work around it.
I have a Long Text Field with RTF enabled. In this field I have RTF formated text / Markdown text.
In a formula field I’m trying to search this field for Blood Type: AB
and if found output AB
. Nothing strange so far. Only issue is that no such instance is found and the cell remains empty.
I have tried
IF(
FIND('Blood Type: AB',{Profile}),
'AB'
)
and
IF(
REGEX_MATCH({Profile}, 'Blood Type: AB'),
'AB'
)
As I figure that it’s the markdown messing with it I have also tested
IF(
FIND('**Blood Type:** AB',{Profile}),
'AB'
)
and
IF(
REGEX_MATCH({Profile}, '**Blood Type:** AB'),
'AB'
)
and
IF(
FIND('__Blood Type:__ AB',{Profile}),
'AB'
)
and
IF(
REGEX_MATCH({Profile}, '__Blood Type:__ AB'),
'AB'
)
I even tested adding a &''
at the end of the field name, just in wild fishing/testing effort. No luck.
Does anyone know how to do this? If I change the text to ‘normal’, non markdowned text, it all works as expected. But then, what’s the point of having RTF enabled and using markdown if some formulae become brittle when used?
Is it actually true that you can’t find or match markdowned text or is it just my brain that is in full vacation mode?