Tab delimited file - no longer supported?

  • 192Views
  • Last Post 28 December 2022
  • Topic Is Solved
0
votes
Stew Stremel posted this 21 December 2022

Hi there,

I have a package that I have been using for a long time pulls data from a text file that is delimited with tabs.  It has been working great but I need to make a change to update a source column header and it now responds with 'Invalid file'.  Are tabs no longer supported?

Cheers,

Order By: Standard | Newest | Votes
0
votes
Yevheniia Bilotserkovska posted this 22 December 2022

Hello Stew.

Thank you for contacting us.

Could you please clarify the Package Id you have an issue with?

Have you tried to refresh the Package after you changed the Source column header and save it before the run? If no, please try and let us know the result.

We are looking forward to hearing from you.

Best regards,

Yevheniia Bilotserkovska.

 

0
votes
Stew Stremel posted this 24 December 2022

I see now that my problem is that the file format was changed from the source provider - they used to send CSV files but are now sending it as a tab delimited file (with a csv extension).

Can you support tab delimited?

Cheers,

0
votes
Yevheniia Bilotserkovska posted this 28 December 2022

Hello Stew.

Thank you for the update.

Unfortunately, at the moment tab-delimited files are not supported by Skyvia. 

A column separator can be a comma (,), a semicolon ( ; ), a slash (/), or a vertical bar (|).

More details can be found here https://docs.skyvia.com/data-integration/common-package-features/csv-options.html

Could you please email us directly with your example of the tab-delimited file so that we will investigate the possibility to support it and let you know the result of the investigations? 

We are looking forward to hearing from you.

Best regards,

Yevheniia Bilotserkovska.

0
votes
Stew Stremel posted this 28 December 2022

Thanks!

Close