Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Categories data sources
Created by Guest
Created on Jan 30, 2023

Fixed width files

Support fixed width files containing both single byte and multi-byte character.

  • Attach files
  • Guest
    Mar 7, 2023

    Tobias-san, thank you for the information.

    Fixed width files are not a modern format, but they are still used in some cases.

    I hope it will be supported at the adapter level.

  • Admin
    Tobias Lehtipalo
    Mar 7, 2023

    Yoshida-san, thank you for making this clear.

  • Guest
    Mar 7, 2023

    The fixed width files that can be introspected with CData TDV Adapter for CSV only support fixed width data consisting of ASCII codes, and files containing multi-byte character strings such as Japanese were not supported.

    Widh that can be specified in Schema.ini is the number of characters, not bytes.

  • Admin
    Tobias Lehtipalo
    Mar 3, 2023

    Note that CData has a TDV Adapter for CSV files that can be configured to read fixed width files.