11-24-2011
Quote:
Originally Posted by
Shell_Life
Can you display a sample of your final output?
I have, it's the second box down in my post. I've only given one of each record type as I have to manually obfuscate the data for each line that I want to post.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
I ran into this problem, hope you can help
I have a text file like this:
Spriden ID First Name Last Name Term Code Detail Code Amount Trans Date Description ... (3 Replies)
Discussion started by: CamTu
3 Replies
2. Shell Programming and Scripting
I need help writing a script that will reformat a crontab file. The first thing the script is doing is a crontab -l > crontab.txt. I need the crontab.txt file to read "8.00 PM every weekday (Mon-Fri) only in Oct." instead of the orig format "0 20 * 10 1-5" (1 Reply)
Discussion started by: alnita
1 Replies
3. Shell Programming and Scripting
I am working with a file of the form;
4256 7726 1
6525 716 1
7626 0838 1
8726 7623 2
8625 1563 2
1662 2628 3
1551 3552 3
1542 7984 ... (3 Replies)
Discussion started by: digipak
3 Replies
4. Shell Programming and Scripting
I have a file which have data like
A.txt
a
1Jan I am in a1.
1Jan I was born.
2Jan I am here.
3Jan I am in a3.
b
1Jan I am in b1.
c
2Jan I am in c2.
d
2Jan I am in d2.
5jan I am in d5.
date in the file might be vary evertime. (9 Replies)
Discussion started by: samkhu
9 Replies
5. Shell Programming and Scripting
I have a csv file with 11 columns. The first columns contains the User Id. One User id can have multiple sub Id.
The value of Sub Id is in column 10.
100026,captjason@hawaii.rr.com ,jason ,wolford ,1/16/1969, ,US, ,96761 ,15 ,seg_id
100026,captjason@hawaii.rr.com ,jason ,wolford ,1/16/1969,... (3 Replies)
Discussion started by: r_t_1601
3 Replies
6. Shell Programming and Scripting
Hello, I have many lengthy files that need to be reformatted. I was hoping a sed or awk script could fix this.
Here is an example of the original format:
P0037
# Degree: 32.999981
# COMMAND: 03 (#01A) Scale 1.296875, 52 (Wooden Crate w/ #2 Label, Bahko)
v -3328.000000 12.101541 437.000000... (2 Replies)
Discussion started by: Blue Solo
2 Replies
7. Shell Programming and Scripting
Hello:
When I tried a perl-oneliner to re-format fasta file.
infile.fasta
>YAL069W-1.334 Putative promoter
CCACACCACACCCACACACC
ACACCACACCCACACACACA
ACAGCCCTAATCTAACCC
>YAL068C-7235.2170 Putative ABC sequence
TACGAGAATAATTT
ACGTAAATGAAGTT
TATATATAAA
>gi|31044174|gb|AY143560.1|... (15 Replies)
Discussion started by: yifangt
15 Replies
8. Shell Programming and Scripting
I am using the code below to reformat the input (hp.txt). The output (newhp.txt) is not in the desired format and I can not seem to figure it out. I have attached both. Thank you.
perl -aF/\\t/ -lne 'print join(" ",@F) for ("0 A","0 G","0 C","0 T","A 0","G 0","C 0","T 0")' hp.txt > newhp.txt ... (4 Replies)
Discussion started by: cmccabe
4 Replies
9. Shell Programming and Scripting
Hi,
I have a csv file with content like:
1,0,100
1,1,150
2,0,200
2,1,250
3,0,300
3,1,350
I want an output such that all numbers in 3rd col where 2nd col is "0" come in the same col in the output. The same goes for numbers where 2nd col is "1".
1 100 150
2 200 250
3 300 350
Tnx... (2 Replies)
Discussion started by: jamaje
2 Replies
10. Shell Programming and Scripting
The below awk improved bu @MadeInGermany, works great as long as the input file has data in it in the below format:
input
chrX 25031028 25031925 chrX:25031028-25031925 ARX 631 18
chrX 25031028 25031925 chrX:25031028-25031925 ARX 632 14... (3 Replies)
Discussion started by: cmccabe
3 Replies
PUSH(8) BSD System Manager's Manual PUSH(8)
NAME
push -- fetch mail via POP
SYNOPSIS
push [-5 | --krb5] [-v | --verbose] [-f | --fork] [-l | --leave] [--from] [-c | --count] [--headers=headers] [-p port-spec |
--port=port-spec] po-box filename
DESCRIPTION
push retrieves mail from the post office box po-box, and stores the mail in mbox format in filename. The po-box can have any of the follow-
ing formats:
'hostname:username'
'po:hostname:username'
'username@hostname'
'po:username@hostname'
'hostname'
'po:username'
If no username is specified, push assumes that it's the same as on the local machine; hostname defaults to the value of the MAILHOST environ-
ment variable.
Supported options:
-5, --krb5
use Kerberos 5 (if compiled with support for Kerberos 5)
-f, --fork
fork before starting to delete messages
-l, --leave
don't delete fetched mail
--from behave like from.
-c, --count
first print how many messages and bytes there are.
--headers=headers
a list of comma-separated headers that should get printed.
-p port-spec, --port=port-spec
use this port instead of the default 'kpop' or '1109'.
The default is to first try Kerberos 5 authentication and then, if that fails, Kerberos 4.
ENVIRONMENT
MAILHOST
points to the post office, if no other hostname is specified.
EXAMPLES
$ push cornfield:roosta ~/.emacs-mail-crash-box
tries to fetch mail for the user roosta from the post office at ``cornfield'', and stores the mail in ~/.emacs-mail-crash-box (you are using
Gnus, aren't you?)
$ push --from -5 havregryn
tries to fetch From: lines for current user at post office ``havregryn'' using Kerberos 5.
SEE ALSO
from(1), pfrom(1), movemail(8), popper(8)
HISTORY
push was written while waiting for movemail to finish getting the mail.
HEIMDAL
May 31, 1998 HEIMDAL