05-30-2014
Inserting blank columns in already present CSV file
Hi,
i have a csv file which have headers and values of it like below :
PHP Code:
headers --> CI Ref SerialNumber LastScanDate
values --> VMware-42,VMware-42,Tue, 20 May 2014 11:03:44 +0000
i want to have a above csv in below format :
PHP Code:
headers --> CI Name CI Description CI Ref SerialNumber LastScanDate abc
values --> <blank>,<blank>,VMware-42,VMware-42,20 May 2014 11:03:44 +0000,<blank>
basically to add columns with specific headers wnd blank or null value in between .
request you to provide some hint or help.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello all,
I have these 2 files
File1
123 100
456 200
789 300
File2
|1|2|3||4|5||6|
|1|2|3||4|5||6|
|1|2|3||4|5||6|
I need an output like :
|1|2|3|123|4|5|100|6|
|1|2|3|456|4|5|200|6|
|1|2|3|789|4|5|300|6| (3 Replies)
Discussion started by: rany1
3 Replies
2. Shell Programming and Scripting
Hi,
I need help to remove blank rows at the end of file.
Sample data:
"Oslo, Symra kino",Oslo,130-7,Symra 1,130-7-91
"Tønsberg, Brygga Kino SF",Tønsberg,202-1,Tønsberg SF 4,202-1-4
,,,,
,,,,
,,,,
,,,,
Expected data:
"Oslo, Symra kino",Oslo,130-7,Symra 1,130-7-91
"Tønsberg, Brygga... (6 Replies)
Discussion started by: cnraja
6 Replies
3. 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
4. Shell Programming and Scripting
Hello
I have a csv file which I need to insert addtional commas into. The csv is of the format
field1,field2,field3,field4,...etc...,field13,field14
I need to add extra commas in each record so that the final output looks like
... (1 Reply)
Discussion started by: kamal_p_99
1 Replies
5. 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
6. Shell Programming and Scripting
hi
I have a csv file with few rows
> cat job_stat
1,jobname1,somthing,somthing
2,jobname2,somthing,somthing
3,jobname3,somthing,somthing
4,jobname4,somthing,somthing
I want to add few columns after the 2nd column and then append rest of the columns after the 3rd newly added... (3 Replies)
Discussion started by: midhun19
3 Replies
7. Shell Programming and Scripting
Hi Tech Guru,
I have a test file as below , which needs some more fields to be populated randomly :
dks3243;12;20130823;1420;25m;0;syt
dks3243;rocy;10
dks3243;kiop;18
sde21p4;77;20151210;8479;7py;9;vfr
sde21p4;temp;67
sfq6i01;12;20120123;3412;4rd;7;jui
sfq6i01;uymk;90
sfq6i01;kiop;51
... (8 Replies)
Discussion started by: Lokesha
8 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
I'm monitoring a WLAN network to keep track of new SSIDs popping up. The SSIDs are stored along with the AP MAC address and a few other parameters in a CSV file. A typical line could look like this:
18:70:9f:e3:80:aa 10:11:15 MyNetwork 2437
Now, the problem is that some networks use SSIDs... (4 Replies)
Discussion started by: Zooma
4 Replies
10. UNIX for Beginners Questions & Answers
Hi there,
I am having this problem:
a) I am uploading a txt file from windows (notepad) with some Gaussian 09 command lines;
b) Gaussian needs in certain command files, that those files have a blank line at the end of the file!
c) I open the command file with vi and no blank line at the of... (2 Replies)
Discussion started by: luismga
2 Replies
LEARN ABOUT CENTOS
vmmouse_detect
vmmouse_detect(1) General Commands Manual vmmouse_detect(1)
NAME
vmmouse_detect - VMware mouse device autodetection tool
SYNOPSIS
vmmouse_detect
OPTIONS
vmmouse_detect has no options
DESCRIPTION
vmmouse_detect is a tool for detecting if running in a VMware environment where vmmouse is used. It exits with a 0 return value if the
vmmouse client is enabled, and 1 if not.
DIAGNOSTICS
vmmouse_detect's exit status is used to communicate information.
0 vmmouse_detect found a mouse and exited normally.
1 Either the vmmouse client was not enabled, or it is not being run from within a VMware virtual machine.
BUGS
Please report bugs in vmmouse_detect <https://bugs.launchpad.net/ubuntu/+source/mdetect/vmmouse_detect>.
AUTHORS
vmmouse_detect is copyright 2007 VMware, Inc.
LICENSING
The vmmouse_detect source code is licensed under a BSD-like license. See COPYING for details.
This manual page is licensed under the GNU General Public License.
SEE ALSO
mdetect(1), XFree86(1)
X Version 11 xf86-input-vmmouse 13.0.0 vmmouse_detect(1)