12-07-2011
i don't have such scenario's. my trouble is to ignore commas within double quotes.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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)
Discussion started by: Spunkerspawn
3 Replies
2. Shell Programming and Scripting
Name,,,,,,,,,,,,,,,,,,,,Domain,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Contact,Phone,Email,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Location
-----------------------,------------------------------------------------,-------,-----,---------------------------------,------------------------------------
----... (1 Reply)
Discussion started by: sreenath1037
1 Replies
3. Shell Programming and Scripting
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)
Discussion started by: baskivs
2 Replies
4. Shell Programming and Scripting
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)
Discussion started by: anniecarv
3 Replies
5. Linux
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)
Discussion started by: dhruuv369
3 Replies
6. Shell Programming and Scripting
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)
Discussion started by: newbie2010
6 Replies
7. Shell Programming and Scripting
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)
Discussion started by: mathias23
5 Replies
8. Shell Programming and Scripting
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)
Discussion started by: djoseph
10 Replies
9. Shell Programming and Scripting
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)
Discussion started by: cmccabe
6 Replies
10. Shell Programming and Scripting
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 REDHAT
pdl::gslsf::trig
TRIG(3) User Contributed Perl Documentation TRIG(3)
NAME
PDL::GSLSF::TRIG - PDL interface to GSL Special Functions
DESCRIPTION
This is an interface to the Special Function package present in the GNU Scientific Library.
SYNOPSIS
Functions
FUNCTIONS
gsl_sf_sin
Signature: (double x(); double [o]y(); double [o]e())
Sin(x) with GSL semantics.
gsl_sf_cos
Signature: (double x(); double [o]y(); double [o]e())
Cos(x) with GSL semantics.
gsl_sf_hypot
Signature: (double x(); double xx(); double [o]y(); double [o]e())
Hypot(x,xx) with GSL semantics.
gsl_sf_complex_sin
Signature: (double zr(); double zi(); double [o]x(); double [o]y(); double [o]xe(); double [o]ye())
Sin(z) for complex z
gsl_sf_complex_cos
Signature: (double zr(); double zi(); double [o]x(); double [o]y(); double [o]xe(); double [o]ye())
Cos(z) for complex z
gsl_sf_complex_logsin
Signature: (double zr(); double zi(); double [o]x(); double [o]y(); double [o]xe(); double [o]ye())
Log(Sin(z)) for complex z
gsl_sf_lnsinh
Signature: (double x(); double [o]y(); double [o]e())
Log(Sinh(x)) with GSL semantics.
gsl_sf_lncosh
Signature: (double x(); double [o]y(); double [o]e())
Log(Cos(x)) with GSL semantics.
gsl_sf_polar_to_rect
Signature: (double r(); double t(); double [o]x(); double [o]y(); double [o]xe(); double [o]ye())
Convert polar to rectlinear coordinates.
gsl_sf_rect_to_polar
Signature: (double x(); double y(); double [o]r(); double [o]t(); double [o]re(); double [o]te())
Convert rectlinear to polar coordinates. return argument in range [-pi, pi].
gsl_sf_angle_restrict_symm
Signature: (double [o]y())
Force an angle to lie in the range (-pi,pi].
gsl_sf_angle_restrict_pos
Signature: (double [o]y())
Force an angle to lie in the range [0,2 pi).
gsl_sf_sin_err
Signature: (double x(); double dx(); double [o]y(); double [o]e())
Sin(x) for quantity with an associated error.
gsl_sf_cos_err
Signature: (double x(); double dx(); double [o]y(); double [o]e())
Cos(x) for quantity with an associated error.
AUTHOR
This file copyright (C) 1999 Christian Pellegrin <chri@infis.univ.trieste.it> All rights reserved. There is no warranty. You are allowed to
redistribute this software / documentation under certain conditions. For details, see the file COPYING in the PDL distribution. If this
file is separated from the PDL distribution, the copyright notice should be included in the file.
The GSL SF modules were written by G. Jungman.
perl v5.8.0 2003-01-29 TRIG(3)