I'm concatenating some values into a Summary field in a workflow activity as follows:
IIF(Eq([//Target/Code1],True),"1,","")+IIF(Eq([//Target/Code2],True),"2,","")+IIF(Eq([//Target/Code3],True),"3,","")
So if Code1 and Code2 are true I get a Summary Value of 1,2,
Now I want to trim the trailing comma.
So I did this
Left([//Target/Summary],Add(Length([//Target/Summary]),-1))
This part doesn't work. It says Left is improperly formatted or missing a parameter.
If I put a numeric value like 1 or 2 as the second value it works.
Any suggestions on how to get trim a character off the end of a string in a FIM Workflow activity?