cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
Hester
Hester
Level I

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?

Created: Aug 16, 2021 05:55 AM  |  Last Modified: Jun 9, 2023 12:54 PM (453 views)

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

0 Kudos
1 REPLY 1
Craige_Hales
Super User Craige_Hales
Super User

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?

Aug 16, 2021 06:32 AM (447 views)  |  Posted in reply to message from Hester 08-16-2021

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)
Craige
0 Kudos