How to use subfield function with if else

[rupaliqlik]

Hi Team,

I want to convert the string. Kindly help me here.

I am writing below condition in scrip level  which gave me correct ouput where ':' sign is present but other highlighted korean string is ignored so which give blank product cat in front of materail id.

Please help me how to write here.

subfield(Product_Cat,':',2) as Product_Cat_Jap,

Thanks,

Rupali

@sunny_talwar @jagan  @abhijitnalekar @ kaushik.solanki ,@sunny t,

[abhijitnalekar]

Hi @rupaliqlik ,

Add one more condition like

if (match(Product_Cat,':')>0, subfield(Product_Cat,':',2) , Product_Cat) 

Hope this solves the purpose

[rupaliqlik]

HI @abhijitnalekar 

I tried below logic and it works. Is this correct ?

If(FindOneOf( Product_Cat, ':'),subfield(Product_Cat,':',2),[商品サブカテゴリ]) as Product_Cat_Jap,

Thanks ,

Rupali

[abhijitnalekar]

If(FindOneOf( Product_Cat, ':')>0,subfield(Product_Cat,':',2),[商品サブカテゴリ]) as Product_Cat_Jap,

[Vegar]

Looking at your sample it seems like you are trying to get the last subfield value separately by ':' for Product_Cat.

Maybe you can simplfy your expression to this:

subfield(Product_Cat,':',-1) as Product_Cat_Japan