Write(load) data into flat file.

[mohan_salla]

Dear Experts,
I have to load the data into a flat file and atleast leave first 4 rows blank(I meant say that Data should be written

into file from 5th row onwards in flat file).See below screenshot.

Could anybody advise me asap.

Thanks&Regards
Mohan

[Former Member]

Hi Mohan,

Use a BODS script to insert new lines into the file before calling them in DF.
For eg: (if Windows)

In script have :

1)delete the prev run target file present in folder

2) Insert new line to file.

exec('cmd','for %1 in (1 2 3 4) DO echo.>> C:\Users\A\Desktop\M1.txt',8);

3)After script have the DF with target text file with Write row headers enabled and delete file assigned to 'No'.

Now the target should have 4 newlines before the row header.

Similary if the OS is unix have unix command to insert new line.

Thanks,
Ancy