12-03-2008
Merging Non-Empty Columns within a CSV
I am trying to place all my data in a single row (order doesn't matter). Note I am a Unix novice, so please go easy on me.
Here is an example
Raw data:
row#
(1) 45 64 23
(2) 32 1 6 56
(3) 32 45
Needs to be like this:
row#
(1) 45
(2) 32
(3) 32
(4) 64
(5) 1
(6) 45
(7) 23
(8) 6
(9) 56
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi there!
I have the following problem:
I have a set of files called rates_op_yyyyddmm with the format below (which corresponds to the file rates_op_20090130)
30-JAN-2009,ED,FEB09,C,96.375,,,0,,,,,,2.375,,,,,,
30-JAN-2009,ED,FEB09,C,96.5,,,0,,,,,,2.25,,,,,,... (2 Replies)
Discussion started by: Pep Puigvert
2 Replies
2. Shell Programming and Scripting
Hi,
Can you please tell me how to add empty columns at the end csv file?
Currently there are 6 columns in the csv file. I want to add 35 empty columns at the end of this csv file.
Thanks,
Tushar (17 Replies)
Discussion started by: Tushar Bendale
17 Replies
3. UNIX for Advanced & Expert Users
Hi All,
I have two .csv's
input.csv having values as (7 columns)
ABC,A19907103,ABC DEV YUNG,2.17,1000,2157,07/07/2006
XYZ,H00213850,MM TRUP HILL,38.38,580,23308,31/08/2010
output.csv having (25 columns)
A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y... (4 Replies)
Discussion started by: abhivyas
4 Replies
4. UNIX for Advanced & Expert Users
Hi All,
i have a .Csv file in the below format
startTime, endTime, delta, gName, rName, rNumber, m2239max, m2239min, m2239avg, m100016509avg, m100019240max, metric3min, m100019240avg, propValues
11-Mar-2012 00:00:00, 11-Mar-2012 00:05:00, 300.0, vma3550a, a-1_CPU Index<1>, 200237463, 0.0,... (9 Replies)
Discussion started by: mahi_mayu069
9 Replies
5. Shell Programming and Scripting
Hi,
I have following 2 CSV files
file1.txt
A1,B1,C1,D1,E1
A2,B2,C2,D2,E2
A3,B3,C3,D3,E3
....
file2.txt
A1,B1,P1,Q1,R1,S1,T1,U1
A1,B1,P2,Q2,R2,S2,T2,U2
A1,B1,P3,Q3,R3,S3,T3,U3
A2,B2,X1,Y1,Z1,I1,J1,K1
A2,B2,X2,Y2,Z2,I2,J2,K2
A2,B2,X3,Y3,Z3,I3,J3,K3
A2,B2,X4,Y4,Z4,I4,J4,K4... (2 Replies)
Discussion started by: learnoutmore99
2 Replies
6. Shell Programming and Scripting
Hi Friends,
I have come across some files where some of the columns don not have data.
Key, Data1,Data2,Data3,Data4,Data5
A,5,6,,10,,
A,3,4,,3,,
B,1,,4,5,,
B,2,,3,4,,
If we see the above data on Data5 column do not have any row got filled. So remove only that column(Here Data5) and... (4 Replies)
Discussion started by: ks_reddy
4 Replies
7. Linux
I have a .CSV file (lets say named as file.csv) with numeric and string values. The string might contain commas hence they are enclosed in double quotes as in the below format.
column1,column2,column3,column4,column5,column6,column7
12,455,"string, with, quotes, and with, commas, in... (3 Replies)
Discussion started by: dhruuv369
3 Replies
8. Shell Programming and Scripting
Hi experts,
I have a csv file which has one field (ID) repeated multiple times with corresponding other field values.
I need to convert this file in a format where for a ID all other values has to be present in single field.
For Eg : Here in below file ID 1 is repeated 3 times with different... (7 Replies)
Discussion started by: bharathbangalor
7 Replies
9. Shell Programming and Scripting
Hi all, I'm pretty much a newbie to UNIX. I would appreciate any help with UNIX coding on comparing two large csv files (greater than 10 GB in size), and output a file with matching columns.
I want to compare file1 and file2 by 'id' and 'chain' columns, then extract exact matching rows'... (5 Replies)
Discussion started by: bkane3
5 Replies
10. 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
LEARN ABOUT CENTOS
xkbaddgeomoverlayrow
XkbAddGeomOverlayRow(3) XKB FUNCTIONS XkbAddGeomOverlayRow(3)
NAME
XkbAddGeomOverlayRow - Add a row to an existing overlay
SYNOPSIS
XkbOverlayRowPtr XkbAddGeomOverlayRow (XkbOverlayPtr overlay, XkbRowPtr row_under, int sz_keys);
ARGUMENTS
- overlay
overlay to be updated
- row_under
row to be overlayed in the section overlay overlays
- sz_keys
number of keys to reserve in the row
DESCRIPTION
Xkb provides functions to add a single new element to the top-level keyboard geometry. In each case the num_ * fields of the corresponding
structure is incremented by 1. These functions do not change sz_* unless there is no more room in the array. Some of these functions fill
in the values of the element's structure from the arguments. For other functions, you must explicitly write code to fill the structure's
elements.
The top-level geometry description includes a list of geometry properties. A geometry property associates an arbitrary string with an
equally arbitrary name. Programs that display images of keyboards can use geometry properties as hints, but they are not interpreted by
Xkb. No other geometry structures refer to geometry properties.
XkbAddGeomOverlayRow adds one row to the overlay. The new row contains space for sz_keys keys. If row_under specifies a row that doesn't
exist on the underlying section, XkbAddGeomOverlayRow returns NULL and doesn't change the overlay. XkbAddGeomOverlayRow returns NULL if
any of the parameters is empty or if it was not able to allocate space for the overlay.
STRUCTURES
typedef struct _XkbOverlayRow {
unsigned short row_under; /* index into the row under this overlay row */
unsigned short num_keys; /* number of keys in the keys array */
unsigned short sz_keys; /* size of the keys array */
XkbOverlayKeyPtr keys; /* array of keys in the overlay row */
} XkbOverlayRowRec,*XkbOverlayRowPtr;
X Version 11 libX11 1.6.0 XkbAddGeomOverlayRow(3)