It requires three functions: RIGHT(), LEN(), and SEARCH() function. This method will help you to achieve this result. For example, you can extract the domain name from the string after a particular character, i.e., (domain), from (email id). ![]() Similar to the above method, you can also extract the substring after a specific character. ![]() Extract a substring after a specific character In the end, the LEFT() function will execute and return the 10 leftmost characters from the original string, i.e., javatpoint.
0 Comments
Leave a Reply. |