Six Stars

Passing row separator as context value

Hi All,

 

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

 

3 REPLIES
Fifteen Stars

Re: Passing row separator as context value

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.

Rilhia Solutions
Highlighted
Six Stars

Re: Passing row separator as context value

 

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

 

Capture1.PNGCapture2.PNG

Fifteen Stars

Re: Passing row separator as context value

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. 

Rilhia Solutions