|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
How to write text file data to excel using UNIX shell script?
Post 302825325 by Balasankar on Monday 24th of June 2013 05:52:37 AM
06-24-2013
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
Can any one tell me how to put data using shell script to a excel file from text file to other columns of excel file,leaving first column unaffected i.e it should not overwrite data in first column.
Say my text file data is:
15-dec-2008 15-dec-2009
16-dec-2008 16-dec-2009
say my first... (1 Reply)
Discussion started by: siri_886
1 Replies
2. UNIX for Advanced & Expert Users
Hi.
I wish to add data in a specific excel file on daily basis.However the currect dat's data should always come on top i.e for example should always occupy cell A7,B7,C7 ..
and the data of day before which was earlier on 7th row of each coloumn should move to 8th row..data on 8th row should... (1 Reply)
Discussion started by: kanus
1 Replies
3. Shell Programming and Scripting
hi,
i have a text file that looks like this!
i want to generate an excel sheet out of it, removing all the junk data except the addresses
that look like
. Arrow Electrical Services
Rotating Machinery, Electrical Contracting & Mining Specialists
Onsite maintenance, breakdown... (8 Replies)
Discussion started by: vemkiran
8 Replies
4. Shell Programming and Scripting
Hi,
Please help me on this.
I want to insert data from text file to excel using shell script
nawk -v r=4 -v c=4 -v val=$a -F, 'BEGIN{OFS=","}; NR != r; NR == r {$c = val; print}' "file.csv"
I used above one to insert $a value in 4th row, 4th column in an excel file.csv and it... (3 Replies)
Discussion started by: suman.frnz
3 Replies
5. Shell Programming and Scripting
Please share the doc asap as very urgently required. (1 Reply)
Discussion started by: 24ajay
1 Replies
6. Shell Programming and Scripting
Hi,
I want to write a program to copy a log file to Excel sheet. Excel sheet has four columns MethodName , Code , Description, Details and Time.
I want to pick these info from text file and put it in excel sheet.
here is how the text file looks -
04.17.2014 08:06:12,697... (1 Reply)
Discussion started by: hershey
1 Replies
7. Shell Programming and Scripting
Hi ,
i am generating some data by firing sql query with connecting to the database by my solaris box.
The below one should be the header line of my excel ,here its coming in separate row.
TO_CHAR(C. CURR_EMP_NO
---------- ---------------
LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies
8. Shell Programming and Scripting
Hi Everyone,
I want your help to write a script which will take text file as input and on the basis of delimiter ":"script will create excel sheet.
Example input:
IpAdress:InstanceName:Port:ServerName
10.255.255.1:abc:2232:xyz_abc
Output should be an excel sheet like below:
Column... (8 Replies)
Discussion started by: akabhinav18
8 Replies
9. Shell Programming and Scripting
I have input data looks like this which is a part of a csv file
7,1265,76548,"0102:04"
8,1266,76545,"0112:04"
I need to make the output data should look like this and the output data will be part of text file:
7|1265000 |7654899 |A|
8|12660000 |76545999 |B|
The logic behind the... (6 Replies)
Discussion started by: RJG
6 Replies
10. UNIX for Beginners Questions & Answers
Source Code of the original script is down below please run the script and try to solve this problem
this is my data and I want it column wise
2019-03-20 13:00:00:000
2019-03-20 15:00:00:000
1
Operating System
LAB
0
1
1
1
1
1
1
1
1
1
0
1 (5 Replies)
Discussion started by: Shubham1182
5 Replies
LEARN ABOUT PHP
pvdisplay
PVDISPLAY(8) System Manager's Manual PVDISPLAY(8) NAME
pvdisplay - display attributes of a physical volume SYNOPSIS
pvdisplay [-c|--colon] [-d|--debug] [-h|-?|--help] [--ignorelockingfailure] [--maps] [--nosuffix] [-s|--short] [--units hsbkmgtHKMGT] [-v[v]|--verbose [--verbose]] [--version] [PhysicalVolumePath [PhysicalVolumePath...]] pvdisplay --columns | -C [--aligned] [-a|--all] [-d|--debug] [-h|-?|--help] [--ignorelockingfailure] [--noheadings] [--nosuffix] [-o|--options [+]Field[,Field]] [-O|--sort [+|-]Key1[,[+|-]Key2[,...]]] [--separator Separator] [--unbuffered] [--units hHbBsSkKmMg- GtTpPeE] [-v[v]|--verbose [--verbose]] [--version] [PhysicalVolumePath [PhysicalVolumePath...]] DESCRIPTION
pvdisplay allows you to see the attributes of one or more physical volumes like size, physical extent size, space used for the volume group descriptor area and so on. pvs (8) is an alternative that provides the same information in the style of ps (1). OPTIONS
See lvm for common options and pvs for options given with --columns. -c, --colon Generate colon separated output for easier parsing in scripts or programs. N.B. pvs (8) provides considerably more control over the output. The values are: * physical volume device name * volume group name * physical volume size in kilobytes * internal physical volume number (obsolete) * physical volume status * physical volume (not) allocatable * current number of logical volumes on this physical volume * physical extent size in kilobytes * total number of physical extents * free number of physical extents * allocated number of physical extents -s, --short Only display the size of the given physical volumes. -m, --maps Display the mapping of physical extents to logical volumes and logical extents. --columns | -C Display output in columns, the equivalent of pvs (8). See pvs (8) for a description of other options with this form of pvdisplay. SEE ALSO
lvm(8), pvcreate(8), lvcreate(8), vgcreate(8) Sistina Software UK LVM TOOLS 2.02.95(2) (2012-03-06) PVDISPLAY(8)