12-06-2010
Convert comma seperated file to line seperated.
Hi,
I have data like this.
1,2,3,4
Output required:
1
2
3
4
I am trying to use tr function but getting error.
Help is appreciated.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi all
I need to input values in a .csv file into my Oracle table running in Unix, I wonder what would be the command to do so...
The values are recorded in an excel file and I tried using a formatted text file to do so but failed because one of the field is simply too large to fit in the... (5 Replies)
Discussion started by: handynas
5 Replies
2. UNIX for Advanced & Expert Users
Hi all
I need to input values in a .csv file into my Oracle table running in Unix, I wonder what would be the command to do so...
The values are recorded in an excel file and I tried using a formatted text file to do so but failed because one of the field is simply too large to fit in the... (4 Replies)
Discussion started by: handynas
4 Replies
3. Shell Programming and Scripting
how to convert the result of the select query to comma seperated data and put in a .csv file using korn shell.
Pls help me as its very urgent.
Thanks,
Hema. (1 Reply)
Discussion started by: Hemamalini
1 Replies
4. UNIX for Dummies Questions & Answers
My query is now a bit simplified.
file1.txt
names; ID; value1 ; values N;
ABC; 1 ; a18 ; ...
CDF; 2 ; b16 ; ..
ABC; 1 ; c13 ; ......
EFG; 3 ;d12 ; ...
file2.txt
ID(Unique);smVals; smVal1; smVal N;
1; ...; ...; ...;
2; ..; ..; ..;
3; ..; ..; ..; ... (1 Reply)
Discussion started by: szchmaltz
1 Replies
5. Shell Programming and Scripting
Hi,
I want to remove empty/blank lines from comma seperated and space seperated files
Thanks all for help (11 Replies)
Discussion started by: pinnacle
11 Replies
6. Shell Programming and Scripting
I have file like this
FileA:
abc , "helloworld" , america
def,asia, japan
ghi, africa, ipl
Output Needed:
abc,"helloworld",america
def,asia,japan
ghi,africa,ipl
I would like to implement using awk.
I want to trim each field for its leading and trailing spaces. (7 Replies)
Discussion started by: pinnacle
7 Replies
7. UNIX for Dummies Questions & Answers
Using awk or sed, I'd like to remove leading spaces after a comma and before a right justified number in field 6. Sounds simple but I can't find a solution. Each field's formatting must stay intact.
Input:
40,123456-02,160,05/24/2012,02/13/1977, 10699.15,0
Output:... (5 Replies)
Discussion started by: Scottie1954
5 Replies
8. Shell Programming and Scripting
I have a file with the below content
a = test1
b = test2
a = test3
b= test4
c = test6
b = test5
d = test7
d = test9
Need the output to be as follows
a = test1,test3
b = test2, test5
c = test6
d = test7, test9 (4 Replies)
Discussion started by: iron_michael86
4 Replies
9. Shell Programming and Scripting
Hi All,
I am new to shell scripting i am trying to convert the listner.log to csv which can be inturn converted to excel for easy reading.
i used this command
awk '/SID=/ && /HOST=/ && /PORT=/ && /USER=/ {
i=match($0,"SID="); i=i+RLENGTH; h0=substr($0,i);
i=match(h0,")");... (6 Replies)
Discussion started by: skoshekay
6 Replies
10. Shell Programming and Scripting
Hi Experts
I have an escape seperated fields in the unix file. And in the below format file I need to extract the first column. Please help its urgent.
cat -v op.dat | head
24397028^
I want to extract the file in below format ( with only first column )
24397028
2439707
thanks.
... (6 Replies)
Discussion started by: neha_suri06
6 Replies
LEARN ABOUT DEBIAN
bp_mutate
BP_MUTATE(1p) User Contributed Perl Documentation BP_MUTATE(1p)
NAME
mutate.pl - randomly mutagenize a single protein or DNA sequence
SYNOPSIS
./mutate.pl -p 25 -i test.fa -n 5 -f swiss -o muts.swiss
#or
./mutate.pl --percent=25 --input=test.fa --number=5 -output=x.fa
DESCRIPTION
Randomly mutagenize a single protein or DNA sequence one or more times. Specify percentage mutated and number of resulting mutant
sequences. Print mutagenized sequences to STDOUT or write to an output file.
-h|--help Help
-p|--percent Percent mutagenized
-n|--number Number of mutant sequences created
-o|--output Output file (optional)
-f|--format Output format (default: fasta)
-i|--input Input file
FEEDBACK
User feedback is an integral part of the evolution of this and other Bioperl scripts. Send your comments and suggestions to the Bioperl
mailing list. Your participation is much appreciated.
bioperl-l@bioperl.org - General discussion
http://bioperl.org/wiki/Mailing_lists - About the mailing lists
Reporting Bugs
Report bugs to the Bioperl bug tracking system to help us keep track of the bugs and their resolution. Bug reports can be submitted via the
web:
https://redmine.open-bio.org/projects/bioperl/
AUTHOR
Brian Osborne, bosborne at alum.mit.edu
perl v5.14.2 2012-03-02 BP_MUTATE(1p)