topic Re: Passing row separator as context value in Talend Studio

Passing row separator as context value

shivanand — Mon, 22 Jan 2018 10:08:37 GMT

Hi All,

I am unable to pass new line character (\n) as context value for field "Row Separator" to tFileInputDelimited component.

Re: Passing row separator as context value

Anonymous — Mon, 22 Jan 2018 10:21:17 GMT

Can you show us a screenshot of your job and let us know what happens when you run it? This could be caused by a couple of things. We need more info.

Re: Passing row separator as context value

shivanand — Mon, 22 Jan 2018 10:34:23 GMT

Below you can see I have declared Row Separator as context.IF_Row_seperator and in second snapshot passing that value as \n

Re: Passing row separator as context value

Anonymous — Mon, 22 Jan 2018 11:15:21 GMT

I actually meant to show your job layout as well, but this gives me a clue. I suspect that the file you are loading is having it's escape character (/) escaped to make it behave as a literal. Try this, at the beginning of your job (or after your context file has been loaded), add a tJava and set your context variable there like below...

context.IF_Field_Separator="\n";

Then run your job. If that works, my suspicions are correct. This will have been done for good reasons, so I am not sure it is a bug.

Re: Passing row separator as context value

Talend_ent — Mon, 25 May 2020 08:45:44 GMT

Could someone clear my error, when I'm passing the context variable to Header Field in tfileinputDelimited component it throwing following error..

Error_msg.PNG

Re: Passing row separator as context value

Anonymous — Mon, 25 May 2020 09:13:30 GMT

@Talend_enthu, it is a compilation error, just made a simple testing with v7.3.1 and it works, I set the Header field as context.varName.
BTW, please insert your images into post body instead of attaching them.

Regards
Shong

Re: Passing row separator as context value

Talend_ent — Mon, 25 May 2020 09:18:39 GMT