You are viewing limited content. For full access, please sign in.

Question

Question

Eliminate " and \ from a result in Workflow by function or regular expression.

Updated September 14, 2016
asked on September 14, 2016

I got this result from a WS:

"<MiroDetalle><NumeroFactura><\/NumeroFactura><NumeroFacturaCancelada><\/NumeroFacturaCancelada><AnnoFiscal><\/AnnoFiscal><DocumentoContable><\/DocumentoContable><CodigoOperacion>1<\/CodigoOperacion><Mensaje>Formato de XML o campo institucion no valido<\/Mensaje><\/MiroDetalle>"

 

The " and the \ make noise to me and i need to use the xml to achive the next step. I can achive this maybe crossing the result by sql to remove values but i want to know if its possible to achive it by function or regular expression.

0 0

Answer

SELECTED ANSWER
replied on September 14, 2016

Sure, you can run a [^"\\]+ regular expression on it set to "all matches" or run the Remove token function twice, once for the double quote and once for the slash.

1 0
replied on September 14, 2016

Hi Miruna.

 

Non of them work. I already try the double remove funtion and dont remove any of them and the [^"\\] return this: <MiroDetalle><NumeroFactura><

0 0
replied on September 14, 2016

Whait I see that my method is with token editor and in that way doesnt work because I can not say: "all matches" in token editor but with a pattern matching i do.

Ill try that then. But the "Remove token function" that option does nothing.

Thanks for the tip Miruna.

1 0
replied on September 14, 2016

Sorry, my mistake, the Remove function applies to multi-value tokens. You could use it but it would be slightly more complicated. Pattern Matching is the easier way.

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...