Hi all, I have a file with records that look something like this,
I need to reformat this file to look like this,
I currently have a peice of code that splits the file into the 2 record types and removes the lines containing the phrase "Transaction ID" in field 1, like this,
Once this has been done the noMref file is reformatted using this code,
and the netbanx2.tmp file is reeformatted using this code,
The 2 output files are then merged together at the end.
This script works perfectly but it runs for about 40 minutes with an input file containing about 13000 lines. The worst offending parts are the file split (7 mins) and the second reformat (30 mins) although that is because most of the records are split into the netbanx2.tmp file
I really need to make this script more efficinet both in run time and cpu usage so any assistance anyone can give would be very much appreciated.
I could do this more efficiently in perl but unfortunately for various reasons this needs to be in shell script.
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)
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)
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)