Hi,
I have a job db2...>trns...>seqential file.I'm extracting data and populating into a file.Source has 2 rows but when populated into file the file count is 10.
I have used
CONVERT(char(010),char(032),trim(fieldname)) in transformer to replace new line with space..but it is not working....
data is like this :
Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3
Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3
repeated lines.
It is a longvarchar(1500) field.I should get the data in single line instead of multiple lines.Please advise....
Thanks in advance
mutliple line data into single line
Moderators: chulett, rschirm, roy
mutliple line data into single line
sravanthi
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Ray,ray.wurlod wrote:Dump the data to a text file, and there examine it with a hex editor such as UltraEdit. ...
I have used ultaedit and when checked view line endings it was displaying at the end
Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3
Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3
Please advice.
Thanks!
sravanthi