Utilities

Index :

• GetDayWeek from Date (Get the day or week from the date passed)
• GetDaysDiff (Calculating the difference between two dates)
• parseCellDataToString (Reading the excel cell value irrespective of cellType)

---------------------------------------------------------------------------------------------------------------------

Gets the Day or the Week from the given date

public static String getDayWeek(String sourceDate, String opType) {
SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy");
try {
if ("WEEK".equalsIgnoreCase(opType)) {
String week = new SimpleDateFormat("w").format(sdf
.parse(sourceDate));
return week;
} else if ("DAY".equalsIgnoreCase(opType)) {
String day = new SimpleDateFormat("dd-MMM").format(sdf
.parse(sourceDate));
return day;
} else
return "";
} catch (Exception e) {
return "";
}
}

Usage :

getDayWeek("10/10/2014","DAY")

----------------------------------------------------------------------------------------------------------

Gets the difference in days between two days

public static int getDaysDiff(java.util.Date startDate,
java.util.Date endDate) {
long dateDiff = startDate.getTime() - endDate.getTime();
return (int) (dateDiff / (1000 * 60 * 60 * 24));

}

----------------------------------------------------------------------------------------------------------

 public static String parseCellDataToString(Cell cell){
    String cellStr;
int cellType= cell.getCellType();
        if(cellType==Cell.CELL_TYPE_STRING){
            // Return as it is since it is already in string format unless its date type  
            cellStr = cell.getStringCellValue();
        }
        else if(cellType==Cell.CELL_TYPE_NUMERIC || cellType==Cell.CELL_TYPE_FORMULA){
            // Remove any fractional data by parsing to long and then parse to string and return
            cellStr = String.valueOf((long)(cell.getNumericCellValue()));
        }
        else if(cellType==Cell.CELL_TYPE_BOOLEAN){
            cellStr = String.valueOf(cell.getBooleanCellValue());
        }
        else if(cellType==Cell.CELL_TYPE_BLANK){
        cellStr = "";
        }
        else{
        cellStr = "";
        }
        cellStr = cellStr.trim();
        return cellStr;

    }

Links to online utilities for faster development and testing

This post is just to have all useful links at one place

XPath:
To Test XPath 1.0 :             
           http://www.online-toolz.com/tools/xpath-editor.php
To Test Xpath 2.0
           http://videlibri.sourceforge.net/cgi-bin/xidelcgi

Javascript:
Check for errors in java script
           http://www.javascriptlint.com/online_lint.php
Javascript beautifier (beautify javascript or html)
           http://jsbeautifier.org/
JSON Beautify 
           http://jsonformat.com/#jsondataurllabel
              http://jsonformatter.curiousconcept.com/

Stylesheet:
CSS Beautify
           http://www.codebeautifier.com/#skip
Convert inline css to external css
           http://www.cssout.com/
Working with Javascript styling attributes
           http://www.comptechdoc.org/independent/web/cgi/javamanual/javastyle.html

JDBC Connection:
Working with JDBC Connections :
           http://www.herongyang.com/JDBC/Oracle-JDBC-Driver-Connection-URL.html

Extends Class provides several online tools (mentioned below):

Playgrounds:

• RegEx Tester (https://extendsclass.com/regex-tester.html), which helps to test and debug regex.
• Xpath tester (https://extendsclass.com/xpath-tester.html).
• SQLite fiddle (https://extendsclass.com/sqlite-browser.html). It is open source (https://github.com/cyrilbois/Web-GUI-for-SQLite).
• javascript fiddle (https://extendsclass.com/javascript-fiddle.html). 

API tools:

• REST client (https://extendsclass.com/rest-client-online.html). 
• SOAP client (https://extendsclass.com/soap-client-online.html).
• Web service testing (https://extendsclass.com/web-service-tester.html). It is open source (https://github.com/cyrilbois/RestesterUI).
• Mock REST API (https://extendsclass.com/mock-rest-api.html).
• JSON Patch Generator (https://extendsclass.com/json-patch.html), which allows to generate the JSON patch from two JSON objects.
• JSON Storage service (https://extendsclass.com/json-storage.html), an HTTP API (GET, POST, PUT, PATCH and DELETE) is available to manipulate this data.

Random Data Generator:

• JSON Generator (https://extendsclass.com/json-generator.html), which allows to generate JSON files from a template.
• CSV Generator (https://extendsclass.com/csv-generator.html), which allows to generate CSV files.

Checkers:

• PHP code checker (https://extendsclass.com/php-tester.html).
• Python code checker (https://extendsclass.com/python-tester.html).

XML tools:

• XSD Validator and Generator (https://extendsclass.com/xml-schema-validator.html).
• XML formatter and validator (https://extendsclass.com/xml-formatter-online.html). It is open source (https://github.com/cyrilbois/Web-xml-formatter).
• XML to JSON (https://extendsclass.com/xml-to-json.html).
• XML diff (https://extendsclass.com/xml-diff.html)

JSON tools:

• JSON formatter and validator (https://extendsclass.com/json-validator.html), which allows to validate, minify, beautify, escape and share JSON.
• JSONPath Tester (https://extendsclass.com/jsonpath-tester.html). 
• JSON Schema Validator And Generator (https://extendsclass.com/json-schema-validator.html).
• JSON diff (https://extendsclass.com/json-diff.html)

Converters / Encoders:

• JSON to CSV (https://extendsclass.com/json-to-csv.html).
• CSV to Excel (https://extendsclass.com/csv-to-excel.html).
• Base64 image encoder / decoder (https://extendsclass.com/image-to-base64.html).
• Base64 encoder / decoder (https://extendsclass.com/base64-decode-encode.html).

Minifiers:

• CSS minifier (https://extendsclass.com/css-minifier.html).
• HTML minifier (https://extendsclass.com/html-minifier.html).
• javascript minifier (https://extendsclass.com/javascript-minifier.html).

Other:

• CSV diff (https://extendsclass.com/csv-diff.html)
• CSS Generator (https://extendsclass.com/css-generator.html).