What is the difference between "search" and "find" calc function?

[altair]

Please, what is the difference between “search” and “find” calc function?
Many thanks

Ans: I looked in help, but I am not sure I understood. btw, both are strings.

[mariosv]

Please @altair, Have you looking in the help?

[mariosv]

Looking at the help definitions:

• FIND is case sensitive, SEARCH() not.

• FIND doesn’t allow regular expressions, SEARCH() yes.

  FIND
  Looks for a string of text within another string. You can also define where to begin the search. The search term can be a number or any string of characters. The search is case-sensitive.
  Syntax
  FIND(“FindText”; “Text”; Position)
  FindText refers to the text to be found.
  Text is the text where the search takes place.
  Position (optional) is the position in the text from which the search starts.

  SEARCH
  Returns the position of a text segment within a character string. You can set the start of the search as an option. The search text can be a number or any sequence of characters. The search is not case-sensitive.
  The search supports regular expressions. You can enter “all.*”, for example to find the first location of “all” followed by any characters. If you want to search for a text that is also a regular expression, you must precede every character with a \ character. You can switch the automatic evaluation of regular expression on and off in Tools - Options - LibreOffice Calc - Calculate.
  Syntax
  SEARCH(“FindText”; “Text”; Position)
  FindText is the text to be searched for.
  Text is the text where the search will take place.
  Position (optional) is the position in the text where the search is to start.

[varallibre]

And what happens if the find or search fails? I want do different things depending on whether a text is present in a cell or not.

[mariosv]

You can capture the error with IFERROR(search(…);Value when error)