Solved: [resolved] Tmap and substring function - Qlik Community

Anonymous · ‎2011-08-01

Hi all,
I have tmap. The input is coming in one string as follows:
<html><head><title>bbasasas</title><body>dasdad</body></html>
What I am interested in is to get everything between <body> </body> tags
so I am trying to do the following expression:

input.htmlstring.substring(input.htmlstring.indexOf("<body>"), input.htmlstring.indexOf("</body>"))

Now, for some reason I get the follow error:

java.lang.StringIndexOutOfBoundsException: String index out of range: -1

Any idea where I am going wrong? Thanks.

Anonymous · ‎2011-08-01

it was some problem with my installation. once I restarted it, all worked fine 🙂
Thanks for your help

View solution in original post

Anonymous · ‎2011-08-01

Hi,
I don't know what you did wrong, but I tried it in my talend version.
Maybe I did it difficult because i couldn't find a substring function in my talend version, but I got it working.
So I made 2 variables in my tMap component: htmlRight and htmlLeft.
htmlright contains:
StringHandling.RIGHT(Input.htmlstring,(StringHandling.LEN(Input.htmlstring) - StringHandling.INDEX(Input.htmlstring ,"<body>")-6))
htmlleft contains:
StringHandling.LEFT(Var.htmlright,(StringHandling.LEN("Var.htmlright") - StringHandling.INDEX(Var.htmlright ,"</body>")-1))
The variable htmlleft then contains what is between the body tags.
Regards,
Mario De Pauw

Anonymous · ‎2011-08-01

it was some problem with my installation. once I restarted it, all worked fine 🙂
Thanks for your help

Anonymous · ‎2011-08-01

I'm glad it's working

[resolved] Tmap and substring function

Java

Other

REST

Talend Data Integration