Extract part value of another column - I have a column on my form that has two values concatenated and I want to extract part of that value

Discussion created by ArdeviaForum on Aug 19, 2016
Latest reply on Aug 19, 2016 by ArdeviaForum

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.