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?
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.
Highlighted
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 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

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch