find () and index()

AKHILA — Sun, 23 Sep 2018 06:37:55 GMT

can anybody tell me the difference between find() and index() giving an example.

Re: find () and index()

Shmuel — Sun, 23 Sep 2018 07:32:22 GMT

find() -

Syntax -

FIND(string,substring<,modifiers><,startpos>)

"The FIND function searches string for the first occurrence of the specified substring, and returns the position of that substring. If the substring is not found in string, FIND returns a value of 0.

If startpos is not specified, FIND starts the search at the beginning of the string and searches the string from left to right.

If startpos is specified, the absolute value of startpos determines the position at which to start the search.

The sign of startpos determines the direction of the search."

index() -

Syntax

INDEX(source,excerpt)

"The INDEX function searches source, from left to right, for the first occurrence of the string specified in excerpt, and returns the position in source of the string's first character. If the string is not found in source, INDEX returns a value of 0.

If there are multiple occurrences of the string, INDEX returns only the position of the first occurrence."

Re: find () and index()

PeterClemmensen — Sun, 23 Sep 2018 07:42:05 GMT

The Find and Index function documentation sites explains the differences.

Re: find () and index()

AKHILA — Mon, 24 Sep 2018 16:02:53 GMT

thank you sir

Re: find () and index()

mkeintz — Mon, 24 Sep 2018 21:12:06 GMT

So don't leave this topic hanging. Mark the solution response, however "trivial".

topic find () and index() in SAS Studio

find () and index()

Re: find () and index()

Syntax -

Syntax

Re: find () and index()

Re: find () and index()

Re: find () and index()