Category Archives: General

General

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

Understanding Floating numbers with pizza

Imagine that you are trying to slice up pizzas. You have a robotic pizza cutter that can cut pizza slices exactly in half. It can halve a whole pizza, or it can halve an existing slice, but in any case, … Continue reading

Posted in General

Using Dynamic Chart Titles (Microsoft Excel)

There is a very cool way, apparently not well known, of adding ‘active’ or ‘live’ titles and other text to charts. In this way you can make a change in a worksheet and have that change reflected in a title … Continue reading

Posted in General | Tagged ,

Create a Microsoft Access Macro to Import Information from a Text (.txt) File | Database Solutions for Microsoft Access | databasedev.co.uk

Creating the import macro in Microsoft Access The specification that we created in the previous section will be used in this section. Go to “Macros” then click “New” On the first line, click the drop-down box Go to “Transfer Text” … Continue reading

Posted in General