Category Archives: General

General

Excel Mac Error

Fix: Office 2016 Grant Access Error on MacOS Advertisements

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 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

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

Create zip file from single file with ZipOutputStream | Examples Java Code Geeks – 2016

Source: Create zip file from single file with ZipOutputStream | Examples Java Code Geeks – 2016 package com.javacodegeeks.snippets.core; import java.io.File; import java.io.FileInputStream; import java.io.FileOutputStream; import java.io.IOException; import java.util.zip.ZipEntry; import java.util.zip.ZipOutputStream; public class CreateZipFileFromSingleFileWithZipOutputStream { public static void main(String[] args) { … Continue reading

Posted in General

Talend – compare 2 files and keep entries that are not common to both

Source: Talend – compare 2 files and keep entries that are not common to both

Posted in General

Conversion string float (tMap)

Convertir texto en float y al mismo tiempo reemplazar coma (,) (row1.Nb_Litres.replace(‘,’,’.’)) code non testé Source: Conversion string float (tMap)

Posted in General