Skip to main content

Posts

Check if value is undefined/null/NaN in JavaScript

In most JavaScript cases, evaluating variable is undefined, null, or NaN is very common. Their definition are shown below: - undefined : a declared variable which is not assigned value. - null : object value which means "no value". - NaN : "Not-a-Number" value Example for checking "undefined" var a = 1; var b; console.log(a===undefined); //false console.log(b===undefined); //true //console.log(c===undefined); //Error occurs due to "c" is not declared yet. console.log(typeof c === undefined); //false ("typeof" will return string value) console.log(typeof c === 'undefined'); //true Example for checking "null" var a = null; var b; console.log(a===null); //true console.log(b===null); //false console.log(typeof a); //object Example for checking "NaN" var a = NaN; var b; var c = 10; var d = '10'; var e = 'string10'; var f = '10string'; var g = parseInt('10'); v...
Post a Comment
Read more

Automatically adjust vertical page breaks in EXCEL

Merge cells is a very useful function in EXCEL, but sometimes, we would find merged area is split while we want to print. Obviously, it is necessary to adjust print area and is very simple. But, what if there are many pages? It will be a tiring work! Let do something with VBA. Below code shows how to automatically adjust vertical page breaks. Dim longBreaks As Long longBreaks = Me.HPageBreaks.Count 'Get total breaks 'Reset all breaks location Call Me.ResetAllPageBreaks Dim i As Long Dim objBreakCell As Range For i = 1 To longBreaks Set objBreakCell = Me.HPageBreaks.Item(i).Location If objBreakCell.MergeCells Then 'If the break is in merged area, set the first cell of area to new page break Call Me.HPageBreaks.Add(objBreakCell.MergeArea.Cells(1)) End If Next
Post a Comment
Read more

Strip backslashes in PHP

Returned things from webpage request may contain lots of backslashes due to JavaScript and JSON may need to escape some characters. That is inconvenient if we want to handle these results such as do regular expression in PHP; therefore, just use function "stripslashes" to strip all backslashes which are used for escaping characters. $stripped_string = stripslashes($input_string) References: PHP: stripslashes - Manual
Post a Comment
Read more

Find Item Where Used by AML in Aras Innovator

In Aras Innovator, we could execute command "Where Used" to check where the item is used like below picture. And for programming, AML provides an action "getItemWhereUsed" to do this. <AML> <Item type=" Item Type " id=" Item Id " action="getItemWhereUsed" /> </AML> Results will be contained in tag "relatedItems", just use XPath to retrieve.
Post a Comment
Read more