New line character issue for sequential file stage

austin_316 · Post by **austin_316** » Wed Jul 13, 2011 2:51 am

thanks everyone for the reply
we have got a workaround for this problem. instead of keeping the data in sequential and then calling the java file to access the file, we placed the data in a dataset and the called the java class from the java tranformer stage which will write the data into another dataset.

vishal_rastogi · Post by **vishal_rastogi** » Wed Jul 13, 2011 10:56 pm

i have used the same situation in one of my job it is working fine .

Convert(char(10)," ",DSLink.columnname)

austin_316 · Post by **austin_316** » Thu Jul 14, 2011 12:41 am

iam assuming you have a transformer in the job. in our case we dont have a transformer stage and we are not sure in which column does the new line character comes. and also we dont want to use the convert() funtion for all the columns in the transformer. that is the reason why we went with java transformer stage.