Read CSV File Business Service In Siebel

In Siebel vanilla there is an undocumented BS named Read CSV File.

This BS is very useful especially for testing. Using this BS you can read a file based on Integration Object  and you can use it for unit testting purposes. Also i can be an alternative to load data into Siebel. You can find detail information about this BS below,

http://blogs.oracle.com/siebelessentials/2008/10/encounter_with_the_read_csv_fi.html

Regular Expressions In Siebel with Non English Character Set support

You can find basic information about How Regular expressions can be used in Siebel in below links,

http://siebeldev.blogspot.com/2009/04/regular-expression-validation.html

http://download.oracle.com/docs/cd/B40099_02/books/eScript/eScript_JSReference252.html

For the Non English character set support, RexExp pattern should be writed with Unicode characters.

You can get information about Unicode below link,

http://www.unicode.org/

You can find a simple pattern about Turkish First Name  validation below,

“^[\u0041-\u005A]{1}\u002E?[\u0041-\u005A|\u0061-\u007A|\u0130|\u0131|\u00D6|\u00F6|\u00DC|\u00FC|\u00C7|\u00E7|\u011E|\u011F|\u015E|\u015F]*$”

Pattern explanation:

First character should be Upper Case(\u0041-\u005A]{1})

Second character could be “.” (\u002E?)

Other characters can be anything in Turkish Alphabet([\u0041-\u005A|\u0061-\u007A|\u0130|\u0131|\u00D6|\u00F6|\u00DC|\u00FC|\u00C7|\u00E7|\u011E|\u011F|\u015E|\u015F])