Prabhu, You need to remove the new lines from within the last field. I'd recommend using awk in an execute stream command processor first, then splitting the text. Alternatively, you could write a custom processor to specifically handle the incoming data.
Lee > On Feb 14, 2017, at 11:01 PM, prabhu Mahendran <[email protected]> > wrote: > > I have CSV file which contains following line. > > No,NAme,ID,Description > 1,Stack,232,"ABCDEFGHIJKLMNO > -- Jiuaslkm asdasdasd" > used below processor structure GetFile-->SplitText > > In SplitText i have given header and line split count as 1. > > So i think it could be split row as below.., > > No,NAme,ID,Description > 1,Stack,232,"ABCDEFGHIJKLMNO > -- Jiuaslkm asdasdasd:" > But it actually split the csv as "2" splits like below., > > First SPlit: > > No,NAme,ID,Description > 1,Stack,232,"ABCDEFGHIJKLMNO > Second Split: > > No,NAme,ID,Description > -- Jiuaslkm asdasdasd" > So i have faced data handling missed something. > > GOal:Now i need to handle those data lines as single line. > > Any one help me to resolve this?
