chulett wrote:Terminators in the final column must be Quoted to be recognized as data, meaning inside the quoted string that is the final column's data. ...
Hi Chulett,
I didnot get exactly what you meant by "Terminators in the final column must be Quoted".
Firstly my input data to the sequential file :
Name|EmpID|Description
Ravi|001|This is Ravi
Raj
esh|002|This is
Rajesh
Raghu|003|This is Raghu
My output should be :
Name|EmpID|Description
Ravi|001|This is Ravi
Rajesh|002|This is Rajesh
Raghu|003|This is Raghu
What we did to achieve this :
To handle newline in the "name" field,if we enable "Contains Terminators" to yes and apply Convert(CHAR(13):CHAR(10),"",Name) in the transformer,it has handled newline character for the first field and the ouput will be :
Name|EmpID|Description
Ravi|001|This is Ravi
Rajesh|002|This is
Rajesh
Raghu|003|This is Raghu
My concern here is how to handle the new line character in the "Description" field?
What we did was:
if we enable "Contains Terminators" to yes,It was prompting that
Column "Description" cannot cantain a non-qouted terminator because it is the last column of a delimited sequential file"
if we enable "Contains Terminators" to Quoted and apply Convert(CHAR(13):CHAR(10),"",Description) in the transformer,
the output will be :
Name|EmpID|Description
Ravi|001|This is Ravi
Rajesh|002|This is
Rajesh Raghu|003|This is Raghu
We are not sure what you meant by exactly "Terminators in the final column must be Quoted".Is that something the actual data in Description column should be quoted?
i.e
Name|EmpID|Description
Ravi|001|This is Ravi
Raj
esh|002|"This is
Rajesh"
Raghu|003|This is Raghu
It didnot work as well.
Thanks
Kiran