Bruce Ng's software development blog
An archive of solutions of programming problems I have faced in my career
Example:
Tags:banana,authenticated Site:”http://server/Pages/AFolder”
Using REST
http://server/_api/search/query?queryText=’Tags:banana,authenticated Site:”http://server/Pages/AFolder”‘
FQL can also be used, but some configuration is needed:
https://msdn.microsoft.com/en-us/library/office/jj163973.aspx
Query for managed metadata http://www.techmikael.com/2014/03/s15e01-kql-basics.html
A useful search tool: https://sp2013searchtool.codeplex.com/
And this article: https://sharepointgotchas.wordpress.com/2014/11/18/using-rest-to-query-data-by-filtering-on-taxonomy-field/
The filtering works using CAML query.
If the application only uses English language, it’s possible to strip all control characters from the data before doing other string operations.
Use the Regex to do so
data = Regex.Replace(data, @”[^x20-x7F]”, “”);
This line will remove all characters that are not in the range 0x20 to 0x7F in the ASCII table.
Then proceed to do string operations as per normal.
for (var property in object) {
if (object.hasOwnProperty(property)) {
// do stuff
}
}
Source: http://stackoverflow.com/questions/8312459/iterate-through-object-properties
The example processes values read by EPPlus, might be useful in other situations, too.
public DateTime GetDate(object valFromExcel)
{
if(valFromExcel is DateTime) return valFromExcel;
if(valFromExcel is double) return DateTime.FromOADate((double)valFromExcel);
return Convert.ToDateTime(valFromExcel);
}
//if the namespace has already been declared, use the existing one, otherwise create an empty object
//for the namespace
var theNamespace = theNamespace | {};
//assign functions and objects in the namespace by setting properties.
theNamespace.aFunction = function(){};
Using namespace will help avoid functions with same name being overridden by each other.