crmTech/ November 18, 2011/ Siebel/ 0 comments

Below code snippet is in Siebel eScript. This code will read the CSV file.

var oFile = Clib.fopen(path,"r");
           if( oFile == null )
           {  TheApplication().RaiseErrorText(path); }
           var string = (Clib.fgets(2000,oFile)); //usually the first line is hearder so ignore it
           while(!Clib.feof(oFile))
                {
                  string = (Clib.fgets(2000,oFile));
                  LVal = string.split(",");
                  //LVal is the now an array populated with data
                  //Now put your logic to do whatever you want to do with data
                  //for example
 if(LVal[0] == "Test")
                    {
                      //do something
                    }
                  cntr++; // just to count number of lines that have been processed
                }
          }
Advertisements
Share this Post

About crmTech

Sharad is working from more than 11 years in IT industry. He has giving his technical services in CRM for telecom, automobile, retail, finance industry in Sales, Service and Marketing. He has primary skill in Siebel and Salesforce Marketing Cloud. Apart from this he has worked in Google Cloud, Wordpress blogging, SEO optimization, Short film making, mobile apps creation,logo design creation for his own interest.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.