Skip to Content
0
Mar 01 at 05:45 AM

Fixed Width

167 Views Last edit Mar 01 at 07:39 AM 5 rev

Hi Experts ,

I have data in text files and i have created cfg files with fixed width . after creating files i am unable to read the data properly .below is the sample data .

EX: industrystandard dummy text

COLUMNSSTARTENDPOSITION=0-4;10-17;

ROWLENGTH=17

COLUMN=COL1;VARCHAR(5)

COLUMN=COL2;VARCHAR(8)

as per above example i can read only first 5 characters(0-4) but i am not able to read next 8 char(10-17). I am using HANA SDI in Work bench (Classic) and extracting the data from Files .txt format using File Adapter.

Please suggest

Regards

Ramesh