Relimiter for text files

A utility for robustly changing the delimiter within text files in order to make them easier to use
209 téléchargements
Mise à jour 20 jan. 2015

Afficher la licence

This utility intelligently provides a new delimiter to a file while ignoring any instances of the delimiter that occur between double quotes (or other qualifiers).
It's often the case that a comma-delimited file will use commas both as delimiters and within text cells. In the latter case, the cell is usually surrounded by double quotes ("like this") or some other qualifier to indicate that the comma within is to be ignored as a delimiter.

MATLAB does not pay attention to this in functions like READTABLE and DATASET, to the annoyance of the end user.

This function provides one solution: it creates a temporary file that is delimited with a different delimiter (by default, '|') but otherwise identical. It correctly ignores the space between qualifiers. This can be called before READTABLE or DATASET, and the downstream code base is thus unaffected.

Optional arguments allow you to control the output file location, the new and old delimiters, and the text qualifier character. Attention has been paid to execution speed, but further suggestions for speedups are welcome.

Citation pour cette source

Michael Weidman (2024). Relimiter for text files (https://www.mathworks.com/matlabcentral/fileexchange/49096-relimiter-for-text-files), MATLAB Central File Exchange. Récupéré le .

Compatibilité avec les versions de MATLAB
Créé avec R2013a
Compatible avec toutes les versions
Plateformes compatibles
Windows macOS Linux
Catégories
En savoir plus sur Dates and Time dans Help Center et MATLAB Answers

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!
Version Publié le Notes de version
1.0.0.0