How to update delimeter of a csv file via user input

Hi everyone,

I know this must be a straight forward thing to do but I am struggling to solve this tiny problem. I have multiple csv files with delimeters as "\t", "|" and "," etc. My workflow accepts maximum of two csv files. I want user to provide this delimeter information so that the workflow reads the column of the file correctly. This is how I am trying to achieve:

The value of delimeter is not updated when I add a delimeter value in Drop Down tool. The screenshots are attached

Unbenannt.PNG

Unbenannt1.PNG

Datasets

Custom Tools

Bug

Data Investigation

Database Connection

Accepted answers

echuong1

Try using the version I attached in my previous post. It correctly updates the delimiter of the input tool.

You can also run your workflow in debug mode - go to View > Interface Designer. The second option down is debug mode. You can input your parameters and check to ensure everything is updating. It will open an "updated" workflow with the options selected.

All comments

echuong1

You can have both options in the same drop-down. Take a look at the attached.

New Workflow3.yxwz

pipe.csv

comma.csv

wtahir

Thank you for replying @echuong1 and correct but the delimeter value is not updated. If e.g. a file is "|" separated then the drop down tool does not update "," to "|" as user inputs. I am struggling to do that even for a single file. As you can see in my cofiguration what I tried. The delimeter does not change in file input tool. I am unable to update delimeter using a drop down tool.

echuong1

Try using the version I attached in my previous post. It correctly updates the delimiter of the input tool.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15881

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703