AnsweredAssumed Answered

Field data distribution (Text parsing)

Question asked by MilutinPetrovic on Jul 27, 2013
Latest reply on Jul 27, 2013 by MilutinPetrovic

Title

Field data distribution (Text parsing)

Post

     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! 

      

     Cheers!

Outcomes