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

[huangbin chen]

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

[Stiltsoft support · Accepted solution]

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*

[huangbin chen]

This works and thanks to "MATCH_REGEXP" that I just learned here. Thanks.

[Ste Wright · Accepted solution]

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

[huangbin chen]

Will do, thanks.