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

      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,