how to extract dynamic length value from a string to a new column in Table transformer Macro

Question

Hi Experts,

I would like to extract "dynamic length value" from a string to construct a new column in Table transformer macro. Is this possible?

May I know how to achieve this?

Expected result:

Thanks

Ste Wright · Accepted Answer

Hi @huangbin chen

Is this using the App Table Filter, Charts & Spreadsheets for Confluence?

If yes, I'd consider contacting the vendor for this question also - you can see their support options on their Marketplace listing - https://marketplace.atlassian.com/apps/27447/table-filter-charts-spreadsheets-for-confluence?hosting=cloud&tab=support

Ste

Stiltsoft support · Accepted Answer

Hi @huangbin chen ,

You can google and use standard regular expressions inside your SQL query with the help of the MATCH_REGEXP function, for example, something like this:

SELECT *,
MATCH_REGEXP(T1.'string', "-?\d+", "g")
AS 'temp'
FROM T*