find number from string and if condition?

devarasu07 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I've dimensional field called "SKUTheme" (string), using this field need to create calculated dimension based on below condition.

if above filed 2nd character/letter contains number then 'Non-Theme' else 'Theme'.

note: below expression is working but i'm looking some alternative expression/ simplified method.

=if(SKUTheme='A1','Non-Theme',

if(SKUTheme='A2','Non-Theme',

if(SKUTheme='A3','Non-Theme',

if(SKUTheme='A4','Non-Theme',

if(SKUTheme='A5','Non-Theme',

if(SKUTheme='A6','Non-Theme',

if(SKUTheme='B1','Non-Theme',

if(SKUTheme='B2','Non-Theme',

if(SKUTheme='B3','Non-Theme',

if(SKUTheme='B4','Non-Theme',

if(SKUTheme='B5','Non-Theme',

if(SKUTheme='B6','Non-Theme',

if(SKUTheme='C1','Non-Theme',

if(SKUTheme='C2','Non-Theme',

if(SKUTheme='C3','Non-Theme',

if(SKUTheme='C4','Non-Theme',

if(SKUTheme='C5','Non-Theme',

if(SKUTheme='C6','Non-Theme',

if(SKUTheme='C7','Non-Theme','Theme'

)))))))))))))))))))

Tks, dev

Re: find number from string and if condition?

migueldelval — Tue, 27 Dec 2016 08:51:12 GMT

Hi Devarasu,

You can try this expression:

If(len(SKUTheme)>=3,'Theme','Non-Theme')

Regards

Miguel del Valle

Anonymous — Tue, 27 Dec 2016 08:55:48 GMT

Hi,

I think is better to create a new field in the script, then using calculated dimension, for optimization reason.

Best regards,

Cosmina