I ran into another problem when some different data was input, my input file look like this:
Code:
Spriden ID First Name Last Name Term Code Detail Code Amount Trans Date Description
000681047 Allison Ancel 200520 EASY -600.00 3/9/05 0:00 wrong term
000681047 Allison Ancel 200520 EASY 600.00 3/9/05 0:00 SCAD Debit Card Charge
000681047 Allison Ancel 200530 EASY 600.00 3/9/05 0:00 SCAD Debit Card Charge
000699678 Ashley Willem 200520 EASY 650.00 3/9/05 0:00 SCAD Debit Card Charge
000702927 Charla Peters 200520 EASY 260.00 3/9/05 0:00 SCAD Debit Card Charge
000672954 Emily Voegtlin 200520 EASY 5.00 3/9/05 0:00 SCAD Debit Card Charge
000657138 Jimmy Gilbert 200530 EASY 600.00 3/9/05 0:00 SCAD Debit Card Charge
000692343 Paul Martinez 200530 EASY -200.00 3/9/05 0:00 Decide not to deposit
000692343 Paul Martinez 200530 EASY 200.00 3/9/05 0:00 Do not Deposit
I don't want the duplicate entries to print to the output file, ie. those with same ID (arg 1) and have an entry for positive charge (arg 6) and negative charge (arg 6) should be cancel out, then only the one left with positive charge with "SCAD debit Card Charge" will be print to the output file.
For instant, the first 2 entries and the last 2 entries are cancelled out from the input file. The output i want is like this:
Code:
V2
U000681047 Ancel, Allison 01/01/10 SCAD Group Inc. PA01001000100100PA01011010101101AD010010060000
U000699678 Willem, Ashley 01/01/10 SCAD Group Inc. PA01001000100100PA01011010101101AD010010065000
U000702927 Peters, Charla 01/01/10 SCAD Group Inc. PA01001000100100PA01011010101101AD010010026000
U000672954 Voegtlin, Emily 01/01/10 SCAD Group Inc. PA01001000100100PA01011010101101AD0100100500
U000657138 Gilbert, Jimmy 01/01/10 SCAD Group Inc. PA01001000100100PA01011010101101AD010010060000
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)
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)
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)
Hi all, I have a file with records that look something like this,
"Transaction ID",Date,Email,"Card Type",Amount,"NETBANX Ref","Root Ref","Transaction Type","Merchant Ref",Status,"Interface ID","Interface Name","User ID"
nnnnnnnnn,"21 Nov 2011 00:10:47",someone@hotmail.co.uk,"Visa... (2 Replies)
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)
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)
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)
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)