Question

Inserting Data that happens to match WF token format

Workflow

Updated May 17, 2021

asked on May 17, 2021

So I am parsing a csv file and inserting it into a SQL table with Workflow.

When the workflow runs, I eventually get the following error:

That didnt make sense so I searched the csv file. One of the fields happens to contain a format for workflow token.

So workflow thinks its a token has a problem.

I tried to add a branch to the worklfow that if the field that is going to be inserted matches regex .*%\(.* then try and pattern match and split it up. Get first part up to the ( through pattern match. Then get the second part. Then simply update to the token to be the first and second part with a space in-between and insert that..

However, when even trying the pattern match I get the following error:

Any ideas as how to solve this? I believe I have the way to identify if there is a problem with the value, but once identified it seems that every check relies on the value that workflow thinks is a token.

Thanks,

Chris

0 0

Replies

replied on May 17, 2021

I would write a VB script to parse the csv file first and to change the offending characters and output to a new csv file that will be consumed by workflow.

1 0

replied on May 17, 2021

There's nothing you can do on the WF side because all activities will try to resolve tokens before doing anything with the value.

If it was a SQL table instead of CSV, you could replace %( with /%( in the query to tell WF it's a literal value not a token.

0 0

You are not allowed to follow up in this post.

Question

Question

Inserting Data that happens to match WF token format

Replies

Sign in to reply to this post.