Database output - How to add carraige return or line feed on flat file

Hi Everyone, my name is Tony Lim
I am seeking any of your help to solve my problem. I have created a UBE feature convert my data into flat file. But somehow the result didnt show up line by line in contract it showed two lines in one row.

So i am thinking is there any way to include the carraige return or line feed in order to generate all my record row by row.

Urgent to receive your suggestion.
Thanks

how exactly do you write your data to flat file? i've used bsfn 34A1010 - Write One Line To Flat File several times in the past, and that one automatically adds a "\n" (line feed, new line) at the end of each line written to flat file.

Hello,

May be you can use BSFN (B9861B - Add a Carrige Return
to string) to split the line.

Thanks,
Mitu
8.11

or, You can use assignement (x=) with that (f(x)) value :

string_variable = concatenate(string_variable, "
") --> just typing <enter> in the box between the ""

I had a similar problem last week.I used export to flat file BSFN by concatenating all the varibles into a single variable. There were some junk characters appearing.So I used Add carriage return BSFN which solved the problem

Hi,

I expect "Get New Line Character" business function will work in your case. this will retrieve Enter Charcter into a character variable. Append this to the end of the string.

Regards,
Kiran

B9861B worked great for me. Thanks for the info!