This function is used to split a given string based on a delimiter and pick out the desired field from the string, start from the left of the string.

SELECT split_part('1234-#-Acme parts-#-order', '-#-', 2);

In the example above, the delimiter of the defined string is '-#-' and specified field number is 2. So the split_part function splits the second field from the specified string and returns ‘Acme Parts’.