topic Read a input file without '\n' in Talend Studio

Read a input file without '\n'

Anonymous — Mon, 15 Oct 2018 17:27:56 GMT

Hi,

I need to read a file which not contains '\n'. It looks like :

"first field 1 second field 1 first field 2 second field 2 first field 3 second field 3 first field 4 second field 4....."

I have to put this file in two columns like this:

column 1 column 2

first field 1 second field 1

first field 2 second field 2

first field 3 second field 3

This is fixed field but I can't use t File input Positional object because my file doesn't contains separator of lines like '\n'.

Can you help me please?

Re: Read a input file without '\n'

TRF — Mon, 15 Oct 2018 17:43:42 GMT

You tFileInputRaw to get the content, then you need to split the input every n characters (see String.split() method) and push the result to a file you can now read as a positional file.
That's the general idea.

Re: Read a input file without '\n'

Anonymous — Tue, 16 Oct 2018 12:47:11 GMT

Thank you very much for your help!

I try your method but finally I was easier to use a t-Java-Flex to read my file in stream, line by line as I wanted. After I used a t-map with some functions that I wrote in Java as a routine to separate each line in 2 columns.