I have two excel sheet (sheetA and sheetB) and I need to compare one column from sheetA with sheetB and print the difference. sheetA sheetB I need to compare “Account Number” with “Customer Number”. All account numbers from sheetA should be present in customer number in sheetB and if sheetB is missing any “account number” then we should print out
Tag: perl
Create files in subdirectories with the same name [closed]
Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 4 years ago. Improve this question Reading a list with A and B data in 2 columns, iterating row by row, I was createding a series of direcoties with the following
Sending linux commands in Perl – Grep piped to grep
The basic code: Why wont Perl complete these commands correctly? $fail2ban is already defined to 0, so that’s not the issue. The fail2ban.log does contain a line that should match(when running command from shell it matches): The error i keep getting is: All the commands run fine from bash/shell, seems at if perl is not happy with grep being piped
How to sort or rearrange numbers from multiple column into multiple row [fixed into 4 columns]?
I have 1 text file, which is test1.txt. text1.txt contain as following: Input: Condition: A1 and B1 -> for each A1 + (B1 + [Tn + Vn]) A1 should be in 1 column. B1 should be in 1 column. T1,T2,T3 and T4 should be in 1 column. V1,V2,V3 and V4 should be in 1 column. How do I sort it
Arin Bulk whois data perl Can’t locate BulkWhois/Schema.pm in @INC
I have tried this on two operating systems (first on Fedora then on Ubuntu(recommended)) and I am still confused so I am reaching out to the community. I have access to ARIN’s bulk whois data and want to parse the xml file and throw it into a database. I came across a Perl script that does exactly this in a
How to delete lines that match elements from another file
I am in the process of learning Perl and I am trying to figure out how to do this task. I have a folder with a bunch of text files and I have a file ions_solvents_cofactors that contains bunch of three letters list. I wrote a script that opens and reads each file in a folder and should delete those
How do I run Perl’s “prove“ TAP harness in unbuffered mode?
As part of a test suite written in Python 3[.4-.6] on Linux, I have to run a number 3rd-party tests. The 3rd-party tests are bash scripts. They are designed to run with Perl’s prove TAP harness. One bash script can contain up to a few thousands of individual tests – and some of them can hang indefinitely. After a timeout,
‘Housekeeping’ script to create folder and move files
I have been trying to investigate how to automate a script (shell or other) that periodically (once an hour for example) moves files with a constant naming convention to a folder (which is automatically created if not already there). The files are like this: Camera1_01_20171213221830928.jpg Camera1_01_20171213223142881.mp4 Basically it will be doing ‘housekeeping’. I’m new to shell scripts, and I just
check password linux user
I am on debian 9. I have a problem to check the password of a linux user in my scripts. I realized that the different linux tools for creating and modifying a user password gave results of different pattern in /etc/shadow To create a user I have in /etc/shadow In another script I want check the password input by the
“undefined symbol: mg_free_type” when installing mod_perl 2.0.10 with Apache 2.4.26 and Perl 5.10.1
I’m trying to install mod_perl 2.0.10 for use with a new Apache 2.4 instance. I’ve got Apache 2.4.26 up and running by itself, but I also need mod_perl installed for a couple of modules to work. Here’s the problem: mod_perl always fails its tests claiming: The only information I could find on this is here: Error when installing mod_perl2. Unfortunately,