App::CSVUtils::Manual::Tips - App::CSVUtils tips/tricks
This document describes version 0.050 of App::CSVUtils::Manual::Tips (from Perl distribution App-CSVUtils), released on 2022-12-02.
If you process data from/to GUI spreadsheet programs, as an alternative to using stdin/stdout (which often involves copy-pasting to GUI terminal emulator), you can also operate on clipboard: URLs as input/output to get/set data from/to clipboard. To do this, you must first install lwp::protocol::clipboard.
clipboard:
For example, after you copy a range of cells from LibreOffice, you can do:
% csv-munge-row -He '$_->{foo} = some-calculation...' --input-tsv clipboard: --output-tsv -o clipboard:
The first clipboard: argument retrieves CSV from clipboard in TSV format, while the second clipboard: argument sets output to clipboard where the result of operation will be sent to clipboard as new content. This is convenient because you don't have to copy-paste to/from terminal emulator first.
Please visit the project's homepage at https://metacpan.org/release/App-CSVUtils.
Source repository is at https://github.com/perlancar/perl-App-CSVUtils.
perlancar <perlancar@cpan.org>
To contribute, you can send patches by email/via RT, or send pull requests on GitHub.
Most of the time, you don't need to build the distribution yourself. You can simply modify the code, then test via:
% prove -l
If you want to build the distribution (e.g. to try to install it locally on your system), you can install Dist::Zilla, Dist::Zilla::PluginBundle::Author::PERLANCAR, Pod::Weaver::PluginBundle::Author::PERLANCAR, and sometimes one or two other Dist::Zilla- and/or Pod::Weaver plugins. Any additional steps required beyond that are considered a bug and can be reported to me.
This software is copyright (c) 2022, 2021, 2020, 2019, 2018, 2017, 2016 by perlancar <perlancar@cpan.org>.
This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.
Please report any bugs or feature requests on the bugtracker website https://rt.cpan.org/Public/Dist/Display.html?Name=App-CSVUtils
When submitting a bug or request, please include a test-file or a patch to an existing test-file that illustrates the bug or desired feature.
To install App::CSVUtils, copy and paste the appropriate command in to your terminal.
cpanm
cpanm App::CSVUtils
CPAN shell
perl -MCPAN -e shell install App::CSVUtils
For more information on module installation, please visit the detailed CPAN module installation guide.