Process CSV file - video
Process CSV file
Published on 2015-06-13
If you have any comments or questions, feel free to post them on the source of this page in GitHub. Source on GitHub.
Comment on this post
Beginner Perl Maven video course - video
- Introduction
- Welcome and Installation - video
- Editors and IDEs for Perl developers - video
- Your first script: Hello world - video
- Safety net (use strict; use warnings;) - video
- Debugging Perl scripts - video
- Comments - video
- Documentation of Perl - video
- POD - Plain Old Documentation - video
- Perl on the command line (screencast) - video
- Exercise: Hello World - video
- Solution: Hello World part 1 - video
- Solution: Hello World part 2 (what is the difference between comment and POD?) - video
- Scalars
- Scalar values and variables - video
- Common Errors and Warnings - video
- Variable interpolation - User Input and Output - chomp - video
- Numerical Operators - video
- String operators - video
- The 'if' statement - video
- Comparison Operators - video
- String to number conversion - video
- Compare Values - video
- undef - video
- Logical Operators in Perl - video
- True False - video
- Short Circuit - video
- String functions: index - video
- Substr - video
- strings in double quotes - video
- strings in single quotes - video
- Scope of Variables - video
- rand() and int() - video
- Here documents - video
- Exercise: rectangular - video
- Solution: area of rectangular - video
- Solution: area prompt and warn - video
- Solution: concatenation - video
- Exercise: number guessing game - video
- Solution: number guessing game - video
- Files
- die, warn, exit - video
- Open file - video
- Open file all - video
- Open file with error handling - video
- Open or die - video
- No such file - video
- read one line - video
- while loop - video
- Read file line by line - video
- Write to file - video
- Sum numbers in a file - video
- Debug sum numbers - video
- Analyze Apache log file - video
- Old style open - video
- Exercise: add more statistics - video
- Solution: add more statistics - video
- Exercise: write report to file - video
- Solution: write report to file - video
- Lists and Arrays
- Lists in Perl - video
- List assignment - video
- foreach loop over list - video
- Creating an array - video
- Array assignment - video
- Exercise: more statistics - video
- Array indexes - video
- Array indexes (screencast) - video
- Looks like number - video
- Command line parameters - video
- Command line parameters (screencast) - video
- Process command line using Getopt::Long - video
- Process command line using Getopt::Long (screencast) - video
- Process CSV file - video
- Process CSV file short version - video
- One-liner sum of column in CSV - video
- Process CSV file using Text::CSV_XS - video
- Join - video
- Exercise: improve the color selector - video
- Solution: improve the color selector - video
- Solution: improve the color selector - check input - video
- Solution: improve the color selector - force - video
- Solution: improve the color selector - colors.txt - video
- Solution: improve the color selector - filename - video
- Exercise: improve number guessing game - video
- Solution: number guessing game - multiple guesses - video
- Solution: number guessing game - exit - video
- Solution: number guessing game - s show - video
- Solution: number guessing game - n next game - video
- Solution: number guessing game - d debug toggle - video
- Solution: number guessing game - m move toggle - video
- Advanced Arrays
- The year of 19100 - video
- array in context - video
- Conext sensitivity - video
- Filehandle in SCALAR and LIST context - video
- slurp - video
- pop and push - video
- Loop controls: next last - video
- shift and unshift - video
- shift - video
- reverse - video
- sort - video
- The Ternary operator - video
- Count digits - video
- Exercise: display unique rows of a file - video
- Exercise: sort mixed string - video
- Solution: display unique rows of a file - video
- Functions and Subroutines
- Hashes
- A hash and its uses - video
- Creating a hash - video
- Creating a hash from an array - video
- hash in SCALAR context - video
- Fetching data from a hash - video
- exists, delete in hash - video
- Counting words in a file - video
- Dumping a hash - video
- Exercise: parse HTTP values - video
- Solution: parse HTTP values - video
- Exercise: improve color selector - video
- Solution: improve color selector - video
- Exercise: sort scores - video
- Solution: sort scores - video
- Exercise: improve Apache log analyzer - video
- Solution: improve Apache log-analyzer - video
- Exercise: parse variable width fields - video
- Solution: parse variable width fields - video
- Regular Expressions - part 1
- Regexes - video
- Were can I use Regexes - video
- Simple use of Regexes - video
- Finding a string in a file - video
- Single character match - video
- Match any character - video
- Character classes - video
- Negated character class - video
- Optional Characters - video
- Any number of any characters - video
- Quantifiers - video
- Quantifiers on Character classes - video
- Exercise: Regexes 1 - video
- Solution: regexes 1 - video
- Solution: regexes 2 - video
- Solution: regexes 3 - video
- Regular Expressions - part 2
- Regex Alternatives - video
- Regex Capturing - video
- Regex Anchors - video
- More about Character classes - video
- Special character classes - video
- Exercise: Match numbers with regex - video
- Solution: Match numbers with regex - video
- Exercise: hexa, octal, binary - video
- Solution: hexa, octal, binary - video
- Exercise: Roman numbers - video
- Regular Expressions - part 3
- m-for-matching - video
- Case insensitive regexes - video
- multiple lines in regexes - video
- Single-line regexes using /s - video
- /x modifier for verbose regexes - video
- substitution - video
- Global substitution with regexes - video
- Greedy regex quantifiers - video
- Minimal Regex Matching - video
- trim - video
- Fixing Assembly with Perl - video
- split with regex - video
- Fixing dates using Regexes - video
- Exercise: split HTTP GET request - video
- Solution: split HTTP using Regex - video
- Exercise: split path - filename/dirname - video
- Solution: split path - filename/dirname - video
- Exercise: sort SNMP numbers - video
- Solution: sort SNMP numbers - video
- Exercise: parse hours log file and create time report - video
- Exercise: parse INI file - video
- Exercise: parse perl file - video
- Shell to Perl
- CPAN
- Using procedural Perl modules - video
- Using object oriented modules - video
- Changing @INC - video
- Changing @INC relative path - video
- What is CPAN? - video
- Some interesting CPAN modules - video
- Installing Perl modules from the OS vendor - video
- Installing Perl modules using cpan - video
- search.cpan.org - video
- CPAN Testers and CPAN Ratings - video
- Applications
- Create Linux user account - video
- Diskspace usage: df in Perl - video
- Reporting diskspace usage on a mail server - video
- disk usage: du in Perl - video
- Sending email with attachments - video
- Reading Excel file using Perl - video
- Read fixed width records - using unpack - video
- Processing config file - video
Author: Gabor Szabo
Gabor who runs the Perl Maven site helps companies set up test automation, CI/CD
Continuous Integration and Continuous Deployment and other DevOps related
systems.
Gabor can help refactor your old Perl code-base.
He runs the Perl Weekly newsletter.
Contact Gabor if you'd like to hire his service.
Buy his eBooks or if you just would like to support him, do it via Patreon.