i have single column which is starting with same string(many number of rows)
i have to convert each into a single row.how can i do that?
laknar
std
mes
23
55
laknar
isd
phone no
address
amount
99
I have to convert above like below.
laknar|std|mes|23|55
laknar|isd|phone... (3 Replies)
Hi all,
I need to convert this file having just one column into two column file
current file:
a
15
b
21
c
34
d
48
e
10
wanted:
a 15
b 21
c 34 (15 Replies)
i have output of script as below
name,roll_no,01-05-12,02-05-12,03-05-12
sam,12,24,24,24
jon,145,24,24,22
van,29,24,22,24
i want to convert these into columns as output is not fixed please tell me how to convert 1st row in to 1st columns likewise,as many rows are there are to be converted... (4 Replies)
Hi gurus!
Please help me with this one. I have an file with the following contents:
a
b
c
d
e
f
g
h
i
j
I would like to make to transform it to look like this as my output file:
a,b,c
d,e,f (4 Replies)
Hi,
Can anyone suggest quick way to get desired output?
Sample input file content:
A 12 9
A -0.3 2.3
B 1.0 -4
C 34 1000
C -111 900
C 99 0.09
Output required:
A 12 9 -0.3 2.3
B 1.0 -4
C 34 1000 -111 900 99 0.09
Thanks (3 Replies)
Hi All,
My requisite is to split a single column of phonemes seperated by spaces into multiple rows.
my input file is:
a
dh
u
th
a
qn
ch
A
v
U
r
k
my o/p should be like:
adhu a dh u (3 Replies)
How to change the uploaded weekly file data to the following format?
New Well_Id,Old Well_Id,District,Thana,Date,Data,R.L,WellType,Lati.,Longi.
BAG001,PT006,BARGUNA,AMTALI,1/2/1978,1.81,2.29,Piezometer,220825,901430
BAG001,PT006,BARGUNA,AMTALI,1/9/1978,1.87,2.29,Piezometer,220825,901430... (3 Replies)
Hi,
I want to convert a single row values to multiple rows, but the no. of rows are not fixed.
For example, I have a row as below
abc-def-lmn-mno-xyz
out put should be
get abc
get def
get lmn
get xyz (4 Replies)
Hi .. anyone can you help me ?
i need to convert text below into multiple columns
interface; GigabitEthernet0/0/0/0
description; TRUNK_PE-D2-JT2-VPN_Gi0/0/0/0_TO_ME4-A-JKT-JT_4/1/1_1G
mtu 9212
negotiation auto
interface; GigabitEthernet0/0/0/0.11
description; tes
encapsulation;... (1 Reply)
Discussion started by: mad3linux
1 Replies
LEARN ABOUT DEBIAN
fitsort
fitsort(1) General Commands Manual fitsort(1)NAME
fitsort - sort FITS header information from a list of files
SYNOPSIS
dfits <FITS files...> | fitsort <FITS keywords...>
DESCRIPTION
fitsort extract keyword values from a set of FITS headers and outputs it in an ASCII table format, which is compatible with most data pro-
cessing software packages. It shall only be used in combination with the dfits utility.
The ASCII output is shown in columns. Columns are aligned with blank characters and also separated by tabulations. Blank alignment allows
human readers to visualize the output in a pretty format, tabulations are there for spreadsheet compatibility. If you want to load out fit-
sort output into any spreadsheet, specify that fields shall be separated by tabulations and entries separated by linefeeds.
Examples :
dfits *.fits | fitsort BITPIX NAXIS NAXIS1 NAXIS2
The output would look like:
FILE BITPIX NAXIS NAXIS1 NAXIS2
file0001.fits 16 2 128 128
file0002.fits 32 2 512 512
...
ESO specific features in the FITS header are also supported. To get values for 'HIERARCH ESO' keywords, just give the complete names within
double quotes. e.g.
dfits *.fits | fitsort "HIERARCH ESO INS LENS"
Another way of giving HIERARCH ESO keywords is to use the short FITS notation, the above example can be given as:
dfits *.fits | fitsort INS.LENS
Example: to retrieve the DPR keywords from an ESO FITS header, you would use:
dfits *.fits | fitsort To be completed... DPR.CATG DPR.TYPE DPR.TECH
This second way of requesting HIERARCH ESO keywords is not only shorter to type, it also avoids typing quotes or double-quotes on the com-
mand-line, making it easier to script with fitsort.
Notice that the keywords you give on the command-line are case-insensitive. The above line is equivalent to:
dfits *.fits | fitsort dpr.catg dpr.type dpr.tech
OPTIONS -d Do not print out the first output line. This option is useful to get only the query results, without the top line (giving all column
names). This makes it easy to script fitsort from programs like awk or perl.
FILES
Input files to dfits shall all comply with FITS format. fitsort also supports HIERARCH ESO FITS format.
SEE ALSO
dfits (1)
25 Jun 2001 fitsort(1)