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 kenneth...@acxiom.comwrote: 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

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 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.comwrote: Hi

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 kenneth...@acxiom.com wrote: Thanks for the quick response. I