Forum Discussion

User777's avatar
User777
Regular Visitor
3 years ago
Solved

Quotation mark in Text Filter

I am having trouble to filter data in new column: I have new column which i want to be filled like  Column 2 = if( [Retailer] = """KDK""", "YES", "NO")   The data i am looking for in column Retai...
  • nandukrishnavs's avatar
    nandukrishnavs
    3 years ago

    User777 

     

    Another method

    Column2 = 
VAR _text =UNICHAR(34)&"KDK"&UNICHAR(34)
VAR _result = IF([Retailer]=_text,"Yes","No")
return _result

     

nandukrishnavs's avatar
nandukrishnavs
Icon for Community Champion rankCommunity Champion
3 years ago

User777 

 

Another method

Column2 = 
VAR _text =UNICHAR(34)&"KDK"&UNICHAR(34)
VAR _result = IF([Retailer]=_text,"Yes","No")
return _result