Extra blank line in download text file (.txt)
Posted 30 September 2005 - 08:27 AM
In \US\, i write the data in the seq file using Add mode and mark the Clear File = 'Y'.
I am NOT using LF or CR in my function.
Anyway what is LF and CR?
Posted 30 September 2005 - 09:09 AM
At the Logic In of my update function, i used
ALIAS('seq filename', physical filename)
Then at the update start, i just read some files to get the data i want and write into the seq file.
The seq file is Add Mode and the logic to write the data into this file is placed in the Before Write.
Then i got mark Clear File.
So, anyone can help in this matter as soon as possible?
Need to take out the blank line to allow my functions to work properly when send to user.
Posted 30 September 2005 - 09:40 AM
You aren't using Superlayer by any weird chance ? Update start is something that I've never heard of.
So pretty much what you saying :
at Function Entry/LS Entry Logic you have ALIAS('SEQFILE','FILEPATH')
you then have
SEQFILE Y for clear with logic on BW to setup your fields ?
Is your seqfile defined as having a single field ie DATA etc or have you defined them as separate fields.
To me it sounds like you have a data problem ie the record doesn't exist on one of the files and your SEQFILE isn't getting set up correctly. Can you try your extract for a different dataset and see if you get the same results ?
Posted 30 September 2005 - 10:06 AM
I'm using superlayer...
it is an update function
Logic in of the function,
I had Alias(File2,'abc.txt')
at default logic,
I had my SQL query to select from a file,
the file design as below:
File1 (Lookup mode)
File2 (Write Mode)
so when i open the abc.txt,
there is always a blank line appear at the last line!!!
**the data is no problem ...
3 records in file1
but when i open abc.txt, there is always 4 lines, with the last line is a blank line!!!
I think my problem is quite similar to the poster "space"
Posted 30 September 2005 - 11:16 AM
record xxx no data
looking at my txt file with notepad there is a little square at the end of the last record which I think is an end of file marker and word seems to treat this as the last record.
Space, when you look the the txt file with notepad do you have a square at end of your file?
Posted 30 September 2005 - 11:57 AM
you would have to add the CHAR(13) and CHAR(10) codes yourself to the end of each line when you write them to the file, but very likely, pro-iv won't add something at the end of the file.
I can't remember if you have to send a CR/LF or a LF/CR. Just try and see what happens.
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users