Prabhu, I answered this on Stack Overflow [1] but I think you could do it with ReplaceText before the SplitText using a regex like
"(.*?)(\n)(.*?)" replaced with "$1\\n$3" [1] http://stackoverflow.com/a/42242665/70465 <http://stackoverflow.com/a/42242665/70465> Andy LoPresto alopre...@apache.org alopresto.apa...@gmail.com PGP Fingerprint: 70EC B3E5 98A6 5A3F D3C4 BACE 3C6E F65B 2F7D EF69 > On Feb 14, 2017, at 10:52 PM, Lee Laim <lee.l...@gmail.com> wrote: > > 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 <prabhuu161...@gmail.com > <mailto:prabhuu161...@gmail.com>> 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? >>
signature.asc
Description: Message signed with OpenPGP using GPGMail