Searching special character using "FIND"

harshitha.narayan
harshitha.narayan
in Modeling

Hi All,

 

Just want to clarify if I can use FIND function to identify a special character.

So I want to check if the string contain "@" ; the logic I am applying is:

 

Line item 2 = FIND("@xxx.com", Line item1, 1) 

But it is not giving me the result. But works fine when I am setting the formula without "@".

 

Line item 2 = FIND("xxx.com", Line item1, 1) - this is working fine.

 

So I want to know that FIND does not identify the special characters is it?

Tagged:

Best Answer

  • alexpavel
    alexpavel
    Answer ✓

    harshitha.narayan@sony.com  Thanks for sharing...

    I did not know, but indeed, if the text line-item is formatted as E-mail, and you have a different Display text associated, the FIND function try to search text in the "Display text" part and not the e-mail value:

     

    alexpavel_0-1662454839254.png

     

    Hope it helps

    Alex

     

Answers

  • jagadishdash
    jagadishdash

    Your Approach and formula is correct and  will working fine as you mentioned. 

    And FIND can give the result for special character as well'

    jagadishdash_0-1662448926724.png

    jagadishdash_1-1662448996586.png

    My display text is "Multi_Event@.com Selected" 

     

    Hope you got it.

    Thanks,

     

     

     

  • alexpavel
    alexpavel

    harshitha.narayan@sony.com I did not encounter any issues with @ character using FIND function. 

    The function FIND can find special characters like @.  

     

    Can you give more explanations of what is in your case the expectation?

     

     

    alexpavel_0-1662451318301.png

     

  • harshitha.narayan
    harshitha.narayan
     

    Hello  @alexpavel and @jagadishdash thank you for the reply. It is working fine for you both.

     

    I shall check again from my end and get back.

  • harshitha.narayan
    harshitha.narayan

    Hi @alexpavel and @jagadishdash,

     

    I have checked on the format of Line item1 where I am finding the character. I noticed that I had selected text type as Email ID. I switched to text type to General. Post this change the FIND function is working properly.

     

    Thank you!

  • harshitha.narayan
    harshitha.narayan

    @alexpavel Sure noted! 

    Had kept the "Display text" part blank and had entered only the Email ID.

    Hence it was not able to Find. Understood the error committed.

Categories