nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

position of a character in the string

Rachi Manwal

I was trying to find the position of a character from a string but didn't find any function for the same. Like, in SQL we have charIndex and in MySql there is Position function

Accepted answers

Katerina Kovriga {Stiltsoft}

Hi @Rachi Manwal ,

Please clarify what app/macro are you using for the case?

If we are talking about our Table Filter and Charts for Confluence app and its Table Transformer macro, you may try the following query:

Tue 8-1.png

SELECT *,
T1.'String to find'->indexOf("new") AS 'Position'
FROM T1

Tue 8-2.png

All comments

Katerina Kovriga {Stiltsoft}

Hi @Rachi Manwal ,

Please clarify what app/macro are you using for the case?

If we are talking about our Table Filter and Charts for Confluence app and its Table Transformer macro, you may try the following query:

Tue 8-1.png

SELECT *,
T1.'String to find'->indexOf("new") AS 'Position'
FROM T1

Tue 8-2.png

Rachi Manwal

Thank you @Katerina Kovriga _Stiltsoft_ , I am using the Table Transformer macro. Could you let me know any resource where I could find these functions. I am a bit confused, is this not totally sql?

Katerina Kovriga {Stiltsoft}

Yes, you are right - it's a bit of JavaScript provided by our developers.

The JavaScript methods in general are documented here, but if you have any specific case that is not very common and is not documented, you may raise a support request (the portal is confidential), attach a screenshot of your original table with a visible header row and describe what you need to achieve - our engineers will provide you with a corresponding query.

Rachi Manwal

okay, thank you!!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

sql

filter

table

table-filter

table-filter-and-charts

table-transformer