Assign Activity Error: Missing operand after 's' operator

[atarantino]

I’ve run this process daily for a few weeks with no errors but this morning I ran it and get an error on an assign (see below). Not sure what it means or how to fix it.

[Yoichi]

Hi,

Can you share content of CurrntRow(“Defendants”)?

Regards,

[Anil_G (Anil Gorthi)]

Hi @atarantino

Looks like your currentrow(“Defendants”).ToString has a literal(') in it and that is why it is failing

cheers

[atarantino]

This was the issue. Is there a different way i can write my code to allow for (') ?

[Anil_G (Anil Gorthi)]

@Anil_G

and

@atarantino

Try usring currentrow("Defendants").ToString.Replace("'","''")

That might escape the single quote

Basically replace single quote with two single quotes

cheers