Function Syntax Error Help?

PointsWell

This is what I've written:

IF INDEX_OF(' / '+ContractWork.psWork.psTitle.Title+' / ', Contract.hWorkList)>0 THEN 
	REPLACE_PATTERN (Contract.hWorkList, ' / '+ContractWork.psWork.psTitle.Title+' / ','')

But I am getting a validation error

Syntax error at token "(" (column 25).

Column 25 is the first bracket after REPLACE_PATTERN.

hWorkList is a text field and I have followed the user guide syntax completely - though obviously something's not right.

gijsvb

Hi,

I do think you're forgetting to update your variable. Maybe the statement should be something like:

IF INDEX_OF(' / '+ContractWork.psWork.psTitle.Title+' / ', Contract.hWorkList)>0 THEN
Contract.hWorkList = REPLACE_PATTERN (Contract.hWorkList, ' / '+ContractWork.psWork.psTitle.Title+' / ','')

Regards,

Gijs van Ballegooijen.

PointsWell

gijsvb wrote
Hi,

I do think you're forgetting to update your variable. Maybe the statement should be something like:

IF INDEX_OF(' / '+ContractWork.psWork.psTitle.Title+' / ', Contract.hWorkList)>0 THEN
Contract.hWorkList = REPLACE_PATTERN (Contract.hWorkList, ' / '+ContractWork.psWork.psTitle.Title+' / ','')

Regards,

Gijs van Ballegooijen.

Thank You!

This is what happens when you spend the morning writing Excel formulas and the afternoon writing AwareIM rules...