topic Re: Escaping Character with a global variable in the middle in Talend Studio

Escaping Character with a global variable in the middle

RVeitch_84 — Fri, 15 Nov 2024 23:48:18 GMT

I need to pass this as a string in tJava and I need to escape the double qoutes with a variable in the middle .

String cursor2;

cursor2 = " \"cursor\" " + ":" + row5.cursor ;

context.Body="{\"location_ids\":[\"" + (String) globalMap.get("locations") +"\"], \"" + cursor2 + "\"}" ;

Here is the cuurent result, I'm missing the double quotes in front of the g and I have an extra infront of the word cursor?

body {"location_ids":["27NA2Q0DDW471"], " "cursor" :gc7IdfFn6y61gTgvVxFSTIw9xHVpRnr7oggL"}

I need my body to look like this.

body {"location_ids":["27NA2Q0DDW471"], "cursor" :"gc7IdfFn6y61gTgvVxFSTIw9xHVpRnr7oggL"}

Any help would be appreciated.

Bob

Anonymous — Sat, 28 Aug 2021 03:07:07 GMT

For debugging, print the value of row5.cursor on the console to check if it has the expected value.

cursor2 = " \"cursor\" " + ":" + row5.cursor;

System.out.println(row5.cursor);

System.out.println(cursor2);

Regards

Shong

RVeitch_84 — Sat, 28 Aug 2021 19:14:14 GMT

Thanks, I fixed it with

cursor2 = " \"cursor\" :" + "\"" + row5.cursor + "\"}" ;

context.Body="{\"location_ids\":[\"" + (String) globalMap.get("locations") + "\"]," + cursor2 ;