Pattern: Delimit .TXT or .CSV File with New Delimiter
The attached pattern allows one to upload a .txt or .csv file, and change the delimiter from a comma (,), semicolon (;), vertical bar (|), or tab to any of the others in that list. There is also a choice field at the start that will optionally create a data table or Excel (.xlsx) file from comma-delimited .csv files you generate.
This pattern may allow you to work with datasets in Catalytic that are not already be in a .csv or .xlsx format for import.
There are two current limitations as this is built currently:
- This will not work for extremely large datasets. There is a 64000 kb limit (condition) for the .txt or .csv file you upload, but you may be able to increase this. Keep in mind field size limits.