Loading Pipe Delimited Text File with Files Source

Summary

The user is asking if it’s possible to load a pipe delimited text file using the Files source and encountered an error while trying to set up the connection.


Question

Hey everyone,
Is it possible to load a pipe delimited text file using the Files source? I’ve tried (specifiying the delimiter is a pipe like this in the Source: {"sep": "|"} ) but ran into this error while trying to setup a connection



This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

["pipe-delimited-text-file", "files-source", "delimiter", "error"]

You should be able to use custom delimiters as the source file uses pandas. More information you can get gere about the read_options available: https://docs.airbyte.com/integrations/sources/file#reader-options