How to delete leading multiple carriage returns and blank spaces.
I have a field populated like this:
Books > Children's Books
Books > History
Books > Study Books
I'm trying to get rid of all of the CRs by using this script:
Set Field [Category::category; Substitute(Category::category; "¶"; "")]
It is not making any changes to the field. What am I doing wrong?