|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Please help me reformat this file
Post 302369874 by summer_cherry on Monday 9th of November 2009 10:14:53 PM
11-09-2009
|
|
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 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
4. 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
5. Shell Programming and Scripting
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)
Discussion started by: dazedandconfuse
2 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
LEARN ABOUT OSF1
mtype
mtype(1) General Commands Manual mtype(1) NAME
mtype - mtools utility to display the contents of a DOS file SYNOPSIS
mtype [-ts] msdosfile [msdosfiles...] OPTIONS
Specifies text file viewing. Line terminators are converted to the appropriate format. Strips the high bit from the data. DESCRIPTION
The mtype command displays the specified file on the screen. Unlike conventions, this command supports multiple arguments. Subdirectory names that contain the '/' or '' separator are supported. If you use the '' separator or wildcards, you must enclose file names in quotes to protect them from the shell. The mcd command can be used to establish the device and the current working directory (relative to DOS), otherwise the default is A:. EXIT STATUS
The following exit values are returned: Success. Failure. ENVIRONMENT VARIABLES
The following environment variables affect the execution of mtype: If set, this variable names the file that contains the name of the cur- rent mtools working directory as established by the mcd command. If this variable is not set, the file $HOME/.mcwd is used. FILES
Contains the name of the current mtools working directory as established by the mcd command. If this file does not exist, the default mtools working directory is A:. Executable file SEE ALSO
Commands: dos2unix(1), mcd(1), mread(1), mtools(1), unix2dos(1) mtype(1)