03-20-2019
Provide required input and output to help you
This User Gave Thanks to Jairaj For This Post:
10 More Discussions You Might Find Interesting
1. Windows & DOS: Issues & Discussions
Hi
I have some data in my Excel File.However all the data is in one single column.I want to split it into two columns.
Current Data:
1,Hi Everyone,I am
7,New To Dos,And
17,VB Script,i could
110,have tried this thing
1800,in UNIX
Desired Output
CELL1|CELL 2
1 |Hi... (3 Replies)
Discussion started by: dashing201
3 Replies
2. Shell Programming and Scripting
Hi all,
i have data like this
joe : 1 :a
bob : 2 :b
sue : 3 :c
foo : 4 :d
at column 2 i want to insert TOP to the top column and at column 3 i want to insert BOTTOM to the bottom column. and the result will... (12 Replies)
Discussion started by: psychop13
12 Replies
3. Shell Programming and Scripting
Can anyone please help with this? I have 2 files as given below.
If 2nd column of file1 has pattern foo1@a, find the matching 1st column in file2 & replace 2nd column of file1 with file2's value.
file1
abc_1 foo1@a ....
abc_1 soo2@a ...
def_2 soo2@a ....
def_2 foo1@a ........ (7 Replies)
Discussion started by: prashali
7 Replies
4. UNIX for Advanced & Expert Users
Hi,
I want to convert a 3-column data to 3-row data using shell script. Any suggestion in this regard is highly appreciated.
Thanks. (4 Replies)
Discussion started by: sktkpl
4 Replies
5. Shell Programming and Scripting
Hi All, found similar posts, but not exatcly what i wanted.
I have an text file like below and am trying to send mail as an excel file but when i get the excel file as the attachment, all the data is coming in the first column. I need below data in 4 columns.
Unix file
Name,ID,Trade,Date... (3 Replies)
Discussion started by: robinbannis
3 Replies
6. Shell Programming and Scripting
Dear Team
I need to insert field(which is need to taken from previous line's first field) in first column if its blank. I had tried using sed but not find the way. Detail input and output file as below.
Kindly help for same.
INPUT:
SCGR SC DEV DEV1 NUMDEV DCP ... (7 Replies)
Discussion started by: jaydeep_sadaria
7 Replies
7. UNIX for Dummies Questions & Answers
HI Guys,
Input :- P081 wr1 12p0d5: 22.8
P081 wr1 12p2d18: 23.1
P149 wr1 1pxcud6/port_0_dev_7: 20.4
P149 wr1 1pxcud4/port_1_dev_10: 22.4
OutputP081 wr1 120 22.8
P081 wr1 122 23.1
P149 wr1 10 20.4
P149 wr1 11 22.4
In in First two line delete p and after d untill :
In Last two line... (4 Replies)
Discussion started by: pareshkp
4 Replies
8. Shell Programming and Scripting
Hi all
I am new to shell scripting. I need to read the 1st column and last of the excel file in linux environment.
Can some one help me with examples (3 Replies)
Discussion started by: Vigneshj28
3 Replies
9. Programming
Is there a way to append an existing xlsx worksheet to add data from a text file ?
I have an excel file for which I need to manipulate the first worksheet based on a text file.
I match the text file to the xlsx and write the 'Scores' column in the xlsx sheet and save the workbook.
For those ... (43 Replies)
Discussion started by: nans
43 Replies
10. UNIX for Beginners Questions & Answers
I have data of an excel files as given below,
file1
org1_1 1 1 2.5 100
org1_2 1 2 5.5 98
org1_3 1 3 7.2 88
file2
org2_1 1 1 2.5 100
org2_2 1 2 5.5 56
org2_3 1 3 7.2 70
I have multiple excel files as above shown.
I have to copy column 1, column 4 and paste into a new excel file as... (26 Replies)
Discussion started by: dineshkumarsrk
26 Replies
LEARN ABOUT DEBIAN
cfetoolinfo
CFETOOLINFO(8) User Contributed Perl Documentation CFETOOLINFO(8)
NAME
cfetoolinfo - Get information about a database
SYNOPSIS
cfetool info name [--path|-p directory name] [--daily|-d] [--weekly|-w] [--yearly|-y] [--verbose|-v] [--help|-h]
DESCRIPTION
Prints out some basic information about the specified database, including: the location of the database, the location of the histogram file
(if there is one), the step interval, the database age, the time it was last updated, and the current overall average and variation.
OPTIONS
--path|-p directory name
The directory in which to find the database folder. If this argument is not provided, the current working directory will be assumed.
--daily|-d
Provide information about the daily averages database.
--weekly|-w
Provide information about the weekly averages database.
--yearly|-y
Provide information about the yearly averages database.
--verbose|-v
Print details of the command's execution to the standard output stream.
--help|-h
Prints a short help message and then exits.
EXAMPLE
% cfetool info temperature --path /my/path
Weekly average database:
Database Location: /my/path/temperature/weekly.db
Histogram file: /my/path/temperature/weekly.hist
Step: 10 minutes
Database Age: 0.000992 weeks (1 steps)
Last update: Mon Sep 13 16:20:40 2004 (1095117640)
Current average: 7.105000, Var: 38.280217
AUTHORS
The code and documentation were contributed by Stanford Linear Accelerator Center, a department of Stanford University. This documentation
was written by
Elizabeth Cassell <e_a_c@mailsnare.net> and
Alf Wachsmann <alfw@slac.stanford.edu>
COPYRIGHT AND DISCLAIMER
Copyright 2004 Alf Wachsmann <alfw@slac.stanford.edu> and
Elizabeth Cassell <e_a_c@mailsnare.net>
All rights reserved.
perl v5.8.4 2004-09-21 CFETOOLINFO(8)