How then do you intend to deal with cases such as
I'd recommend using the Text::CSV module in Perl (Not a core module but I've never been on a site that it won't install in, and can be shipped with the script if dependencies are an issue.)
Hello everyone I'm new here and this is my first post so first of all I want to say that this is a great forum and I have managed to found most of my answers in these forums : )
So with that I ask you my first question:
I have an excel file which I saved as a csv. However the excel file... (3 Replies)
Hi team,
I have 20 columns csv files. i want to find the duplicates in that file based on the column1 column10 column4 column6 coulnn8 coulunm2 . if those columns have same values . then it should be a duplicate record.
can one help me on finding the duplicates,
Thanks in advance.
... (2 Replies)
Hi All,
I have a text file with three columns. I would like a simple script that removes lines in which column 1 has duplicate entries, but use the largest value in column 3 to decide which one to keep. For example:
Input file:
12345a rerere.rerere len=23
11111c fsdfdf.dfsdfdsf len=33 ... (3 Replies)
I have a .CSV file (file.csv) whose data are all enclosed in double quotes. Sample format of the file is as below:
column1,column2,column3,column4,column5,column6, column7, Column8, Column9, Column10
"12","B000QRIGJ4","4432","string with quotes, and with a comma, and colon: in... (3 Replies)
I am trying to see if I can use awk to remove duplicates from a file. This is the file:
-==> Listvol <==
deleting /vol/eng_rmd_0941
deleting /vol/eng_rmd_0943
deleting /vol/eng_rmd_0943
deleting /vol/eng_rmd_1006
deleting /vol/eng_rmd_1012
rearrange /vol/eng_rmd_0943
... (6 Replies)
i have data as below
123,"paul phiri",paul@yahoo.com,"po.box 23, BT","Eco Bank,Blantyre,Malawi"
i need an output to be
123,"paul phiri",paul@yahoo.com,"po.box 23 BT","Eco Bank Blantyre Malawi" (5 Replies)
Hi,
I have a file of csv data, which looks like this:
file1:
1AA,LGV_PONCEY_LES_ATHEE,1,\N,1,00020460E1,0,\N,\N,\N,\N,2,00.22335321,0.00466628
2BB,LES_POUGES_ASF,\N,200,200,00006298G1,0,\N,\N,\N,\N,1,00.30887539,0.00050312... (10 Replies)
In the attached file I am trying to remove all the "" and , (quotes and commas) from $2 and $3 and the "" (quotes) from $4.
I tried the below as a start:
awk -F"|" '{gsub(/\,/,X,$2)} 1' OFS="\t" enhancer.txt > comma.txt
Thank you :). (6 Replies)
how to remove unwanted commas from a .csv file
Input file format
"Server1","server-PRI-Windows","PRI-VC01","Microsoft Windows Server 2012, (64-bit)","Powered On","1,696.12","server-GEN-SFCHT2-VMS-R013,server-GEN-SFCHT2-VMS-R031,server-GEN-SFCHT2-VMS-R023"... (5 Replies)
Discussion started by: ranjancom2000
5 Replies
LEARN ABOUT DEBIAN
carton-install
CARTON-INSTALL(1p) User Contributed Perl Documentation CARTON-INSTALL(1p)NAME
carton-install - Install the dependencies
SYNOPSIS
carton install [--deployment] [--path=PATH] [modules...]
DESCRIPTION
Install the dependencies for your application. This command has two modes and the behavior is slightly different.
DEVELOPMENT MODE
carton install (no arguments)
If you run "carton install" without any arguments and if cpanfile exists, carton will scan dependencies from cpanfile and install the
modules.
In either way, if you run "carton install" for the first time (i.e. carton.lock does not exist), carton will fetch all the modules
specified, resolve dependencies and install all required modules from CPAN.
If carton.lock file does exist, carton will still try to install modules specified or updated in cpanfile, but uses carton.lock for the
dependency resolution, and then cascades to CPAN.
carton will analyze all the dependencies and their version information, and it is saved into carton.lock file. It is important to add
carton.lock file into a version controlled repository and commit the changes as you update your dependencies.
DEPLOYMENT MODE
If you specify the "--deployment" command line option or the carton.lock exists and cpanfile does not exist, carton will fetch all remote
modules and use the dependencies specified in the carton.lock instead of resolving dependencies.
CONSERVATIVE UPDATE
"carton install" doesn't update the modules already installed into local library path as long as the version is satisfied.
For example, one day you install URI-1.50 from CPAN:
> carton install URI
Successfully installed URI-1.50
Few weeks later, URI module is updated to 1.51 on CPAN. If you run the "carton install URI" again:
> carton install URI
You have URI (1.50)
because you haven't specified the version number, carton won't update the module in your local library path.
WARNINGS: following commands are not implemented
If you want to update to the latest version of CPAN, you can either use "carton update" command, or specify the required version either in
your cpanfile.
> carton update URI
> cat cpanfile
requires 'URI', 1.51;
Any of those will upgrade URI to the latest one from CPAN, and the version specified in the carton.lock will be bumped.
OPTIONS --deployment
Force the deployment mode and carton will ignore cpanfile contents.
--path
Specify the path to install modules to. Defaults to local in the current directory.
perl v5.14.2 2012-05-12 CARTON-INSTALL(1p)