find number from string and if condition?

[devarasu07]

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

[migueldelval · Accepted solution]

Hi Devarasu,

You can try this expression:

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

Regards

Miguel del Valle

[Anonymous]

Hi,

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

Best regards,

Cosmina