I have text file generated every day as follow:
Column1 Column2 Column With Whitespace Column4
Data1 Data 2 Data 3 Data with whitespace
Data with whitespace Data 2 Data 3 Data
As you can see I have only column names fixed and data can be one word or combination of words with blank space. Some of my fixed column names also combines two or three words. (see 3rd column)
Any chance I can parse this data and create a hash table? I couldn`t find a logic to parse it.