topic If a column contains "%"--> how can I use this type for a formula? i.e. if states "%" do formula, otherwise use a number from another column? in Discussions

If a column contains "%"--> how can I use this type for a formula? i.e. if states "%" do formula, otherwise use a number from another column?

Hester — Fri, 09 Jun 2023 19:54:47 GMT

I'm struggling. I have a column which contains either %, /nl or 10^9 as a outcome. the linked numbers in another column have to be converted depending on these expressions. How should I use the column properties and which comparison or expression in the formula should I use? Most use a numerical part for this, but I need now the characters.

if --> % than calculate number *100, if not do xxx

Re: If a column contains "%"--> how can I use this type for a formula? i.e. if states "%" do formula, otherwise use a number from another column?

Craige_Hales — Mon, 16 Aug 2021 10:32:23 GMT

A picture would help. Is the column a character column, showing the % or / or ^ ? Or is it a numeric column with just a number?

If it is a character column, the contains() function might do what you need.

contains("37%", "%")
3 // position of the %

contains("37%", "/")
0 // / not found (position 0 not a valid position)