Parse CSV file as a PSV?

Question

Hi there,

Looking to see if it's possible to parse a CSV file as a PSV?

As can be seen on the attached image,there's many options in the drop down but not one for PSV.. any help on getting round this issue?

Usually would run the file as a PSV in our workflow but when I try to run the workflow with it saved as a CSV then I get the following error "locating or opening file in the archive: Bad File" - any idea on what this means either? Please find an image of this also attached.

Help / support most appreciated.

Tristan

MicrosoftTeams-image.png

MicrosoftTeams-image (1).png

caltang · Answer

It appears you're reading a zip file that contains a CSV/PSV file? Can you show the file directly and provide a sample? Just dummy data within the PSV inside a zip file, then we can help.

Otherwise, you'll need to play around with the XML a bit to get the file details and file itself to appear. But I've not seen/heard of a PSV file before.