Sponsored Content
Full Discussion: Add columns in csv file
Top Forums Shell Programming and Scripting Add columns in csv file Post 302507988 by villebonnais on Friday 25th of March 2011 10:43:34 AM
Old 03-25-2011
Add columns in csv file

Hi everybody,
I am new here and I need a reel help please
A have a csv file and I want to add new in the end of the file


Code:
Devisce Model,VMGuest Name,Host OS Name, Memory Size
Value1,Value2,Value3,Value4
Value5,Value6,Value7,Value8
Value9,Value10,Value11,Value12

And I want to add to new column in "Period" and "Region" the end of the file
The "Period" columns will contain the date of today and the "Region" will give the path of the csv file

Code:
Devisce Model,VMGuest Name,Host OS Name, Memory Size,Period,Region
Value1,Value2,Value3,Value4,20110325,/home/Desktop
Value5,Value6,Value7,Value8,20110325,/home/Desktop
Value9,Value10,Value11,Value12,20110325/home/Desktop

20110325 is the 25th March 2011.

Thank you in advance!
Mel
Moderator's Comments:
Mod Comment
Please use code tags when posting data and code samples!

Last edited by vgersh99; 03-25-2011 at 11:46 AM.. Reason: code tags, please!
 

10 More Discussions You Might Find Interesting

1. Filesystems, Disks and Memory

manipulate csv file to add columns

Hi, I have a csv file with a key composed by 3 columns and some other numeric fields and I need to obtain the partial amounts by some part of the key. This may be some difficult to understand, so better see an example, where my input file is: name,surname,department,y2004,y2005,y2006... (6 Replies)
Discussion started by: oscarmon
6 Replies

2. Shell Programming and Scripting

Add Empty columns at the end of csv file

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

Unix Bash: substitute columns in .csv using other .csv columns

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. Shell Programming and Scripting

AWK : Add columns in the end of csv file

Hi everybody, I need some help please I have a csv file named masterFile1.csv header1,header2,header3 value1,value2,value3 value4,value5,value6 I am trying to add new columns in the end of the csv to have a new csv file named masterFile2.csv like this :... (3 Replies)
Discussion started by: villebonnais
3 Replies

5. UNIX for Advanced & Expert Users

Help in Deleting columns and Renaming Mutliple columns in a .Csv File

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

6. Shell Programming and Scripting

Deleting all the fields(columns) from a .csv file if all rows in that columns are blanks

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

Add empty columns at the end of a CSV file

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

Match columns from two csv files and update field in one of the csv file

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

Add 8 columns at the end of .csv file using awk

Hello all, I have a .csv file of 16 columns consists of bunch of numbers. 6.45E+01 1.17E+01 8.10E+04 8.21E+01 8.50E+00 1.20E+01 1.02E+01 1.88E+01 1.86E+04 3.53E+03 1.09E+07 3.82E+04 2.09E+03 3.57E+03 2.98E+03 3.93E+03 6.34E+01 3.23E+01 9.24E+04 ... (5 Replies)
Discussion started by: Zam_1234
5 Replies

10. Shell Programming and Scripting

To add multiple columns in csv file

Hi Guys, Can you help to add static values at the end of the csv file with headers input_file id,name 1,neo 2,pull Expected id,name,status,entry,g_id 1,neo,done,2019-11-01T07:14:23,pass 2,pull,done,2019-11-01T07:14:23,pass My try but not able replacing properly and unable... (1 Reply)
Discussion started by: Master_Mind
1 Replies
XIntersectRegion(3)						  XLIB FUNCTIONS					       XIntersectRegion(3)

NAME
XIntersectRegion, XUnionRegion, XUnionRectWithRegion, XSubtractRegion, XXorRegion, XOffsetRegion, XShrinkRegion - region arithmetic SYNTAX
int XIntersectRegion(Region sra, Region srb, Region dr_return); int XUnionRegion(Region sra, Region srb, Region dr_return); int XUnionRectWithRegion(XRectangle *rectangle, Region src_region, Region dest_region_return); int XSubtractRegion(Region sra, Region srb, Region dr_return); int XXorRegion(Region sra, Region srb, Region dr_return); int XOffsetRegion(Region r, int dx, int dy); int XShrinkRegion(Region r, int dx, int dy); ARGUMENTS
dest_region_return Returns the destination region. dr_return Returns the result of the computation. ds Dy move or shrink dx dy Specify the x and y coordinates, which define the amount you want to the specified region. r Specifies the region. rectangle Specifies the rectangle. sra srb Specify the two regions with which you want to perform the computation. src_region Specifies the source region to be used. DESCRIPTION
The XIntersectRegion function computes the intersection of two regions. The XUnionRegion function computes the union of two regions. The XUnionRectWithRegion function updates the destination region from a union of the specified rectangle and the specified source region. The XSubtractRegion function subtracts srb from sra and stores the results in dr_return. The XXorRegion function calculates the difference between the union and intersection of two regions. The XOffsetRegion function moves the specified region by a specified amount. The XShrinkRegion function reduces the specified region by a specified amount. Positive values shrink the size of the region, and negative values expand the region. SEE ALSO
XCreateRegion(3), XDrawRectangle(3), XEmptyRegion(3) Xlib - C Language X Interface X Version 11 libX11 1.6.0 XIntersectRegion(3)
All times are GMT -4. The time now is 09:36 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy