A for loop within a for loop in MS-DOShttps://joellipman.com/articles/automation/ms-dos/a-for-loop-within-a-for-loop-in-ms-dos.html

03 October 2013 IN ('DIR InitializingFile*') DO ECHO %%A -- yields: 123.csv 456.csv So that's our first loop, here's what the second loop should do: -- the following loops through a line and separates by period (.) FOR /F "tokens=1,2* delims=." %%I IN ('DIR...

• Type: Article
• Author: Joel Lipman
• Category: MS-DOS
• Language: en-GB

MS Excel: Convert a text to a numberhttps://joellipman.com/articles/microsoft/excel/ms-excel-convert-a-text-to-a-number.html

15 November 2013 symbol. Microsoft could argue this is a problem with your data but the way I see it is it's a space character and TRIM() should work. My solution Include the space (if there is one) in the substitute formula: =SUBSTITUTE(B3, " ₱", "") The resulting...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

SSRS Display question mark when date is blankhttps://joellipman.com/articles/microsoft/ssrs/ssrs-display-question-mark-when-date-is-blank.html

15 April 2014 Sounds good, where's the problem? The problem Putting the date in an IIF (if-then-else) statement displays "#Error". You should get errors referring to converting strings to dates and incorrect data types. How? The fix is to simply get the field and...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

SSIS: Add Reference Microsoft.SqlServer.TxScripthttps://joellipman.com/articles/microsoft/ssis/ssis-add-reference-microsoft-sqlserver-txscript.html

03 June 2014 This is simply the "Script Component" under "Extensions". No MSDN website said this... obvious to Microsoft staff so why should their documentation include it? Workaround (applies for any dll) You right-click on the "references" folder, Select "Add...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

SITS: XET format for Export not availablehttps://joellipman.com/articles/web-development/xml/sits-xet-format-for-export-not-available.html

08 August 2014 Now you can go and retrieve a student/staff (depending on what data your XET feeds off) Bring up STU File > Export... You should have something similar to the following:

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Android Background Image Resolutionshttps://joellipman.com/articles/google/androidos/android-background-image-resolutions.html

01 December 2014 A reference to what size an image background should be set to for various screen sizes. Why? A background image I was using was unedited at 1600x2133 (364kb) and was not displaying on smaller devices. Configuring drawables for each layout seemed to be...

• Type: Article
• Author: Joel Lipman
• Category: AndroidOS
• Language: *

Make bootstrap carousel responsive to swipehttps://joellipman.com/articles/web-development/bootstrap/make-bootstrap-carousel-responsive-to-swipe.html

14 December 2016 the jQueryMobile library but that started messing up the template layouts for me. I really like the solution (and think it should be voted best answer) put forward by Mark Shiraldi: The code is minimal but does what it needs to do (tested on iOS) and...

• Type: Article
• Author: Joel Lipman
• Category: Bootstrap
• Language: *

Zoho Deluge - MD5 functionhttps://joellipman.com/articles/crm/zoho/zoho-deluge-md5-function.html

19 November 2018 Execution Failed Due to invalid expressions insert statement is terminated Line:(102) Value of the field Etag length should be lesser than or equal to MaxLength 255. Line:(132) It's not in the documentation but wouldn't it be nice if you could just...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

MS Excel - Open CSV with Long Numbershttps://joellipman.com/articles/microsoft/excel/ms-excel-open-csv-with-long-numbers.html

23 July 2019 with each column: 1. Specify that the data is delimited 2. Specify the data is delimited by commas 3. Specify which columns should be imported as text (the long numbers and phone numbers)

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

Zoho Projects: Deluge to Submit Custom Fieldshttps://joellipman.com/articles/crm/zoho/zoho-projects-deluge-to-submit-custom-fields.html

17 June 2021 name field). Note that in the below snippet, I've put m_Params into separate lines for display purposes but actually it should be all on one line: m_Custom = {"UDF_CHAR8":12345678901234567,"UDF_CHAR7":"Joel Lipman"}; m_Params = { "name": "My Happy...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *