Starting Delimiter ignored in case of empty first field

[Anonymous]

Hello Everyone, 

My name is Marco and i am having an issue with Talend delimited Files.

In case a file is starting with 2 consecutive delimiters, the flow behaves as if the first delimiter does not exist, and that causes all the file to Shift back one field.

for example, if my file is

||TEST|HI|BEHAVIOR

i am expecting the file to be handled as

|TEST|HI|BEHAVIOR

but talend ignores the first delimiter and behaves as if it is written like this

TEST|HI|BEHAVIOR, so instead of having an empty first field, i have TEST as first field.

this only happens in case the very first field is empty.

How can we handle this? is there an option to tell talend not to ignore it?

Thanks

Marco

[TRF]

As the behaviour you encounter is strange, can you share your tFileInputDelimited Settings + Advanced settings?

I have this file:

F1|F2|F3
1|2|3
|2|3
||3

Here is my tFileInputDelimited:

And the result is as expected:

[statistics] connecting to socket on port 3483
[statistics] connected
.--+--+--.
|tLogRow_7|
|=-+--+-=|
|f1|f2|f3|
|=-+--+-=|
|1 |2 |3 |
|  |2 |3 |
|  |  |3 |
'--+--+--'

[statistics] disconnected

[gouravd_7]

Check the component settings you might have missed the separators to "||" try changing it to "|".
Send the screesnshot of component if issue still persists.

[Anonymous]

Hi,

no the problem is not in the way we define the delimiter, because if the first field is populated, it behaves properly. also we use a special character as separator so we are pretty sure there is no interference. 

screenshot.562.jpg
screenshot.564.jpg

[Anonymous]

Hi,

Please see the attached screenshots.

What version of Talend are you on? we are on 7.0.1.

Thanks

screenshot.562.jpg
screenshot.564.jpg