Category Archives: Compus

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

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

MS Access: Left Function

Syntax The syntax for the Left function in MS Access is: Left ( text, number_of_characters ) Parameters or Arguments text The string that you wish to extract from. number_of_characters Indicates the number of characters that you wish to extract starting … Continue reading

Posted in Compus | Tagged , , ,

How to convert date to number or text in Excel?

Select a cell next to your date data, and type this formula =TEXT(A1,”dd/mm/yyyy”) into it, then press Enter key. If you need, you can drag the fill handle to apply this formula in a range. Source: How to convert date … Continue reading

Posted in Compus | Tagged , ,

How to find “?” (question mark) ? | PC Review

like “*[?]*” Source: How to find “?” (question mark) ? | PC Review

Posted in Compus | Tagged

Bekwam Blog: Protecting Yourself in Talend Open Studio

The tMsgBox uses the Run If trigger to invoke the delete operations if the user selects “Yes”. To use the Run If, Right-click on the tMsgBox Select Trigger > Run If Connect to the following subjob. Select the If connector … Continue reading

Posted in Compus | Tagged , , , ,