3 Replies Latest reply on Oct 28, 2014 8:53 PM by philmodjunk

    Calculation - find middle of a string

    RuiSampaio

      Title

      Calculation - find middle of a string

      Post

      Hi,

      I have a field called ID_EVENT witch has values like ABCD-DOC-2012-0001 or ABCD-AUDIO-2013-00004

      I need to add another field called FOLDER_TYPE witch would be filled with DOC or AUDIO depending the case of the field ID_EVENT of that record.

       

      I already have more than 2000 records, so my question is how can I do it at once?

      Is a calculation the best way? I thought so, but I stuggled to do the find.

      Thanks in advance for the help