topic Re: [resolved] Tmap and substring function in Talend Studio

[resolved] Tmap and substring function

Anonymous — Sat, 16 Nov 2024 12:46:09 GMT

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.

Re: [resolved] Tmap and substring function

Anonymous — Mon, 01 Aug 2011 13:11:37 GMT

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

Re: [resolved] Tmap and substring function

Anonymous — Mon, 01 Aug 2011 13:51:28 GMT

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

Re: [resolved] Tmap and substring function

Anonymous — Mon, 01 Aug 2011 14:06:01 GMT

I'm glad it's working