How to load unstructured data from text file into HANA using SQLScript

Hi Community Members,

I have a requirement where I need to extract data from the text file and load it into the HANA tables. The text file is contained data as shown in the attached file.

Highlighted one show fields and corresponding data for example:

data Input # :

"Slot1:Profibus (Dual, MS)

Slot2:No Interface

Slot3:15V User (Single, Isolated)"

The needed output as below

Would anyone like to share an experience or suggest how can it be done?

It will be a great help and appreciated.

Thank You

Sunil Sharma