How to parse field to extract email address and display mailto link

Question

I am working in my record type display interface.

One of the fields in our data contains an email address with the name of the person in this format:

Bilbo Baggins <Bilbo.Baggins@TheShire.org>

I need to extract the string between the < > and display that string as a mailto link in my results.

How do I write this, or if it's not possible to write this, how can this be achieved based on the data as it is?

Many thanks in advance -

Scott Fleming · Accepted Answer

a!richTextDisplayField(
 value: a!richTextItem(
 text: a!localVariables(
 local!fullString: fv!row['recordType!{a7958e69-8bde-42a9-a773-23e5104be70a}HAP Application.fields.{f3a77ebb-d7b9-4ec4-bd04-674ed104e96e}technicalPointOfContact'],
 extract(
 "--beginning--" & local!fullString,
 "g--",
 " <"
 )
 ),
 link: a!safeLink(
 uri: "mailto://" & extract(fv!row['recordType!{a7958e69-8bde-42a9-a773-23e5104be70a}HAP Application.fields.{f3a77ebb-d7b9-4ec4-bd04-674ed104e96e}technicalPointOfContact'], "<",">")
 )
 )
)

Mike Schmitt · Answer

docs.appian.com/.../fnc_text_extract.html

Mike Schmitt · Answer

mid() seems like a reasonable approach - my old trick, though, when wanting a more carefully guided "extract", is to prepend a special delimiter string (something unlikely/impossible to ever appear in the actual string itself) --

Mike Schmitt · Answer

don't use split() for this. See my and Stefan's other replies above.

Mike Schmitt · Answer

do you still get that error if you add the (required) ":" after "mailto"? 
 ed: i don't get the error in my CE site...

Mike Schmitt · Answer

Works in my CE site (and in the shared beta site). If you just make a new unsaved interface with this code do you still get the same error?

How to parse field to extract email address and display mailto link

Top Replies