11 Replies Latest reply: Jul 1, 2014 3:47 AM by Geeta Alhan RSS

    Make a new field based on string content of other field

    heydaraliyev

      I have a field that lists resources for activities.  It lists them like this "Scaffold Builder, IQC" or "Mechanic, QC" or "Insulator, Civil Quality Control"

       

      What I'm saying is I was a new field that will classify each row in my data by resource by looking at the contents of this string for in code style, i want to make a field that looks at each cell in the "resource" field and does this pseudo code

       

      //Instring(ref to string to be searched, term to search for)

       

      if( Instring([resource],"Scaff")) THEN [newresource]="scaff" else if(instring([resource],"Mech") then [newresource]="Mech"

       

      I want to do this to each cell of data, so that the data is generalized instead of mixed in with QC resources.

       

      Thanks for any help,

       

      MZ