Original Post by Sandy (Imported from Ardevia Forum)
I have a column in my list called 'Account No Name' which holds an account number followed by an account name. e.g 034567 - fees.
I need to update another column in the same list as this column called 'Account' which requires me to extract the account portion only, so anything before the '-'. This column will then be exported to excel for import into a financial system.
I have tried a number of variations on the substring function and can't get it to work.
Can anyone help with this.