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)
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

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads