Thanks for the quick response. I try '\376', but still not working :(
On 1/10/13 6:23 AM, "Dean Wampler" <dean.wamp...@thinkbiganalytics.com> wrote: >You have to use the octal representation, e.g., ^A is \001. > >On Wed, Jan 9, 2013 at 8:32 PM, Ho Kenneth - kennho ><kenneth...@acxiom.com>wrote: > >> Hi all, >> >> I have an input file that has a unicode character as a delimiter, which >>is >> þ (thorn) >> >> For example: >> >> col1þcol2þcol3 >> >> Þ has a value of UTF-8(hex) 0xC3 0xBE (c3be) >> >> And I have tried the following but no luck: >> create table test(col1 string, col2 string, col3 string) row format >> delimited fields terminated by '\c3be'; >> >> I'd appreciate your help! Thanks in advance. >> >> --ken >> >> >> >> >>************************************************************************* >>** >> The information contained in this communication is confidential, is >> intended only for the use of the recipient named above, and may be >>legally >> privileged. >> >> If the reader of this message is not the intended recipient, you are >> hereby notified that any dissemination, distribution or copying of this >> communication is strictly prohibited. >> >> If you have received this communication in error, please resend this >> communication to the sender and delete the original message or any copy >> of it from your computer system. >> >> Thank You. >> >> >>************************************************************************* >>*** >> > > > >-- >*Dean Wampler, Ph.D.* >thinkbiganalytics.com >+1-312-339-1330