framework icon indicating copy to clipboard operation
framework copied to clipboard

Does Frictionless Py support .txt format for validation?

Open megin1989 opened this issue 10 months ago • 0 comments

Description:

I am facing an issue where my CSV date field (YYYY-MM-DD) is being auto-converted to MM/DD/YYYY when opened in Excel. The only way to prevent this is by saving the file as a .txt format.

I would like to know if Frictionless Py supports .txt files for validation. If not, is there a recommended way to validate CSV files while preserving the original date format?

Steps to Reproduce:

  1. Create a CSV file with a YYYY-MM-DD date field.
  2. Open the file in Excel (which auto-converts the date).
  3. Save the file as .txt instead of .csv to prevent conversion.
  4. Try validating the .txt file using Frictionless Py.

Expected Behavior:

  • Frictionless should recognize .txt files for validation.
  • The date format should not be altered during validation.

Additional Context:

Would appreciate any guidance on handling CSV validation while preserving date formats. Thanks!

megin1989 avatar Feb 20 '25 04:02 megin1989