List all column headers in a file
Options
Tom_153935
Posts: 76
in Questions
Can I get a list of all the column headers in a file and/or table?
0
Best Answer
-
Hey @Tom_catalytic
There are likely a few ways to do this, but the following sequence should accommodate the need:
- Excel: Create spreadsheet or CSV file: This will convert your .xlsx workbook to a .csv.
- Files: Convert file to text: To save the comma-delimited file you created in step 1 as a text field.
- Text: Find text next to other text: This will allow you to parse the header row from the rest of the text.
- Text: Find and replace: To replace the comma-delimited list of headers with new lines (for a list format).
Let me know if any other questions.
Thomas
5
Answers
-
Word of caution is that the text field has a field size limit. So try to reduce your file or get exactly what you need from the file before your convert the csv to text.
0