Skip to Content
0
Jul 01, 2020 at 08:45 AM

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

207 Views Last edit Jul 08, 2020 at 01:46 AM 7 rev

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

Attachments

vqc5e.png (7.7 kB)