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.