How scan, substr function works

Question

Accepted Answer

The scan function is used to search for a specific pattern within a string, while the substr function extracts a portion of a string based on specified starting and ending positions.

The scan function is commonly used in text processing to find occurrences of a specific pattern within a string.
The substr function is used to extract a substring from a larger string based on specified starting and ending positions.
Example: scan('hello world', 'world') will return the position of 'world' in the string.
Example: substr('hello world', 6, 11) will return 'world' from the string.

How scan, substr function works

Top HR questions asked in Novartis Statistical Programmer 1