TalendString routine
The TalendString routine contains several functions which allow you to carry out various operations on alphanumerical expressions.
You can access these functions by double-clicking the TalendString node under the system routines folder in the Repository tree view.
|
Function |
Description |
Syntax |
|---|---|---|
| AddEscapeChars | Adds a specified character before each special character (that is, a character that is not a letter, a digit, _, or space) in a string. | TalendString.addEscapeChars("padding chars",'escape char') |
|
replaceSpecialCharForXML |
returns a string from which the special characters (eg.:: <, >, &...) have been replaced by equivalent XML characters. |
TalendString.replaceSpecialCharForXML("string containing the special characters - eg.: Thelma & Louise") |
|
checkCDATAForXML |
identifies characters starting with <![CDATA[ and ending with ]]> as pertaining to XML and returns them without modification. Transforms the strings not identified as XML in a form which is compatible with XML and returns them. |
TalendString.checkCDATAForXML("string to be parsed") |
|
talendTrim |
parses the entry string and removes the filler characters from the start and end of the string according to the alignment value specified: -1 for the filler characters at the end of the string, 1 for those at the start of the string and 0 for both. Returns the trimmed string. |
TalendString.talendTrim("string to be parsed", "filler character to be removed", character position) |
|
removeAccents |
removes accents from a string and returns the string without the accents. |
TalendString.removeAccents("String") |
|
getAsciiRandomString |
generates a random string with a specific number of characters. |
TalendString.getAsciiRandomString(whole number indicating the length of the string) |
| unionString | Combines the variable number of strings with a specified string separator. | TalendString.unionString(String separator,Object... objects) |
Formatting an XML string
It is easy to run the replaceSpecialCharForXML routine along with a tJava component, to format a string for XML:
System.out.println(TalendString.replaceSpecialCharForXML("Thelma & Louise"));In this example, the & character is replaced in order to make the string XML compatible:
Trimming a string
It is easy to use the talendTrim routine, along with a tJava component to remove the string padding characters from the start and end of the string:
System.out.println(TalendString.talendTrim("**talend open Studio****",'*', -1));
System.out.println(TalendString.talendTrim("**talend open Studio****",'*', 1));
System.out.println(TalendString.talendTrim("**talend open Studio****",'*',0));The star characters are removed from the start, then the end of the string and then finally from both ends:
Removing accents from a string
It is easy to use the removeAccents routine, along with a tJava component, to replace the accented characters, for example:
System.out.println(TalendString.removeAccents("sâcrebleü!"));The accented characters are replaced with non-accented characters:
