topic Syntax Help in QlikView https://community.qlik.com/t5/QlikView/Syntax-Help/m-p/192357#M54039 <HTML><HEAD></HEAD><BODY><P>I have a phone number which can be either 13 or 14 positions long and I need to get them into one field called callingpartynumberno. I am doing this during my SQL extract, but getting an error. I need to have the If's due to other phone numbers being 2 or 5 positions. Please help. Thanks</P><P>if (len(trim([callingPartyNumber])) = 13,<BR /> PurgeChar([callingPartyNumber], Chr(34))),<BR /> if (len(trim([callingPartyNumber])) = 14,<BR /> PurgeChar([callingPartyNumber], Chr(34))) as [callingPartyNumberNo],</P></BODY></HTML> Thu, 31 Mar 2011 11:27:14 GMT tmumaw 2011-03-31T11:27:14Z Syntax Help https://community.qlik.com/t5/QlikView/Syntax-Help/m-p/192357#M54039 <HTML><HEAD></HEAD><BODY><P>I have a phone number which can be either 13 or 14 positions long and I need to get them into one field called callingpartynumberno. I am doing this during my SQL extract, but getting an error. I need to have the If's due to other phone numbers being 2 or 5 positions. Please help. Thanks</P><P>if (len(trim([callingPartyNumber])) = 13,<BR /> PurgeChar([callingPartyNumber], Chr(34))),<BR /> if (len(trim([callingPartyNumber])) = 14,<BR /> PurgeChar([callingPartyNumber], Chr(34))) as [callingPartyNumberNo],</P></BODY></HTML> Thu, 31 Mar 2011 11:27:14 GMT https://community.qlik.com/t5/QlikView/Syntax-Help/m-p/192357#M54039 tmumaw 2011-03-31T11:27:14Z Syntax Help https://community.qlik.com/t5/QlikView/Syntax-Help/m-p/192358#M54040 <HTML><HEAD></HEAD><BODY><P>Got it to work missed place ")"</P><P>if (len(trim([callingPartyNumber])) = 13,<BR /> PurgeChar([callingPartyNumber], Chr(34)),<BR /> if (len(trim([callingPartyNumber])) = 14,<BR /> PurgeChar([callingPartyNumber], Chr(34)))) as [callingPartyNumberNo],</P></BODY></HTML> Thu, 31 Mar 2011 11:46:07 GMT https://community.qlik.com/t5/QlikView/Syntax-Help/m-p/192358#M54040 tmumaw 2011-03-31T11:46:07Z Syntax Help https://community.qlik.com/t5/QlikView/Syntax-Help/m-p/192359#M54041 <HTML><HEAD></HEAD><BODY><P>Hi <STRONG>Thom Mumaw ,</STRONG></P><P>Your Expression is correct but youe have check the arrangement of braces.. try the below one..</P><P>if (len(trim([callingPartyNumber])) = 13,<BR /> PurgeChar([callingPartyNumber], Chr(34)),<BR /> if (len(trim([callingPartyNumber])) = 14,<BR /> PurgeChar([callingPartyNumber], Chr(34)))) as [callingPartyNumberNo]</P></BODY></HTML> Thu, 31 Mar 2011 11:46:48 GMT https://community.qlik.com/t5/QlikView/Syntax-Help/m-p/192359#M54041 2011-03-31T11:46:48Z Syntax Help https://community.qlik.com/t5/QlikView/Syntax-Help/m-p/192360#M54042 <HTML><HEAD></HEAD><BODY><P>Thanks Arun....must not have enough coffee yet.</P></BODY></HTML> Thu, 31 Mar 2011 11:48:27 GMT https://community.qlik.com/t5/QlikView/Syntax-Help/m-p/192360#M54042 tmumaw 2011-03-31T11:48:27Z