Gossamer Forum
Home : Products : DBMan : Customization :

Re: External Text File Mod

Quote Reply
Re: External Text File Mod In reply to
you can write a small perl script to do the job.
just define how you would name that files...
the script is quite simple :

read your db
for each line split values
put the wanted value in a file

that's all...
my ($line, @data, $field);
$db_file_name = "FULL PATH TO YOUR DB";
$outdir = "DIRECTORY TO PUT FILES WITH TRAILING SLASH";
open (DB, $db_file_name);
LINE: while (<DB>) {
(/^#/) and next LINE;
(/^\s*$/) and next LINE;
$line = $_; chomp ($line);
@data = &split_decode($line);
# Assuming you want call your files as ID.txt where ID is in field 0
$outfile = @data[0].".txt";
open (OUT, ">$outdir/$outfile");
# Assuming data you want to export are in field 3
print OUT @data[3];
close OUT;
}
close DB;
exit;

sub split_decode
{
my ($input) = shift;
$input =~ s/\Q|\E$/$db_delim /o;
my (@array) = split (/\Q|\E/o, $input);
for ($i = 0; $i <= $#array; $i++)
{
$array[$i] =~ s/~~/|/og;
$array[$i] =~ s/`/\n/g;
return @array;
}
}

........................

i tried it...it works...

Valerio [Hypo] Verde

Subject Author Views Date
Thread External Text File Mod close_watch 2502 Jul 14, 2000, 7:13 AM
Thread Re: External Text File Mod
UTopiKa 2399 Jul 14, 2000, 8:40 AM
Thread Re: External Text File Mod
close_watch 2422 Jul 14, 2000, 10:01 AM
Thread Re: External Text File Mod
close_watch 2416 Jul 14, 2000, 11:53 AM
Thread Re: External Text File Mod
UTopiKa 2375 Jul 14, 2000, 5:14 PM
Thread Re: External Text File Mod
close_watch 2391 Jul 15, 2000, 6:29 AM
Thread Re: External Text File Mod
UTopiKa 2367 Jul 15, 2000, 6:01 PM
Post Re: External Text File Mod
close_watch 2356 Jul 16, 2000, 12:43 AM