NAME

db_fix_column.pl - fix a column up in a text table.

COPYRIGHT

Copyright (C) 2001, 2002 Mark Veltzer; All rights reserved.

LICENSE

This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111, USA.

DETAILS

        MANIFEST: db_fix_column.pl
        PROJECT: meta
        VERSION: 0.14

SYNOPSIS

        db_fix_column.pl

DESCRIPTION

This will fix a column in a text table for you. It will assume that the text file is a reflection of a table in a database and has a certain delimiter to make it such (both for lines and for entries within lines) and will make the values in that column sequential.

Take heed when using this script since it actually modifies the file given to it. The change that this script makes is also non reversible. This means you should back up your data. Really.

OPTIONS

help (type: bool, default: 0)

display help message

pod (type: bool, default: 0)

display pod options snipplet

man (type: bool, default: 0)

display manual page

quit (type: bool, default: 0)

quit without doing anything

gtk (type: bool, default: 0)

run a gtk ui to get the parameters

license (type: bool, default: 0)

show license and exit

copyright (type: bool, default: 0)

show copyright and exit

description (type: bool, default: 0)

show description and exit

history (type: bool, default: 0)

show history and exit

verb (type: bool, default: 0)

noisy or quiet ?

demo (type: bool, default: 0)

just play around or do it for real ?

star (type: inte, default: 0)

what will be the start value on the column ?

jump (type: inte, default: 1)

how much should I just between records ?

colu (type: inte, default: 0)

what column to fix ?

ldel (type: stri, default: )

what line delimiter to use ?

vdel (type: stri, default: )

what field delimiter to use ?

minimum of [1] free arguments required no maximum limit on number of free arguments placed

BUGS

None.

AUTHOR

        Name: Mark Veltzer
        Email: mailto:veltzer@cpan.org
        WWW: http://www.veltzer.org
        CPAN id: VELTZER

HISTORY

        0.00 MV more on data sets
        0.01 MV perl packaging
        0.02 MV license issues
        0.03 MV more database issues
        0.04 MV md5 project
        0.05 MV database
        0.06 MV perl module versions in files
        0.07 MV thumbnail user interface
        0.08 MV more thumbnail issues
        0.09 MV website construction
        0.10 MV improve the movie db xml
        0.11 MV web site automation
        0.12 MV SEE ALSO section fix
        0.13 MV move tests to modules
        0.14 MV md5 issues

SEE ALSO

Meta::IO::File(3), Meta::Utils::File::Move(3), Meta::Utils::Opts::Opts(3), Meta::Utils::System(3), Meta::Utils::Utils(3), strict(3)

TODO

Nothing.