Can it be done using PIG Latin Script?
Regards
Kiran
-----Original Message-----
From: Gheorghe Muresan
Sent: Tuesday, October 18, 2011 10:47 AM
To: [email protected]
Subject: Re: Optionally Enclosed By in PIG
If some columns may contain the separator, you can escape their
content before writing them into the table, and unescape them after
you split the row, before you use the content.
You can use URL escape characters (e.g.
http://www.werockyourweb.com/url-escape-characters) or something more
reader-friendly (e.g. "|" -> "<pipe>").
Cheers,
Gheorghe
On Mon, Oct 17, 2011 at 9:37 PM, kiranprasad
<[email protected]> wrote:
Hi
How can I ignore the seperator character in middle of a column value.
eg : Seperator char is ‘|’.
The Record values are | seperated
xyz|1234|98798|”xyz|abc”|
Regards
Kiran.G