Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Newbie question about syntax documentation

I've looked around and found the documentation for components but what about the syntax
for the talend functions in the expression builder? I can't find anything that lists the functions and their
syntax to know what goes in each parameter. The help box describes it but doesn't actually show the syntax.
If I understand correctly it's basically java if you choose that as your project language right?
Labels (3)
23 Replies
Anonymous
Not applicable
Author

Hello,
You can obtain a syntax example with a double click on the function in the expression builder.
Regards,
Anonymous
Not applicable
Author

TalendString.talendTrim("",' ',0)
Here's what I get when I double click this function. Problem is how do I know what goes in the "", ' ', and what does 0 mean?
Some samples are more descriptive than others but I'm trying to find out if there's a reference for these in case some are overloaded
methods that I can take advantage of. Something like javadoc.
Anonymous
Not applicable
Author

I have a field: '0001114444 Intralata'
I'm trying to trim the first part before the space into an output column for the phone number
and trim the last part after the space into an output column for the rate. talendTrim seems to fit this
description but I can't figure out how to use it.
Anonymous
Not applicable
Author

Hello friend
try
String.substring(0,row1.columnName.indexOf(" "))     //for phone number

String.substring(row1.columnName.indexOf(" ")+1)     //for rate

Best regards

shong
Anonymous
Not applicable
Author

Thanks shong. I'll give that a shot.
But I guess my question still stands. Are those just java methods being called? Also, since there are talend methods in the expression builder where's the documentation of their syntax and variables?
Anonymous
Not applicable
Author

It is just plain java: so you can use all the doc references available to java.
Anonymous
Not applicable
Author

even for the talend methods and classes?
Anonymous
Not applicable
Author

Cannot make a static reference to the non-static method substring(int, int) from the type String
I get this error Shong when I put that in the expression builder.
Anonymous
Not applicable
Author

Hello
Cannot make a static reference to the non-static method substring(int, int) from the type String

What's your expression? It is just a java method beging called here...eg:
row1.name.substring(0,3) //name is a string
Best regards

shong