Input tool and delimiters - client/server side

BastianB — Mon, 15 Mar 2021 13:54:13 GMT

Hello everyone,

I'm having an issue that looks like a quickfix - if you know what to do. Which I don't.

The issue is the following:

I'm using an input tool to read data from a .CSV File and an userinput+update tool to change the delimiter of said input tool to match the file.

It works fine on my client, I can use all kind of .CSV-Files and just select the right delimiter and the workflow works.

Now once I upload it to the server and the interface is now web based, some options don't work anymore.

-I take a comma seperated CSV and selected "," as my delimiter and it works

-I take a tab seperated CSV and selected "\t" as my delimiter and it works

-I take a Pipe seperated CSV and selected "|" as my delimiter and it's an error: Parse Error at char(1): Unknown variable "Col1|Col2|Col3"

Same error for semicolon.

The thing is, it works all over the same input and update tool. The input is all the same too apart from the delimiters for example:

Col1,Col2,Col3

Col1|Col2|Col3

etc.

No white spaces either. Workflow works without error for all types on my client but not on the server.

Any ideas? It's the first time I'm dealing with the server side of things

Re: Input tool and delimiters - client/server side

afv2688 — Thu, 18 Mar 2021 12:20:19 GMT

I have tried a solution with this kind of interface and seems to work on my server.

Could you try to set this up and see if it works for you too?

Note: I'm on 2020.4 on both, designer and server

Regards