Hi, I have a file that the sender is sending with the extension
".CSV", although it does not open cleanly in Notepad (no line wraps,
and that square character appears).  It opens fine in XLS, and I
believe it is actually a tab delimited file that is in Unicode format.

This is confirmed by iConv.com, which says we have a ?Little-endian
UTF-16 Unicode C++ program character data? file.  We are using PHP to
process the file, and want to be able to process it, but can't find
any info on parsing such a file.  Can you tell me how?

Thanks!

uc

---

Request for Question Clarification by passive-ga on 14 Jun 2004 14:25 PDT

Would a Python (www.python.com) solution be accepable to you?
It seems that PHP does not have very good UTF-16 facilities, at least
upon cursory inspection, and I am not familiar enough with Perl to put
together anything dependable.
Python, on the other hand, handles Unicode natively, and is quite
efficent for text processing.

Is it possible to save as a "real" .csv or tab .txt from inside Excel?
Do you think you'll lose specific data in a field?

Hello uc1bear,

can you put any part of that file online. SO that we can give a try

Thanks
Giridhar Nandigam