Re: unicode character as delimiter

2013-01-10 Thread Ho Kenneth - kennho
I'd appreicate if someone can help out with this issue. Tons of thanks! :) I have tried many different combinations but still not able to get it to work. Q: how do we parse delimiter - "þ" On 1/10/13 8:08 AM, "Ho Kenneth - kennho" wrote: >Thanks for the quick response. > >I try '\376', but

Re: unicode character as delimiter

2013-01-10 Thread Ho Kenneth - kennho
Thanks for the quick response. I try '\376', but still not working :( On 1/10/13 6:23 AM, "Dean Wampler" 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 >wrote: > >> Hi all, >> >> I have an input file that has a unico

Re: unicode character as delimiter

2013-01-10 Thread Dean Wampler
You have to use the octal representation, e.g., ^A is \001. On Wed, Jan 9, 2013 at 8:32 PM, Ho Kenneth - kennho 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 0