How to use split function with space as the delimiter

[drpeter]

Special character error on the split delimiter, please use single quotes or double quotes; seems the opening quote looks like an apostrophe:

Syntax (Detailed Function Documentation - click here)
split(expression, delimiter , position)

Incorrect
({ProductName}, ’ ', 1)

Correct
({ProductName}, ’ ', 1)
or
({ProductName}, " ", 1)