Formatting user name as @mention using table transformer

[Alexandra Kühn]

Is it possible to format a user name in a table cell as an @mention using the sql-query of the table transformer makro like you can format statuses, clickable links, mail and phone numbers with formatwiki?

The input should look like one of theese: 

and the output like this:

[Stiltsoft support · Accepted solution]

Hi @Alexandra Kühn ,

Unfortunately, it is not possible. The @ symbol in mentions is not a visible symbol for the macro, you may check it entering real mentions in a row and trying to separate the string by @.

You may use smth like this

SELECT
FORMATWIKI("@",'Name') AS 'New Name'
FROM T*

but the result will be not John but @John. The real mention won't be created.

[Alexandra Kühn]

What a pity, but thanks for the fast answer.