how to escape variable parameter with both quote and comma

Sun, 30 Jul 2017 19:19:35 GMT

Hi Everyone

Variable function is useful for defining the reusable business logic.

But I found in the variable parameter, it is risky if you have comma inside, because the variable function may treat it and parameter delimiter.

On the other hand it is also risky if you have quote in the parameter.

I have a simple use case:

I want to create a variable function like below:

vFF= num($1,$2);

$2 is the parameter for the format.

I found if you put value without comma, it is working. if u put in comma, it failed.

then I change to another approach:

EscapeCharsMap:
MAPPING LOAD * INLINE [
from, to
@,$
|,'
];

LET tt = MapSubString('EscapeCharsMap',
'num(100, @(=Replace(|$1|, |;|, |.|)) )'
);

This time, comma is working, but quote is not working.

can anybody have any solution?

Re: how to escape variable parameter with both quote and comma

ahaahaaha — Mon, 31 Jul 2017 14:14:34 GMT

Hi,

May be try to use instead of a comma Chr(44)?