topic If else condition if we have data in combination of number,text in App Development

If else condition if we have data in combination of number,text

grajmca_sgp123 — Sat, 16 Nov 2024 18:08:57 GMT

I have a Period column with combination of integer and text.

I have a requirement to create a new filed,first it will check if it contains integer return same if not return "Others"

I have tried below logic,but didn't worked.

if(IsNum(Period)>0,Period,'Others') as Newfield

Period

03M

06M

01M

03M

06M

01D

RBWM

CMB

Re: If else condition if we have data in combination of number,text

tresB — Fri, 04 Sep 2020 11:54:35 GMT

Try:

if(IsNum(Period),Period,'Others') as Newfield // no '> 0'

Re: If else condition if we have data in combination of number,text

grajmca_sgp123 — Fri, 04 Sep 2020 11:59:22 GMT

tried but no luck,all are returning else part as "Others"

Re: If else condition if we have data in combination of number,text

stevedark — Fri, 04 Sep 2020 13:01:45 GMT

May be best to always treat it as a string and go for string functions only:

if(len(purgechar(Period, '0123456789')) = 0, Period, 'Others') as NewField,

You may also find that the num# function works

if(IsNull(num#(Period)), 'Others', Period) as NewField,

Re: If else condition if we have data in combination of number,text

Kushal_Chawda — Fri, 04 Sep 2020 14:35:19 GMT

@grajmca_sgp123 try below

if(KeepChar(Data,'0123456789'),Data,'Others') as NewField

Re: If else condition if we have data in combination of number,text

grajmca_sgp123 — Fri, 04 Sep 2020 14:36:12 GMT

Thank you Steve,I just updated your logic and worked well.

=if(Len(KeepChar(sunf,'0123456789'))>0,sunf,'Others')

Re: If else condition if we have data in combination of number,text

stevedark — Fri, 04 Sep 2020 14:45:36 GMT

Sorry, I assumed that as you were using IsNum in your original query you only wanted if the field only contained numeric. This is why IsNum will not have worked if the field was a mixed string.

Thanks for the update.