topic Re: Calculate Value Replace Expression in Python Questions

Calculate Value Replace Expression

MatthiasAbele — Mon, 22 Aug 2011 11:55:33 GMT

Hallo,

I'd like to iterate through a list of values. The values are used as field name inline variables and sql-expression for a select command.

To build the sql statement from the list, I use the calculate value function.
My list elements look like: !0?2,!0?4
I am trying to get the sql-statement by the following command in the calculate Value - tool:

"%Value%".replace("!",""vges>=").replace("?",".")

But I always get an error:

ERROR 000539: Error running expression: "!0?2".replace("!",""vges>=").replace("?",".") <type 'exceptions.SyntaxError'>: invalid syntax (<string>, line 1)
Failed to execute (Calculate Value).

What could be the reason?

Attached an overview from the modell builder.

Thanx,

Matthias

Re: Calculate Value Replace Expression

MarcNakleh — Wed, 14 Sep 2011 00:31:55 GMT

Hello there,

I don't know if the answer to this question is still relevant to you, but there are a couple of things that strike me as strange about your expression:

1) There seems to be an extra quotation mark in your first replace ""vges>=". Alternatively, if you wanted to keep the extra quotation mark, you would either need to escape it ("\"vges>=") or encapsulate the whole string in single quotes ('"vges>=')
2) The field placeholder for Python snippets is !FieldName! with no quotations around (or the value would be interpreted as a literal.)

Either of these could be giving an invalid syntax error. Given the above, I would write the expression as:
!Value!.replace('!', 'vges>=').replace('?', '.')

I hope this helps!

Re: Calculate Value Replace Expression

MatthiasAbele — Wed, 14 Sep 2011 05:50:45 GMT

Thanx, your points were right; that is the way I could fix the problem.

Matthias