Sponsored Content
Top Forums Shell Programming and Scripting Help parse comma separated list Post 302466410 by DGPickett on Tuesday 26th of October 2010 10:35:45 AM
Old 10-26-2010
BTW, if these are true MS Comma Separated Value (CSV) files, they can have double quoted fields with comma, doubled double quotes for any double quote in a field and a carriage return as well as a line feed. (Excel always honors this, but not some old Access versions.)
Code:
haha,hoho,"Baked, AK","He said ""Get out of my head!"" and shook his head violently.",975^M

 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Unix shell script to parse the contents of comma-separated file

Dear All, I have a comma-separated file. 1. The first line of the file(header) should have 4 commas(5 fields). 2. The last line of the file should have 1 comma(2 fields). Pls help me in checking this condition in a shell script. And the number of lines between the first line and last... (11 Replies)
Discussion started by: KrishnaSaran
11 Replies

2. Shell Programming and Scripting

Parse apart strings of comma separated data with varying number of fields

I have a situation where I am reading a text file line-by-line. Those lines of data contain comma separated fields of data. However, each line can vary in the number of fields it can contain. What I need to do is parse apart each line and write each field of data found (left to right) into a file.... (7 Replies)
Discussion started by: 2reperry
7 Replies

3. Shell Programming and Scripting

Perl script to parse output and print it comma separated

I need to arrange output of SQL query into a comma separated format and I'm struggling with processing the output... The output is something like this: <Attribute1 name><x amount of white spaces><Atribute value> <Attribute2 name><x amount of white spaces><Atribute value> <Attribute3... (2 Replies)
Discussion started by: Juha
2 Replies

4. Shell Programming and Scripting

Output of command in comma separated list

Hi; I have an output of a particular command say $command fstl:r-x ajay:r-x how can i get this in comma separated list, eg: fstl:r-x,ajay:r-x Thnks; (4 Replies)
Discussion started by: ajaypadvi
4 Replies

5. Shell Programming and Scripting

Need Help - comma inside double quote in comma separated csv,

Hello there, I have a comma separated csv , and all the text field is wrapped by double quote. Issue is some text field contain comma as well inside double quote. so it is difficult to process. Input in the csv file is , 1,234,"abc,12,gh","GH234TY",34 I need output like below,... (8 Replies)
Discussion started by: Uttam Maji
8 Replies

6. UNIX for Dummies Questions & Answers

[solved] Comma separated values to space separated

Hi, I have a large number of files which are written as csv (comma-separated values). Does anyone know of simple sed/awk command do achieve this? Thanks! ---------- Post updated at 10:59 AM ---------- Previous update was at 10:54 AM ---------- Guess I asked this too soon. Found the... (0 Replies)
Discussion started by: lost.identity
0 Replies

7. Shell Programming and Scripting

awk to parse comma separated field and removing comma in between number and double quotes

Hi Experts, Please support I have below data in file in comma seperated, but 4th column is containing comma in between numbers, bcz of which when i tried to parse the file the column 6th value(5049641141) is being removed from the file and value(222.82) in column 5 becoming value of column6. ... (3 Replies)
Discussion started by: as7951
3 Replies

8. UNIX for Beginners Questions & Answers

How to extract fields from a CSV i.e comma separated where some of the fields having comma as value?

can anyone help me!!!! How to I parse the CSV file file name : abc.csv (csv file) The above file containing data like abv,sfs,,hju,',',jkk wff,fst,,rgr,',',rgr ere,edf,erg,',',rgr,rgr I have a requirement like i have to extract different field and assign them into different... (4 Replies)
Discussion started by: J.Jena
4 Replies

9. UNIX for Beginners Questions & Answers

Remove duplicates from comma separated list

Hi, I have following input file: niki niki niki1 niki niki2 niki,niki2 niki3 niki,niki3,niki niki4 niki4,blabla niki5 jkjkl niki6 niki60,niki6 I would like to delete lines with identical matches completely and remove the selfmatches in the other lines. ... (2 Replies)
Discussion started by: niki0211
2 Replies
Pango::Matrix(3)					User Contributed Perl Documentation					  Pango::Matrix(3)

NAME
Pango::Matrix HIERARCHY
Glib::Boxed +----Pango::Matrix METHODS
matrix = Pango::Matrix->new ($xx=1., $xy=0., $yx=0., $yy=1., $x0=0., $y0=0.) o $xx (double) o $xy (double) o $yx (double) o $yy (double) o $x0 (double) o $y0 (double) $matrix->concat ($new_matrix) o $new_matrix (Pango::Matrix) $matrix->rotate ($degrees) o $degrees (double) $matrix->scale ($scale_x, $scale_y) o $scale_x (double) o $scale_y (double) (dx, dy) = $matrix->transform_distance ($dx, $dy) o $dx (double) o $dy (double) Since: pango 1.16 array reference = $matrix->transform_pixel_rectangle ($rect) o $rect (array reference) Since: pango 1.16 (x, y) = $matrix->transform_point ($x, $y) o $x (double) o $y (double) Since: pango 1.16 array reference = $matrix->transform_rectangle ($rect) o $rect (array reference) Since: pango 1.16 $matrix->translate ($tx, $ty) o $tx (double) o $ty (double) double = $matrix->x0 ($new) o $new (double) double = $matrix->xx ($new=0) o $new (double) double = $matrix->xy ($new) o $new (double) double = $matrix->y0 ($new) o $new (double) double = $matrix->yx ($new) o $new (double) double = $matrix->yy ($new) o $new (double) SEE ALSO
Pango, Glib::Boxed COPYRIGHT
Copyright (C) 2003-2009 by the gtk2-perl team. This software is licensed under the LGPL. See Pango for a full notice. perl v5.12.1 2010-07-05 Pango::Matrix(3)
All times are GMT -4. The time now is 05:35 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy