Output to DBF

Highlighted
One Star

Output to DBF

Is there any way that I could merge two or three delimited files into one DBF file?
Employee

Re: Output to DBF

Is there any way that I could merge two or three delimited files into one DBF file?

To merge several source files, please follow this link: 200
Is there any way that I could merge two or three delimited files into one DBF file?

For DBF file format we haven't yet a tFileXBaseOutput.
However, a module exists on CPAN. If you aren't afraid with Perl go to http://search.cpan.org/~clotho/CAM-DBF-1.02/lib/CAM/DBF.pm
You can use a tPerlFlex to generate the header and the data content of the XBase file.
To define a header on DBF file you can use:
 my $dbf = CAM::DBF->create('new.dbf',
{name=>'id',
type=>'N', length=>8, decimals=>0},
{name=>'lastedit',
type=>'D', length=>8, decimals=>0},
{name=>'firstname',
type=>'C', length=>15, decimals=>0},
{name=>'lastname',
type=>'C', length=>20, decimals=>0},
);

To generate data you can use:
$self->appendrow_arrayref($data_arrayref)

See POD on CPAN for more information.
One Star

Re: Output to DBF

Thanks!! I will give it a try but to tell you the truth Perl terrorizes me.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog