BALIW™ developer's notes

DECLARE  @BDay varchar(15),  @Code varchar(10),  @CusTomerNo varchar(10) DECLARE  @SMS varchar(500)  ,@OutBoundSMS varchar(500)  ,@WordCount int  ,@IsValidSMS bit --SET @SMS = 'FW 01928 12311995' -- valid --SET @SMS = 'FW 101928 12311995' -- valid --SET @SMS = 'QUERY 101928 12311995' -- Invalid --SET @SMS = 'FW 1x1928 12311995' -- Invalid --SET @SMS = 'FW 1x1928 12.31.1995' -- Invalid --SET @SMS = 'FW 1x1928 12.31.1995' -- Invalid SET @SMS = 'FW' -- Invalid --SET @SMS = 'FW 01928' -- Invalid --SET @SMS = 'FW A1928' -- Invalid SET @IsValidSMS = 0 SELECT  IDENTITY(int, 1, 1) AS Id,  splitdata INTO #temp1  FROM dbo.fnSplitString(@SMS,' ') SELECT @WordCount = COUNT(*) FROM #temp1 IF @WordCount = 3 BEGIN  --SELECT 'Valid 3 words format...'  SELECT TOP 1 @Code = splitdata FROM #temp1 WHERE Id = 1  SELECT TOP 1 @CusTomerNo = splitdata FROM #temp1 WHERE Id = 2    SELECT TOP 1 @BDay = splitdata FROM #temp1 W...

//Get Filename: BDO.BankRemittance.Custom.OtherPaymentXmlCreator createXml = new BankRemittance.Custom.OtherPaymentXmlCreator(); //Change Filename: pInMsg.Context.Promote("ReceivedFileName", " http://schemas.microsoft.com/BizTalk/2003/file-properties ", sBatchName + ".xlsx");

private static void POC_ReadExcelWorksheetsRowsAndColumns() {     string excelFile = @"C:\Raw Excel.xlsx";     using (ExcelPackage package = new ExcelPackage(new FileInfo(excelFile)))     {         foreach (ExcelWorksheet workSheet in package.Workbook.Worksheets)         {             // Make sure its not a blank sheet:             if (workSheet.Dimension == null) continue;             // Get dynamic row and column count:             int rowCount = workSheet.Dimension.End.Row;             int columnCount = workSheet.Dimension.End.Column;             Console.WriteLine("Worksheet name: {0}, with {1} rows and {2} columns", workSheet.Name, rowCount, columnCount);             Console.WriteLine("workSheet.Dimension.Rows: {0}", workSheet.Dimension.Rows);             Console.WriteLine("workSheet.Dimension.Columns: {0}", workSheet.Dimension.Columns);             Console.WriteLine(string.Format("Cell A1 value is {0}", workSheet.Cells["A1...

#forcing to utf-8 def string_sanitize(the_string) return the_string.encode("iso-8859-1").force_encoding("utf-8") end

links = page.css('ul.pagination').css('a').map { |link| link['href'] } 

> Problem: When issuing command; $ git push heroku maste error: src refspec maste does not match any. error: failed to push some refs to ' https://git.heroku.com/myapp-job.git ' > Resolution: $ git push heroku HEAD:master > Terminal: $ git push heroku maste error: src refspec maste does not match any. error: failed to push some refs to ' https://git.heroku.com/myapp-job.git ' $ git show-ref 830920a24c2c3edbccf9b132a976bf8c72463dc0 refs/heads/master $ git remote -v heroku    https://git.heroku.com/myapp-job.git (fetch) heroku    https://git.heroku.com/myapp-job.git (push) $ git push heroku HEAD:master Counting objects: 11, done. Delta compression using up to 2 threads. Compressing objects: 100% (11/11), done. Writing objects: 100% (11/11), 6.90 KiB | 0 bytes/s, done. Total 11 (delta 0), reused 0 (delta 0) remote: Compressing source files... done. remote: Building source: remote: remote: -----> Ruby app detected remote: -----> Compiling Ruby/Rack remote: ...

DECLARE  @Filename varchar(100)  ,@FilenameSmall varchar(100)  ,@BatchNameType varchar(50) SET @BatchNameType = SPACE(0) SET @Filename = '05 May 2017_FP.xlsx' SET @Filename = '05 May 2017_FW.xlsx' SET @Filename = '05 May 2017_HA.xlsx' SET @Filename = '05 May 2017_WHO.xlsx' SET @Filename = 'GENERICS-20170531_152713.xlsx' SET @FilenameSmall = LOWER(@Filename) SET @BatchNameType += CASE WHEN PATINDEX('%_fw.xlsx', @FilenameSmall) > 0 THEN 'FINALWAY-' ELSE SPACE(0) END SET @BatchNameType += CASE WHEN PATINDEX('%_fp.xlsx', @FilenameSmall) > 0 THEN 'FINALWAY-' ELSE SPACE(0) END SET @BatchNameType += CASE WHEN PATINDEX('%_ha.xlsx', @FilenameSmall) > 0 THEN 'HOMEALONE-' ELSE SPACE(0) END SET @BatchNameType += CASE WHEN PATINDEX('%_who.xlsx', @FilenameSmall) > 0 THEN 'WHO-' ELSE SPACE(0) END IF( LEN(@BatchNameType) > 0)  BEGIN   SELECT [@Filename] = @Filename, [@FilenameSmall] =...