I can answer this one - #1 - LITERAL puts a null record in, split does nothing (no blanks) resulting in 1 null record to count #2 - same as #1 (LITERAL expects one blank before the intended string; no string so null record) #3 - One blank added as literal, split strips it off, resulting in zero records
-- *James Vincent* -- President, SHARE Inc. -- Calendar: http://tinyurl.com/JSVCalWeek -- SHARE is an independent volunteer-led information technology association that provides *education*, professional *networking *and industry *influence* On Sat, Jan 2, 2016 at 6:09 AM, <amphitr...@ok.de> wrote: > What do you expect as result from following pipelines? > > > pipe(sep !)literal! split!count lines!term > > pipe(sep !)literal ! split!count lines!term > > pipe(sep !)literal !split!count lines!term > > I was quite surprised at the difference so I have to tell about > here. Found it while "wildly" testing a stage (oct to hex using > VCHAR) using the LITERAL/SPLIT sequence (literal with several > words) to simulate some lines of an input file. When I considered > how to deal with blank lines and empty records it took a little > while to grasp that I was not too well informed about SPLIT. > > Ciao....Mike > -- > www.Ok.de - die kostenlose E-Mail Adresse >
