how to map a text file?

Chebli — Fri, 15 Nov 2024 23:33:50 GMT

Hello talend community

I have a file of type text contains heterogeneous information "bank statement" and I try to map in output in excel or a table in a database can help me ??

here is the file I am trying to map

Re: how to map a text file?

Anonymous — Tue, 02 Nov 2021 09:06:12 GMT

Hello,

Please take a look at the tFileinputPositional components.

https://help.talend.com/r/en-US/Cloud/studio-user-guide-cloud-api-services-platform/centralizing-file-positional-metadata

This however will not solve the multi-line aspect.

For that I'd suggest adding a tJavaFlex with:

[begin]

int id = 0;

[main]

String firstCol = row2.Column0;

//i.e. it starts with 08/04 then it's a new line if it is empty then it belongs to the previous line

if(firstCol != null && firstCol.trim().length() > 4 ) {

id++;

}

row3.id = id;

Then using a tDenormalize component we can merge the fields:

Here I don't add the ID column and merge without Delimiters the other columns.

Output looks like this:

I hope this helps.

Regards,

Balázs

topic how to map a text file? in Talend Studio

how to map a text file?

Re: how to map a text file?