topic Re: Extract data separated by Equal to (=) in Talend Studio

Extract data separated by Equal to (=)

karandama2006 — Sat, 16 Nov 2024 01:16:02 GMT

Hello ,

While generating token from RESTAPI , I get below response

credentialsToken = "AWHBsYtEQ2OiIJV2tqdasdasOGH2aSD44zbgaHWztlVLe7plIFES4"

siteId = "07aqwe5422e135-4b6b2234-099be525871c"

siteContentUrl = "Talend"

userId = "32aa851d-fb20-49b3-8eed-7f83c406f85a"

userName = "TALEND_TALEND"

This is not XML/JSON , looks like non-standard format, how can we extract token information using talend job ?

manodwhb — Tue, 20 Oct 2020 12:39:15 GMT

@karan dama , if you have : instead of = then replace = with : by reading all json file.

Thanks,

Manohar

jilanisyed — Tue, 20 Oct 2020 13:57:10 GMT

Hi ,

Try with tExtractDelimited component

Thanks

Jilani Syed

vikramk — Tue, 20 Oct 2020 14:53:52 GMT

I think you could store the required information in global variable using java components, then you can pass it to next component.

Please let me know if it helps

karandama2006 — Wed, 21 Oct 2020 08:31:46 GMT

Okay , so I tried to convert it to JSON file, but there were more obstacles than just simply replacing = with :

I did proceed with making it JSON , not very efficient , but I used below code in tjavarow and then extracted the fields using tjsonextract

context.response = input_row.ResponseContent;

context.response = context.response.replaceAll("=",":");

context.response = context.response.replaceAll("# REST API session created by Tableau Assist","");

context.response = context.response.replaceAll("serverURL","\"serverURL\"");

context.response = context.response.replaceAll("credentialsToken","\"credentialsToken\"");

context.response = context.response.replaceAll("siteId","\"siteId\"");

context.response = context.response.replaceAll("siteContentUrl","\"siteContentUrl\"");

context.response = context.response.replaceAll("userId","\"userId\"");

context.response = context.response.replaceAll("userName","\"userName\"");

context.response = context.response.replaceAll("\"\n","\",");

context.response = "{ " + context.response + " }";