Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Content Management (Extended ECM)
API, SDK, REST and Web Services
Reading Unicode CSV Files
Mahesh_Pinnamaneni
Guys,Do any one have idea how to read the unicode characters using OScript.Attached the Unicode CSV file.I am using Livelink 9.5SP1 with UTF-8 Database.Thanks & Regards,Mahesh P
Find more posts tagged with
Comments
eLink User
Message from Nair, Krishnankutty N. via eLinkDid not quite understand the difference of UTF and ASCII .Here's asnippet where I just use to read a CSV file***************Snippet****************for ( inputLine = File.Read( .fInputFile ); \ inputLine != File.E_eof; \ inputLine = File.Read( .fInputFile ) ) inputList = Str.Elements( inputLine, "," ) //(lookingfor the comma) if inputList[1] == 'Site' else if(inputLine <> '') .AddNewSites(inputList) end end end ***************Snippet ends**************** -----Original Message-----From: eLink Discussion: Development Discussion[mailto:development@elinkkc.opentext.com] Sent: Friday, July 14, 2006 7:42 AMTo: eLink RecipientSubject: Reading Unicode CSV FilesReading Unicode CSV FilesPosted by Pinnamaneni, Mahesh on 07/14/2006 08:41 AMGuys,Do any one have idea how to read the unicode characters using OScript.Attached the Unicode CSV file.I am using Livelink 9.5SP1 with UTF-8 Database.Thanks & Regards,Mahesh P[To reply to this thread, use your normal E-mail reply function.]============================================================Attachment link: Unicode.csv
https://knowledge.opentext.com/knowledge/llisapi.dll/open/6970176============================================================Discussion
: Development Discussion
https://knowledge.opentext.com/knowledge/llisapi.dll/open/786303Livelink
Server:
https://knowledge.opentext.com/knowledge/llisapi.dllTo
Unsubscribe from this Discussion, send an e-mail tounsubscribe.development@elinkkc.opentext.com.
Mahesh_Pinnamaneni
Message from Pinnamaneni, Mahesh via eLinkBuddy,You can try with the file I have sent.The inputLine variable value will have some garbage value after theexecution of line :: for ( inputLine = File.Read( .fInputFile ); \Thanks & Regards,Mahesh P-----Original Message-----From: eLink Discussion: Development Discussion[mailto:development@elinkkc.opentext.com] Sent: 14 July 2006 13:54To: eLink RecipientSubject: RE Reading Unicode CSV FilesRE Reading Unicode CSV FilesPosted by eLink on 07/14/2006 08:53 AMMessage from Nair, Krishnankutty N. via eLinkDid not quite understand the difference of UTF and ASCII .Here's asnippet where I just use to read a CSV file***************Snippet****************for ( inputLine = File.Read( .fInputFile ); \ inputLine != File.E_eof; \ inputLine = File.Read( .fInputFile ) ) inputList = Str.Elements( inputLine, "," ) //(lookingfor the comma) if inputList[1] == 'Site' else if(inputLine <> '') .AddNewSites(inputList) end end end ***************Snippet ends**************** -----Original Message-----From: eLink Discussion: Development Discussion[mailto:development@elinkkc.opentext.com] Sent: Friday, July 14, 2006 7:42 AMTo: eLink RecipientSubject: Reading Unicode CSV FilesReading Unicode CSV FilesPosted by Pinnamaneni, Mahesh on 07/14/2006 08:41 AMGuys,Do any one have idea how to read the unicode characters using OScript.Attached the Unicode CSV file.I am using Livelink 9.5SP1 with UTF-8 Database.Thanks & Regards,Mahesh P[To reply to this thread, use your normal E-mail reply function.]============================================================Attachment link: Unicode.csv
https://knowledge.opentext.com/knowledge/llisapi.dll/open/6970176============================================================Discussion
: Development Discussion
https://knowledge.opentext.com/knowledge/llisapi.dll/open/786303Livelink
Server:
https://knowledge.opentext.com/knowledge/llisapi.dllTo
Unsubscribe from this Discussion, send an e-mail tounsubscribe.development@elinkkc.opentext.com.[To reply to this thread, use your normal E-mail reply function.]============================================================Topic: Reading Unicode CSV Files
https://knowledge.opentext.com/knowledge/llisapi.dll/open/6970175Discussion
: Development Discussion
https://knowledge.opentext.com/knowledge/llisapi.dll/open/786303Livelink
Server:
https://knowledge.opentext.com/knowledge/llisapi.dllTo
Unsubscribe from this Discussion, send an e-mail tounsubscribe.development@elinkkc.opentext.com.
Donna Nalls
Hello,I am always a little confused with the charSet stuff - not having to deal with it very often...but, i found this little snippet in something i did last year that resolved a character issue for me....i'll pass it along in hopes that it will help you.If DBCharSet == 'ISO' // resolve issue with ll utf-8 installation. // dnalls 11/29/2005 if ( System.CharEncoding() == System.UTF8 ) DBCharSetting = '¢¢' else DBCharSetting = '??' end elseif DBCharSet == 'ASCII' DBCharSetting = '~~'elseif DBCharSet == 'UNIX' DBCharSetting = '##'else // issue with ll utf-8 installation. // dnalls 11/29/2005 if ( System.CharEncoding() == System.UTF8 ) DBCharSetting = '¢¢' else DBCharSetting = '??' end end// then set a global for the dbcharset
