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 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads