Forum Discussion

Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Jun 29, 2023

Re: TEXT EXTRACTION

anupambit1797 

It is just a big number. Bigger than the maximum textlength in your data.

Maybe 999 could be enough.

 

7 Replies

    • JoeUser2004's avatar
      JoeUser2004
      Bronze Contributor
      Jul 05, 2023

      anupambit1797 

       

      Is this what you are looking for?

       

      =IF(ISNUMBER(SEARCH("SDX65",A2)), "SDX65", IF(ISNUMBER(SEARCH("SDX70",A2)), "SDX70", ""))

       

      Replace SEARCH with FIND, especially if you want a case-sensitive search.

       

      -----

      Alternatively:

       

      =IFERROR(MID(A2,SEARCH("SDX??",A2),5), "")

       

      returns any 5-character string that begins with "SDX" (or "sdx" or any combination of mixed case).

       

      Note that we cannot use FIND (for a case-sensitive search) here because FIND does not allow wildcard characters like "?".

       

      • anupambit1797's avatar
        anupambit1797
        Iron Contributor
        Jul 05, 2023
        Thanks Joe, this is indeed a Very useful info between search and find..
      • anupambit1797's avatar
        anupambit1797
        Iron Contributor
        Jul 05, 2023
        Because, from my understanding , solving problems with more than one method is always useful to explore, Solution is not the only last thing , on how many ways we can explore to solve it seems more important..

        anyways I tried to use the IF there and seems some minor thing I am missing , will check this more..

        Thanks & Regards
        Anupam Shrivastava

Resources