A short text to describe your forum
http://dsxchange.com./
Code: Select all
Trim(<value>,',','B')When I am trying to read that file in a separate job where I can trim that trailing comma, i am able to trim the last comma and getting the desired output but the job throws warning like Missing Record delimiter '''', saw EOF instead, and moreover I wanted to achieve this in a single job instead of 2 jobs.Sainath.Srinivasan wrote:Isn't that what you asked for ? Trim the trailing comma.
I am getting the comma separeted values when I am collecting the data in the file in the first job, hence I cannot trim the trailing comma there.ray.wurlod wrote:So put the "trim the trailing comma" logic into the first job. ...
I have tried all the different options while reading the file in the next job, but it always throws the warning. I am getting the desired output put the warning is bugging me.Sainath.Srinivasan wrote:How do you intend to use this file in the downstream process ?
In the place you read the file, mention record delimiter as 'none' and work with the plan that there is an extra comma. No need to worry about it.
Tried out all the options but cannot get rid of the warning.Sainath.Srinivasan wrote:Did you try 'record delimiter = none' ?
Hi Pravin,pravin1581 wrote:Thanks Sai. I tried this , the output is coming as 1,2,3,4,Sainath.Srinivasan wrote:Read the source and write an output with record delimiter as comma
Hi,pravin1581 wrote:This doesn't works . The output is coming as 0,0,0,0,arunkumarmm wrote:Or even in a simpler way, create a stage variable like this:
sv1 = sv1 : ',' : InputColumn
and map it to the target column derivation.
The last output row will have all the values...
Hi could you tell me how you did you get it? I have same thing to do.pravin1581 wrote:Thanks Sai. I tried this , the output is coming as 1,2,3,4,Sainath.Srinivasan wrote:Read the source and write an output with record delimiter as comma
Hi Arun I did this but I am also getting 0,0,0,0,0, data is not comming. I tried your data as example could you tell me were I am doing wrong?arunkumarmm wrote:This should work. May be try defining the initial value of your stage variable to '' {Empty}pravin1581 wrote:This doesn't works . The output is coming as 0,0,0,0,
If you are mapping the column properly, how come this doesnt work? No complex thing involved in this. You are just appending your column to the stage variable. I have did this before and it worked. All you need to do is to check if everything is setup properly.