Hi All, I have a requirement to remove the new line characters from an input file. Input:(csv file) A,B,C,D,E 10529,abc,cdef,2014-10-10T10:35:06,Customer believes she became ill as a result of the cold temperature of foodhall. Have spoken to FOSM, Barry, who has advised that temperature is chilly, but not arctic cold. The store have replaced filters in heaters at bottom of fridges which should make a difference. Is this does make an improvement they will be contacting Matrix who control temperatures of our stores centrally. I will write back to customer advising that we are looking to address issue, however, will not acknowledge her health issues as being caused by our store. Expected Output: A,B,C,D,E 10529,abc,cdef,2014-10-10T10:35:06,Customer believes she became ill as a result of the cold temperature of foodhall.Have spoken to FOSM, Barry, who has advised that temperature is chilly, but not arctic cold. The store have replaced filters in heaters at bottom of fridges which should make a difference. Is this does make an improvement they will be contacting Matrix who control temperatures of our stores centrally.I will write back to customer advising that we are looking to address issue, however, will not acknowledge her health issues as being caused by our store. Datastage is unable to import the data and throws a warning when the records having new line characters. As a result of this records are getting rejected at the output. Is it possible to handle in datastage parallel jobs (V 8.5) so that the last column which contains new lines to hold the data under column E after removing the new line characters and concatenates with previous line? Thanks in advance.
Posted on: Tue, 28 Oct 2014 08:10:45 +0000