Add Empty columns at the end of csv file Post: 302421075

Sponsored Content

Top Forums Shell Programming and Scripting Add Empty columns at the end of csv file Post 302421075 by Tushar Bendale on Thursday 13th of May 2010 10:23:39 AM

05-13-2010

Registered User

Thanks for your valuable inputs. I guess the csv file where I want to add empty columns at the end, contails a new line character at the end.

See below the input file format:
-> more test.csv

Code:

Object Type,Object Subtype,Object Name,CEMLI Type,Owner,Location,Created By, Creation Date, Updated By, Update Date, LastRecorded Usage
DB_OBJECT,ALERT,@GEPSAlphaPOSOEAInotification,CONFIGURATION,FND,ALR_ALERTS,CONCURRENT_MGR,10-Feb-10,CONCURRENT_MGR,test,

-> awk -F, '{NF=41}1' OFS="," test.csv > result.csv
-> more result.csv
Object Type,Object Subtype,Object Name,CEMLI Type,Owner,Location,Created By, Creation Date, Updated By, Update Date, LastRecorded Usage
, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,
DB_OBJECT,ALERT,@GEPSAlphaPOSOEAInotification,CONFIGURATION,FND,ALR_ALERTS,CONCURRENT_MGR,10-Feb-10,CONCURRENT_MGR,test,
, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

Is it possible to add those empty columns in between the last field seprator and new line characher?

Last edited by Scott; 05-13-2010 at 11:30 AM.. Reason: Code tags, please...

Tushar Bendale

View Public Profile for Tushar Bendale

Find all posts by Tushar Bendale

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...

2. UNIX for Dummies Questions & Answers

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 ...

3. Shell Programming and Scripting

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 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...

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 :...

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,...

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...

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...

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...

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 ...

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...

LEARN ABOUT CENTOS

object

Object(library call)													      Object(library call)

NAME

       Object -- The Object widget class

SYNOPSIS

       #include <Xm/Xm.h>

DESCRIPTION

       Object is never instantiated.  Its sole purpose is as a supporting superclass for other widget classes.

   Classes
       The class pointer is objectClass.

       The class name is Object.

   New Resources
       The following table defines a set of widget resources used by the programmer to specify data. The programmer can also set the resource val-
       ues for the inherited classes to set attributes for this widget. To reference a resource by name or by class in a .Xdefaults  file,  remove
       the  XmN  or XmC prefix and use the remaining letters. To specify one of the defined values for a resource in a .Xdefaults file, remove the
       Xm prefix and use the remaining letters (in either lowercase or uppercase, but include any underscores between words).  The  codes  in  the
       access  column indicate if the given resource can be set at creation time (C), set by using XtSetValues (S), retrieved by using XtGetValues
       (G), or is not applicable (N/A).

       +---------------------------------------------------------------------+
       |		   |	Object Resource Set	  |	    |	     |
       |Name		   | Class	 | Type 	  | Default | Access |
       +-------------------+-------------+----------------+---------+--------+
       |XmNdestroyCallback | XmCCallback | XtCallbackList | NULL    | C      |
       +-------------------+-------------+----------------+---------+--------+
       +-------------------+-------------+----------------+---------+--------+
       XmNdestroyCallback
		 Specifies a list of callbacks that is called when the gadget is destroyed.

   Translations
       There are no translation for Object.

															      Object(library call)