topic Re: Converting strings into proper / title case using Java in Talend Studio

Converting strings into proper / title case using Java

Anonymous — Sat, 16 Nov 2024 13:05:50 GMT

Hi, how would you go about converting a string which is all upper case into capital first letter only for the whole sentence (proper/title case)? There does not seem to be a Talend string function for this and neither built-in to the basic Java libraries.

Re: Converting strings into proper / title case using Java

Anonymous — Thu, 10 Feb 2011 11:54:47 GMT

Hi,
One of the libraries that comes with Talend has a capitalize() function. It's called Commons Lang and capitalize() is in a class called StringUtils.
To use this, use a tLoadLibrary component. Configure it to use the commons-lang-2.5.jar and import the class 'org.apache.commons.lang.StringUtils'. In your tMap, use something like
row2.first_name = StringUtils.capitalize(row1.first_name)
If you want a quick test, cut-and-paste this in a tJava.
System.out.println( StringUtils.capitalize(null) );
System.out.println( StringUtils.capitalize("") );
System.out.println( StringUtils.capitalize("cat") );
System.out.println( StringUtils.capitalize("cAt") );
-Carl

Re: Converting strings into proper / title case using Java

Anonymous — Thu, 10 Feb 2011 14:23:41 GMT

Brilliant, thank you. That will solve the problem I am sure. I was not aware that there was such a vast amount of libraries shipped with Talend.
I don't suppose you know where to find a typical string splitting method now that I am thinking of it? We want to grab only the last part of a string, the text after the last comma.

Re: Converting strings into proper / title case using Java

Anonymous — Thu, 10 Feb 2011 14:42:19 GMT

You can use java Strring.split method
ex
String spt= "Java.How.To.Split";
spt.split(".")

Re: Converting strings into proper / title case using Java

Anonymous — Thu, 10 Feb 2011 14:56:02 GMT

If the standard split() does't work for you, try (from the same Commons Lang / StringUtils class) substringAfterLast().
Here's a link to the Javadoc. These string functions are useful. http://commons.apache.org/lang/api-release/index.html.
If you want to extend these functions or make some documentation available with them, take a look at this blog post on the topic.
http://bekwam.blogspot.com/2011/02/user-defined-functions-with-talend-open.html

Re: Converting strings into proper / title case using Java

Anonymous — Thu, 10 Feb 2011 14:57:24 GMT

I have now tried the tJava example above and it doesn't actually do anything with the strings - this is the output:

null
Cat
CAt

Where exactly am I supposed to write the import line? I have written it under Advanced Settings in the tJava component now like this:
import org.apache.commons.lang.StringUtils;

Re: Converting strings into proper / title case using Java

Anonymous — Thu, 10 Feb 2011 14:58:27 GMT

Also, thank you both for the info on the Split function, it turns out to be rather easy doesn't it. Would you recommend using Java code or the tExtractDelimtedFields component?

Re: Converting strings into proper / title case using Java

Anonymous — Thu, 10 Feb 2011 15:02:55 GMT

I think you should try both and use the one which is faster

Re: Converting strings into proper / title case using Java

Anonymous — Thu, 10 Feb 2011 17:39:44 GMT

Yeah, fair enough, thanks.

I would like to repeat my previous question as well:

I have now tried the tJava example above and it doesn't actually do anything with the strings. Where exactly am I supposed to write the import line? I have written it under Advanced Settings in the tJava component now like this:
import org.apache.commons.lang.StringUtils;

Re: Converting strings into proper / title case using Java

Anonymous — Thu, 10 Feb 2011 21:38:43 GMT

hi all
use toUppercase() method to capitalise characters.
the opposite => toLowerCase()
Talend Method : DOWNCASE and UPCASE
regards
laurent

Re: Converting strings into proper / title case using Java

Anonymous — Fri, 11 Feb 2011 11:29:05 GMT

I should have been more clear - it is not uppercase I want, I want only the first letter of each word to be capital:
Just Like This Example

Re: Converting strings into proper / title case using Java

Anonymous — Fri, 11 Feb 2011 11:54:32 GMT

In this case You can use String buffer

it is not uppercase I want, I want only the first letter of each word to be capital

ex
String a="alpha";
StringBuffer abc=new StringBuffer(a);
String temp = Character.toString(abc.charAt(0));
temp=temp.toUpperCase();
abc.setCharAt(0,temp.charAt(0));
System.out.println(abc);
This case will only work if you know the index number of which Char to change

Re: Converting strings into proper / title case using Java

willm1 — Thu, 12 May 2011 18:49:37 GMT

The following code in a tjava / tjavarow component will do it... Just replace the string literal with your input field name
String sentence = "";
String curWord = "";
String curWordUpper = "";
String str = "my first talend etl job";
String[] temp;
/* delimiter */
String delimiter = " ";
/* given string will be split by the argument delimiter provided. */
temp = str.split(delimiter);
/* print substrings */
for(int i =0; i < temp.length ; i++)
{
curWord = temp;
curWordUpper = "";

for (int j = 0; j < curWord.length(); j++)
{
String next = curWord.substring(j, j + 1);
if (j == 0)
{
curWordUpper += next.toUpperCase();
}
else
{
curWordUpper += next.toLowerCase();
}
}
sentence += curWordUpper + " ";
//System.out.println(curWord2);
}
System.out.println(sentence.trim());

Re: Converting strings into proper / title case using Java

Anonymous — Thu, 12 May 2011 19:30:10 GMT

There's a WordUtils.capitalize() function in Commons Lang if you want to modify each word in a sentence.
WordUtils.captialize(row1.mytext);
import org.apache.commons.lang.WordUtils;

Re: Converting strings into proper / title case using Java

Anonymous — Sun, 26 Aug 2012 17:32:57 GMT

I have added the commons Lang by adding to the JRE files and also tried using the Library Loader but my TMap keeps throwing up and error that it doesn't recognise either WordUtils or StringUtils. I want to use the function capitalizeFully to set the first letters of each word in an address string to upper case.
Would someone be kind enough to explain how exactly I can get the function for the commons Lang to work.

Re: Converting strings into proper / title case using Java

Anonymous — Sun, 26 Aug 2012 18:05:12 GMT

Hi,
Double-check the import statement which is needed in addition to telling Talend where the library is (jar file). If that's ok, post the specific error message.
This post has an example that may help you: http://bekwam.blogspot.com/2011/01/java-libraries-in-talend-open-studio.html.

Re: Converting strings into proper / title case using Java

Anonymous — Mon, 27 Aug 2012 09:50:58 GMT

Hi there. Thanks for the prompt reply. I have attached images of the set up and errors. I have tried both ways; to add the Land file under the JRE setting sand with the Loader as you suggested. First images via the Preferences route and the then by Library Loader.
Trying to achieve Word.Utils.capitalizeFully(row1.Address_1) - pic1
Pic2 - added the commons Land to JRE
Pic3 - run error.
Pic4 - now with Library Load basic settings
Pic5 - Advanced settings JAR location and Import string
pic6 - new run error.
I hope this is clear.
Thanks.

Re: Converting strings into proper / title case using Java

Anonymous — Thu, 30 Aug 2012 00:52:40 GMT

Hi,
To fix your problem,
1. Switch to commons-lang-2.6.jar in the tLoadLibrary / Basic settings / Library select box
2. Remove everything from Advanced settings / Dynamic libs
3. Add the following path to Advanced settings / import: import org.apache.commons.lang.WordUtils;
4. Use the function in a component like tJavaRow like
output_row.field1 = WordUtils.capitalizeFully(input_row.field1);
I'm having a problem with Commons Lang 3 which may have been installed in your workspace when you installed my tScriptRules component. Apparently, it's in the folder structure and available in the modules list, but TOS isn't recognizing the commons-lang3-3.0.jar as something available on the classpath. It's fine to use Commons Lang 2.6 for what you want. Follow along here: http://www.talendforge.org/forum/viewtopic.php?pid=93369#p93369.

Re: Converting strings into proper / title case using Java

Anonymous — Thu, 30 Aug 2012 15:35:00 GMT

Carl, you are a scholar and a gentleman?.. All peachy.
Much appreciated.

Re: Converting strings into proper / title case using Java

Anonymous — Fri, 31 Aug 2012 08:20:30 GMT

Hi,
Probably you can use following expression in your tMap
Expression:
----------------
row1.TitleString.toLowerCase().replaceFirst("", row1.TitleString.substring(0,1).toUpperCase())
Note:- "TitleString" is the column name.
--
Regards,
Vinod