Field data distribution (Text parsing)
OK, this should be a simple one, for You good people!
Lets say i have a field called "Bank | Account" in the table called Employees which is consisted of records that look exactly like the field name, for example "Bank name | 123 - 456789 - 11".
I want to create two addition fields in the same table, called "Bank" and "Account" and distribute appropriate data in to them from the original field! I know it has something to do with calculations, but I just cent seem to get the right one!