Forum Discussion

philliperamos's avatar
philliperamos
Contributor
6 years ago

Get column headers from within the file

Good day all,

I have a .txt file that looks like:

All the rows have the “header” info before the value.
e.g. Column Ordinal: 13 Expected Data Type: Date

Every row has the same info. (e.g. Column Ordinal, Expected Data Type, etc.)
I would like to have the values with their respective columns by getting the value using the : as a separator between header info and value.

I don’t know if this makes any sense, but let me know if you need any clarification as to the problem.

Thanks.