04-04-2013
Corona- the delimiter would be \t.
The query is being run in a tool(ETL_Abinitio).
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi, I am new in unix,
I just want to replace some values from text file according to column numbers. Like, I am having a table as given below:
val1 val2 val3 val4 val5
val6 val7 val8 val9
val10 val11 val12 val13
Now i want... (5 Replies)
Discussion started by: rish_max
5 Replies
2. UNIX for Advanced & Expert Users
I need to convert a password protected excel file which will be in UNIX server to a comma separated file. For this I need to open the excel file in UNIX box but the UNIX box doesn't prompt for password instead it is opened in an encrypted manner.
I could manually ftp the excel file to local... (2 Replies)
Discussion started by: Devivish
2 Replies
3. Shell Programming and Scripting
Hi,
I am having a business file in excel having charts based on data already present on it. I would like to add new rows after the existing data and refesh the chart on it using shell script.
For example--
In excel file in "sheet1", There is some data in first 10 rows ( from column A to F).... (0 Replies)
Discussion started by: sanjay1979
0 Replies
4. Shell Programming and Scripting
Hi
I have a excel file in unix machine and have to convert it into a .csv file.I have to do this from a unix script.How do we do this?
Thanks
Abhinav (3 Replies)
Discussion started by: akashtcs
3 Replies
5. Shell Programming and Scripting
Hi All,
Following is my requirement. I have searched the site and found some threads which has same queries, but non of them have any answer. I thought of posting it once more.
We are generating different reports through shell script after we finish our data load. Currently there are 7 such... (5 Replies)
Discussion started by: ace_friends22
5 Replies
6. Shell Programming and Scripting
Dear Members,
I am using the attached script to convert a input file delimited by '|' to excel.
However, while processing the attribute change_reason, the whole content of the text under change_reason is not displayed completely in the cell in excel. It is truncated after only first few words.... (1 Reply)
Discussion started by: Yoodit
1 Replies
7. Shell Programming and Scripting
Hi list,
This is probably something really simple, but I am not particularly familiar with Python so I thought I would ask as I know that python has an excel module.
I have an excel document with multiple tabs of data and graphs.
One of the tabs is just data which I require to have dumped to... (8 Replies)
Discussion started by: landossa
8 Replies
8. UNIX for Dummies Questions & Answers
Hi,
i have shell script which compiles n number of test cases and execute them one by one. i want to create report in excel through script in which two columns namely "test id" and "release".second column have two subcolumns namely compiles and excutes. so i want first column should display test... (15 Replies)
Discussion started by: RamMore123
15 Replies
9. Shell Programming and Scripting
I am using xls2csv to convert a xls file into a regular .csv file. However, while using the command as
xls2csv fromfile.xls > tofile.csv
I am getting the following error.
fromfile.xls is not OLE file or Error
I also tried to specify the comma as delimiter but did not help...
xls2csv -c\,... (7 Replies)
Discussion started by: dhruuv369
7 Replies
10. Shell Programming and Scripting
Hi Experts,
I am querying backup status results for multiple databases and getting each and every database result in one csv file. so i need to combine all csv files in one excel file with separate tabs. I am not familiar with perl script so i am using shell script.
Could anyone please... (4 Replies)
Discussion started by: ramakrk2
4 Replies
HISTO(1) General Commands Manual HISTO(1)
NAME
histo - compute 1-dimensional histogram of N data columns
SYNOPSIS
histo [-c][-p] xmin xmax nbins
histo [-c][-p] imin imax
DESCRIPTION
Histo bins columnular data on the standard input between the given minimum and maximum values. If three command line arguments are given,
the third is taken as the number of data bins between the first two real numbers. If only two arguments are given, they are both assumed
to be integers, and the number of data bins will be equal to their difference plus one. The bins are always of equal size.
The output is N+1 columns of data (for N columns input), where the first column is the centroid of each division, and each row corresponds
to the frequencies for each column around that value.
If the -c option is present, then histo computes the cumulative histogram for each column instead of the straight frequencies. The upper
value of each bin is printed also instead of the centroid. This may be useful in computing percentiles, for example. Values below the
minimum specified are still counted in the cumulative total.
The -p option tells histo to report the percentage of the total number of input lines rather than the absolute counts. In the case of a
cumulative total, this yields the percentile values directly. Values above the maximum are counted as well as values below in this case.
All input data is interpreted as real values, and columns must be white-space separated. If any value is less than the minimum or greater
than the maximum, it will be ignored unless the -c option is specified.
EXAMPLE
To count data values between -1 and 1 in 50 bins:
histo -1 1 50 < input.dat
To count frequencies of integers between 0 and 255:
histo 0 255 < input.dat
AUTHOR
Greg Ward
SEE ALSO
cnt(1), neaten(1), rcalc(1), rlam(1), tabfunc(1), total(1)
RADIANCE
9/6/96 HISTO(1)