Output to DBF

One Star

Output to DBF

Is there any way that I could merge two or three delimited files into one DBF file?
Tags (1)
Highlighted
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.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download