Hi
It is enough with one digit decimal. but in some of the files , there is two digit decimal for e.g. in one of the file the first is 11200.45 then the others in the first column is no decimal or in between there is a decimal.. if the file is as following :
the "." is for decimal ...
If you continue to refuse to show sample input, sample output, and sample code segments in CODE tags, you will eventually be banned from using this site.
Please review the forum rules you agreed to when you joined this site and format your posts properly instead of depending on forum moderators and administrators to clean up your posts for you!
I do not yet understand how the input you are processing is supposed to be converted into the output you want. Explain what output should be produced by showing us (in CODE tags) the exact output that should be produced for the following input AND by stating the rules (in English) that explain the logic your script is supposed to use to determine why that is the output it should produced from that given input:
Code:
11200.45 abc 400 1 name2 original
11200.45 abc 400 1 name2 update 1
11200.45 abc 400 1 name2 update 2
11204 abc 230 1 name
11204 abc 230 1 name
11204 abc 230 1 name
11204.01 abc 230 1 name
11204.01 abc 230 1 name
11204.01 abc 230 1 name
11204.02 abc 230 1 name
11204.02 abc 230 1 name
11204.02 abc 230 1 name
11204.1 abb 350 2 name
11204.1 abb 350 2 name
11204.10 abc 230 1 name
11204.10 abc 230 1 name
11500 abc 400 1 name2
11600 ... .............
11632 .... ..... . ......... original
11632 .... ..... . ......... update 1
11632 .... ..... . ......... update 2
11632.01 .... ..... . ......... original
11632.01 .... ..... . ......... update 1
11632.01 .... ..... . ......... update 2
11632 02 .... ..... . ......... original
11632.02 .... ..... . ......... update 1
11632.02 .... ..... . ......... update 2
11632.1 ..... original
11632.1 ..... update 1
11632.11 .... original
11632.11 .... update 1
11632.2 ... original
11900
12000
Hello,
I have a header which I have to add to a sorted file, however if I use
cat header sortedfile > newfile, the operation takes 2 minutes as the sorted file is over 400mb.
I have noticed that when I sort the 400mb unsorted file, this only takes 14 seconds to create the output.
As... (2 Replies)
So, I have a file that has some duplicate lines. The file has a header line that I would like to keep at the top.
I could do this by extracting the header from the file, 'sort -u' the remaining lines, and recombine them. But they are quite big, so if there is a way to do it with a single... (1 Reply)
Hi,
Please help with this problem. Somehow does not work for me.
test.txt
CHR SNP BP A1 C_A C_U A2 CHISQ P OR
19 rs10401969 19268718 C 222 890 T 0.03462 0.8524 0.9857
1 rs10873889 ... (4 Replies)
Hi Experts,
I want to Sort the data in fixed width file where i have Header and Footer also in file.
I m using below commad to do the sort based on field satarting from 15 position to 17 position , but it is not ignoring the Header and Footer of the file while sorting. In the output i am... (5 Replies)
I am having report file with header and footer . The details in between header and footer are separated by a pipe charater. I want to sort the file by considering multiple columns in between header and footer.
pls help (4 Replies)
How to sort a tab delimited file first on col1 and then on col2. Also I need to keep the header intact.
file.txt
val1 val2 val3 val4
a b c d
m n o p
e f g h
i j k l
... (3 Replies)
Hi,
I'm trying to sort 2 different .txt tab delimited files with the command line:
sort -k 1b,1 inputfile > outputfile
But doing that i'm also sorting the header (that ends at the end of my file).
How can i sort a .txt file without sorting the header but conserving the header in the... (3 Replies)
I have several las files with a header and each file start Version and text and before the data starts end up with ~Ascii, then the numbers starts:
-------------------------------------------------------------------------
Code:
~Version
.....text....
~Ascii
2 abc 230 1 name
1 abc ... (1 Reply)
Hi,
I am using SUN SOLARIS (SunOS sun4v sparc SUNW, T5240).
I have a huge data file with header and trailer. This file gets used into an ETL process. ETL skips the header record (which is the first record of the file) and loads the rest of the record. The file can be delimited (comma,... (5 Replies)
Hi ,
My UNIX system is SUN Solaris.
I am trying to do a simple thing as described below.
I have a PIPE delimited file that has header and trailer. So the file is something like below:
Test1.txt looks like something below:
field_data1|field_data2|and some more data --Header
... (5 Replies)
09-16-2015
