Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Sort and compare file
Top Forums Shell Programming and Scripting Sort and compare file Post 302069555 by sabercats on Monday 27th of March 2006 01:07:29 PM
Old 03-27-2006
Sort and compare file
If I have 3 kinds of files in directory DATA1:
FileA.20060315.dat, FileB.20060315.dat, FileC.20060315.dat
FileC.20060316.dat
FileA.20060317.dat, FileB.20060317.dat
FileA.20060318.dat, FileB.20060318.dat, FileC.20060318.dat

If 3 files have the same date then run
$cat FileA.20060315.dat FileB.20060315.dat FileC.20060315.dat > FileD.20060315.dat and move these files to DATA2 .

if it doesnot have 3 files the same date then move it to DATA3 ???
How do you know what date to choose ?

Code:
#!/bin/ksh
cd  ./DATA1

for file in *.dat; do
ls -1 $file|awk -F"-" '{
        filedt = substr($2,1,8);
        {
    printf "%s\n",filedt
  }
        }'  >> checkit;
done
cat checkit | sort -n |uniq > date.srt

20060315
20060316
20060317
20060318
I get file sort by date then how I check date by date ? do you know ?
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Why do we use sort before compare ?

Dear All. Im trying to know how exactly the command "compare" works, does it compare line by line or field by field, and the most important thing is that why the files have to be sorted before we compare them? Thanks in advance (7 Replies)
Discussion started by: yahyaaa
7 Replies

2. UNIX for Dummies Questions & Answers

sort and compare files

Hi, I have around 14-15 files and i want to sort all the files and then compare. I dont want to sort them and store in a different file and then compare. I want to compare two files at a time. Is there a way we can do this using a single command? (5 Replies)
Discussion started by: dnat
5 Replies

3. UNIX for Advanced & Expert Users

Script to sort the files and append the extension .sort to the sorted version of the file

Hello all - I am to this forum and fairly new in learning unix and finding some difficulty in preparing a small shell script. I am trying to make script to sort all the files given by user as input (either the exact full name of the file or say the files matching the criteria like all files... (3 Replies)
Discussion started by: pankaj80
3 Replies

4. Shell Programming and Scripting

comm command -- Sort and compare two files

Team, I have two files and I am trying to find the lines unique to file1. So i have executed the below command at shell prompt and got the correct results comm -23 <(sort test) <(sort test1) When i run the same command in Bash shell script, i got the correct results. But when i run... (5 Replies)
Discussion started by: forums123456
5 Replies

5. Shell Programming and Scripting

Sort help: How to sort collected 'file list' by date stamp :

Hi Experts, I have a filelist collected from another server , now want to sort the output using date/time stamp filed. - Filed 6, 7,8 are showing the date/time/stamp. Here is the input: #---------------------------------------------------------------------- -rw------- 1 root ... (3 Replies)
Discussion started by: rveri
3 Replies

6. Shell Programming and Scripting

How to sort and compare files in more efficient manner?

Hello All, Iam using below method to sort and compare files. First iam doing sorting and changing the same file and then doing comparing and taking the final result to another file. sort -o temp.txt file1 mv temp.txt file1 sort -o temp.txt file2 mv temp.txt file2 sort -o temp.txt... (6 Replies)
Discussion started by: Vikram_Tanwar12
6 Replies

7. Shell Programming and Scripting

UNIX compare, sort lines and append difference

Hi, I have a file that needs to be converted: content is: a, b, 4 a ,b, 5 x, y, 1 a, b, 1 x, y, 3 how can i get: a, b, 1|4|5 x,y 1|3 (1 Reply)
Discussion started by: nike27
1 Replies

8. Shell Programming and Scripting

UNIX compare, sort lines and append difference

To make it easier, i gave following example. It is not homework or classwork. Instead, i have a huge csv file dump from tsql with 15 columns and around 300 rows. I was able to extract content that needs to be really converted. Here is the extract: ES FP,B1ES FP,70000,I,SL22,SL22 (70000) ES... (0 Replies)
Discussion started by: nike27
0 Replies

9. Shell Programming and Scripting

UNIX compare, sort lines and append difference

To make it easier, i gave following example. It is not homework or classwork. Instead, i have a huge csv file dump from tsql with 15 columns and around 300 rows. I was able to extract content that needs to be really converted. Here is the extract: ES FP,B1ES FP,70000,I,SL22,SL22 (70000) ES... (8 Replies)
Discussion started by: nike27
8 Replies

10. UNIX for Beginners Questions & Answers

Sort by record column, Compare with conditons and export the result

Hello, I am new to Unix and would like to seek a help, please. I have 2 files (file_1 and file_2), I need to perform the following actions. 1 ) Sort the both file by the column 26-36 (which is Invoice number) what is sort command with the column sort? 2) Compare the file_1.sorted and... (3 Replies)
Discussion started by: Usagi
3 Replies

LEARN ABOUT DEBIAN

g_principal

g_principal(1)					 GROMACS suite, VERSION 4.5.4-dev-20110404-bc5695c				    g_principal(1)

NAME

       g_principal - calculates axes of inertia for a group of atoms

       VERSION 4.5.4-dev-20110404-bc5695c

SYNOPSIS

       g_principal  -f	traj.xtc  -s topol.tpr -n index.ndx -a1 axis1.dat -a2 axis2.dat -a3 axis3.dat -om moi.dat -[no]h -[no]version -nice int -b
       time -e time -dt time -tu enum -[no]w -[no]foo

DESCRIPTION

	g_principal calculates the three principal axes of inertia for a group of atoms.

FILES

       -f traj.xtc Input
	Trajectory: xtc trr trj gro g96 pdb cpt

       -s topol.tpr Input
	Structure+mass(db): tpr tpb tpa gro g96 pdb

       -n index.ndx Input, Opt.
	Index file

       -a1 axis1.dat Output
	Generic data file

       -a2 axis2.dat Output
	Generic data file

       -a3 axis3.dat Output
	Generic data file

       -om moi.dat Output
	Generic data file

OTHER OPTIONS

       -[no]hno
	Print help info and quit

       -[no]versionno
	Print version info and quit

       -nice int 19
	Set the nicelevel

       -b time 0
	First frame (ps) to read from trajectory

       -e time 0
	Last frame (ps) to read from trajectory

       -dt time 0
	Only use frame when t MOD dt = first time (ps)

       -tu enum ps
	Time unit:  fs,  ps,  ns,  us,	ms or  s

       -[no]wno
	View output  .xvg,  .xpm,  .eps and  .pdb files

       -[no]foono
	Dummy option to avoid empty array

SEE ALSO

       gromacs(7)

       More information about GROMACS is available at <http://www.gromacs.org/>.

								  Mon 4 Apr 2011						    g_principal(1)
All times are GMT -4. The time now is 08:54 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy