Field function issue

[xch2005]

Hi,

Basically we are trying to generate and extract when the run flag is "YES" and process type is "A" (or) "YES" and process type is "M" (or) "NO" and process type is "M".



Step 1 - An output text file is created with 2 columns and delimiter is comma (sample data in output file given below)

Sample file (first column is run flag and second is process type, manual or automatic):

NO,M

Step 2 - check the data in the output file from previous step. If the value in first column is "NO" and second has "A" then the execution should stop else continue

Step 3 - used a execute command activity in the job sequence as below , for the workflow to continue to next step

Code: Select all

	((Field(exc_run_or_no.$CommandOutput,",",1) = "YES" And Field(exc_run_or_no.$CommandOutput,",",2) = "A") Or 
	 (Field(exc_run_or_no.$CommandOutput,",",1) = "NO"  And Field(exc_run_or_no.$CommandOutput,",",2) = "M") Or 
  	 (Field(exc_run_or_no.$CommandOutput,",",1) = "YES" And Field(exc_run_or_no.$CommandOutput,",",2) = "M"))

Step 4 - given the below of the condition to stop the workflow (in another link of execute command stage in job sequence)

Code: Select all

(Field(exc_run_or_no.$CommandOutput,",",1) = "NO" And Field(exc_run_or_no.$CommandOutput,",",2) = "A")

Is there any issue with the FIELD function as the job does not continue even if the output file has NO,M in step 1?

Please let me know your thoughts, thanks.

[chulett]

Your problem is not with the Field function, although to be honest I didn't look at your syntax all that closely. I'm wagering your issue is going to be the traditional one where $CommandOutput has a Field Mark (@FM) in it and you need to remove them from the output before you do your comparison because it is adversely affecting your Process Type check.

Probably best to do the manipulation in a User Variables Activity stage once and then refer to them multiple times afterwards rather than parse the command output over and over (and over) like that.

[ray.wurlod]

What exactly does the Execute Command activity do? That is, what command does it execute?

[chulett]

I was wondering the same thing but guessing... cat.

[xch2005]

Thanks chulett and Ray.

In the execute command activity, it is just cat <filename> and text file is created in prior step with 2 columns delimited with comma.

So, do I need to add @FM for each column in the FIELD function?

Please advise.

Thank you.

[chulett]

While perhaps you could do that, the standard approach would be to remove them from the output. Once.

Code: Select all

Convert(@FM,"",exc_run_or_no.$CommandOutput)