Author Archives: kynio

Excel Mac Error

Fix: Office 2016 Grant Access Error on MacOS

Posted in Compus, General

Remove Firt or last N character

1.1 Remove first N characters with RIGHT / REPLACE function >> Combine RIGHT and LEN function to remove first N characters Formula syntax and arguments Formula:    =RIGHT(string_cell,LEN(string_cell)-n_character) Reference: string_cell: the cell you use to remove characters n_character: the number of … Continue reading

Posted in Compus, General, Tech

Java Ignore Case

String Str1 = new String(“This is really not immutable!!”); String Str2 = Str1; String Str3 = new String(“This is really not immutable!!”); String Str4 = new String(“This IS REALLY NOT IMMUTABLE!!”); boolean retVal; retVal = Str1.equals( Str2 ); System.out.println(“Returned Value … Continue reading

Posted in Compus | Tagged

Java Integrer to String Examples

  Convert using Integer.toString(int) The Integer class has a static method that returns a String object representing the specified int parameter. Using this is an efficient solution. Syntax public static String toString(int i) The argument i is converted and returned … Continue reading

Posted in Compus, General | Tagged

String types

2.1  String Literal vs. String Object As mentioned, there are two ways to construct a string: implicit construction by assigning a string literal or explicitly creating a String object via the new operator and constructor. For example, String s1 = “Hello”; … Continue reading

Posted in Compus | Tagged

Java convert String to Int

In Java, you can use Integer.parseInt() to convert a String to int. 1. Integer.parseInt() Examples Example to convert a String “10” to an primitive int. String number = “10”; int result = Integer.parseInt(number); System.out.println(result); Output 10 2. Integer.valueOf() Examples Alternatively, … Continue reading

Posted in Compus, General | Tagged

Talend Merge Files into one

http://www.deepinopensource.com/talend-merge-multiple-files-into-single-file/

Posted in Compus | Tagged

How to remove first, last or certain characters from text in Excel?

Remove the first four characters from the text string.Step 1. Type the following formula in adjacent cell B1: =RIGHT(A1, LEN(A1)-4), Source: How to remove first, last or certain characters from text in Excel?

Posted in Compus | Tagged

Ejemplo de data quality con Talend

TFuzzyMatch :D Ejemplo de data quality con Talend Source: Ejemplo de data quality con Talend

Posted in Compus | Tagged , , ,

Remove non ascii characters from String in Java example – Java Code Examples

This example shows how to remove non ascii characters from String in Java. Example also shows how to remove non ascii characters from String using regular expression. How to replace non ascii characters with ASCII equivalent character? All above approaches … Continue reading

Posted in Compus | Tagged , , ,