Jump to content


< Back to Forum


 

Evaluate Expression Left


  • Please log in to reply

#1 Maciej 16 July 2015 - 12:46 AM

HI,

 

I try to use evaluate expression but I found one problem

 

We use: LEFT($RV_DNIS,4) and want to recognize prefix (alphanumeric)

 

Using LEFT(221602937,4) we receive right result: 2216

But using for LEFT (CD17221602937,4) we receive empty result.

 

Can You help me WHY?



#2 SupportTeam 16 July 2015 - 06:54 AM

Please use quote characters around the input string. ie:

 

LEFT("CD17221602937",4)

 

also a good idea to have the quotes around any result variable expressions that should be treated as strings. eg:

 

LEFT("$RV_DNIS",4)