

Re: Parse data with multiple delimiters and transpose rows and columnsVitalii Tymchyshyn 20130302, 08:38
You can try reading as single column, then splitting with reg exp and then
flattening. 2 бер. 2013 00:29, "Mix Nin" <[EMAIL PROTECTED]> напис. >  Forwarded message  > From: Mix Nin <[EMAIL PROTECTED]> > Date: Fri, Mar 1, 2013 at 2:26 PM > Subject: > To: [EMAIL PROTECTED] > > > *Hi * > * > * > *I have a file that has data as follows * > * > > **AA*:11,22,33;*BB*:144,244,344;*CC*:yny;*DD*:11,33;*EE*:144,344 ; 11111 > > I need output as follows > > Event key > > AA > > BB > > CC > > 11111 > > 11 > > 144 > > y > > 11111 > > 22 > > 244 > > n > > 11111 > > 33 > > 344 > > y > > > How could we write a PIG script for this. > > > Thanks > 
