How to make substring ?

[jamesjames]

Hi guys,

I am trying to make an expression, thus it would divide data into smaller parts.

So far this expression works if the column has two values e.g. incoming and outgoing

if(substringcount(lower([value.name]),'incom')>0,'incoming','outgoing') 

What should I adjust for this expression ,thus it would work if the column name has three or more values?

[marcus_sommer]

Maybe subfield() is more suitable for splitting your data into several fields or into several rows for one field.

- Marcus

[rwunderlich]

pick(
WildMatch(value.name, '*incom*', '*outgo*', '*cancel*')
,'incoming', 'outgoing', 'cancelled'
)

-Rob