|
|
Sponsored Content
Top Forums
UNIX for Dummies Questions & Answers
joining files with different rows and colum
Post 302316110 by ghostdog74 on Thursday 14th of May 2009 05:28:42 AM
05-14-2009
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I have two files that I need to find difference between. Do I use diff or join? If join, how do I use it?
thanks,
webtekie (1 Reply)
Discussion started by: webtekie
1 Replies
2. UNIX for Dummies Questions & Answers
Hi,
Could anyone help me ?
I'm trying to join two files, but no common field are on them. So I think on generate \000\ sequence to add for each line on both files, so then will be able to join these files.
Any idea?
Thanks in advance, (2 Replies)
Discussion started by: Manu
2 Replies
3. Shell Programming and Scripting
Greetings, all. I've got a project that requires I join two data files together, then do some processing and output. Everything must be done in a shell script, using standard unix tools. The files look like the following:
File_1
Layout:
Acct#,Subacct#,Descrip
Sample:
... (3 Replies)
Discussion started by: rjlohman
3 Replies
4. Shell Programming and Scripting
I have many text file reports generated by a Information Assurance tool that I need to get into a .CSV format or Excel tab delimited format. I want to use sed or awk to grab all the information in the sample text file below and create column headings:Risk ID, Risk Level, Category, Description, How... (5 Replies)
Discussion started by: Bjoeboo
5 Replies
5. Shell Programming and Scripting
Hi Guys,
I need help in modifying a large text file containing more than 1-2 lakh rows of data using unix commands. I am quite new to the unix language
the text file contains data in a pipe delimited format
sdfsdfs
sdfsdfsd
START_ROW
sdfsd|sdfsdfsd|sdfsdfasdf|sdfsadf|sdfasdf... (9 Replies)
Discussion started by: manish2009
9 Replies
6. Shell Programming and Scripting
i have three files
file a has contents
123
234
238
file b has contents
189
567
567
and file c has contents
qwe
ert
ery (1 Reply)
Discussion started by: tomjones
1 Replies
7. UNIX for Dummies Questions & Answers
I have two comma separated files.
I want to join those filesa nd put the result in separate file.
smaple data are:
file1:
A1,1,100
A2,1,200
B1,2,100
B2,2,200
file2
1,50
1,25
1,25
1,100
1,100
2,50
2,50 (10 Replies)
Discussion started by: pandeesh
10 Replies
8. Shell Programming and Scripting
Hi,
I have about 20 tab delimited text files that have non sequential numbering such as:
UCD2.summary.txt
UCD45.summary.txt
UCD56.summery.txt
The first column of each file has the same number of lines and content. The next 2 column have data points:
i.e UCD2.summary.txt:
a 8.9 ... (8 Replies)
Discussion started by: rrdavis
8 Replies
9. Shell Programming and Scripting
File "A" (column names: Nickname Number GB)
Nickname Number GB
PROD_DB0034 100A 16
ASMIL1B_DATA_003 100B 16
PSPROD_0000 1014 36
PSPROD_0001 100D 223
.....
File "B" (column names: TYPE DEVICE NUMBER SIZE)
TYPE DEVICE NUMBER SIZE
1750500 hdisk2 100A 16384
1750500 hdisk3 ... (4 Replies)
Discussion started by: Daniel Gate
4 Replies
10. Shell Programming and Scripting
I have two files with the below contents :
sampleoutput3.txt
20150202;hostname1
20150223;hostname2
20150716;hostname3
sampleoutput1.txt
hostname;packages_out_of_date;errata_out_of_date;
hostname1;11;0;
hostnamea;12;0;
hostnameb;11;0;
hostnamec;95;38;
hostnamed;440;358;... (2 Replies)
Discussion started by: rahul2662
2 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)