how to find the last 2 characters of a string

[David Gornichec]

in the table transformer macro under SQL query, I would like to find the last two characters of a string and convert to numeric values.

[Stiltsoft support]

Hi @David Gornichec ,

If you are talking about our Table Filter, Charts & Spreadsheets for Confluence app and its Table Transformer macro, you may refer to our support portal that is confidential.

And also here, in our documentation, there is a list of supported functions with step-by-step examples: https://docs.stiltsoft.com/tfac/cloud/general-syntax-and-sql-functions-available-42246251.html#GeneralsyntaxandSQLfunctionsavailable-Functionsandkeywords

For your case, seems that the 

SUBSTRING(T1.'Column 1', LENGTH(T1.'Column 1')-1, 2)

or

SUBSTRING_VIEW(T1.'Column 1', LENGTH(T1.'Column 1')-1, 2)

expression will do the trick.