IF/LIKE operator question

[#1]

I need help with coming up with the correct syntax in my load script that I believe requires the IF operator.

I have a field (JOB_GROUP) where the values consist of backup jobs and application jobs.  All of the field values that start with BU are backup jobs and everything else are application jobs.

In my load script I think the best approach would be to create two addition fields (BACKUP_JOB and APPLICATION_JOB).  I intend to add a list box to my document so that users can filter on the job types.

I’m not sure if I should be using the LIKE or MATCH operator or something else entirely when creating these new fields.  Any help would be greatly appreciated.

[Anonymous · Accepted solution]

Shannon

In your load script how about:

     if ( left( [JOB_GROUP] , 2 ) = 'BU' , 'Backup Job' , 'Application Job' )      as [Job Type]

Best Regards,     Bill

[#3]

This works and got me what I needed.  Thanks so much!