topic Re: LEFT WITH TRIM AND IF STATEMENT in App Development

LEFT WITH TRIM AND IF STATEMENT

Uri — Sat, 16 Nov 2024 17:49:15 GMT

Hi!

I have 2 fields: price and phn_num.

In phn_num field I want to display following:

If price is 0 then I want last three digits of phn_num to be replaced with XXX.

BR,

Artur

QFabian — Mon, 16 Nov 2020 17:47:29 GMT

Hi @Uri !, please try this :

if(price=0, mid(phn_num,1, len(phn_num)-3) & 'XXX', phn_num)

Uri — Mon, 16 Nov 2020 18:00:18 GMT

It works as expected!

Thank you!

BR,

Artur