Sponsored Content
Full Discussion: Text formatting
Top Forums Shell Programming and Scripting Text formatting Post 302496257 by pravin27 on Sunday 13th of February 2011 05:26:29 AM
Old 02-13-2011
Try this,
Code:
awk 'BEGIN{str="select ";printf "INSERT into tab1(  "} !/^$/ && !/^[0-9].*/&&NR>3{print $0,"," ;str=str $0","} END{print ")" str, " from tab1"}' infile

This User Gave Thanks to pravin27 For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

formatting text

Hi, I am having a file containing entries like: .iso.org.dod.internet.mgmt.mib-2.system.sysName.0 .iso.org.dod.internet.mgmt.mib-2.system.sysLocation.0 .iso.org.dod.internet.mgmt.mib-2.system.sysServices.0 .iso.org.dod.internet.mgmt.mib-2.system.sysORLastChange.0... (16 Replies)
Discussion started by: esham
16 Replies

2. UNIX for Dummies Questions & Answers

Text Formatting

I have a file like this with 1 lac lines. 1 2 3 4 5 6 7 8 9 0 I would like to format the above text file 1 2 3 4 5 6 7 8 9 0 (7 Replies)
Discussion started by: aravindj80
7 Replies

3. UNIX for Dummies Questions & Answers

Text file formatting

Hi all! I'm new in unix, and faced with some difficulties. So I have text file f.e. "textfile" which contains rows like: aaa bbb ccc ddd How could I format it, so the file looks like: aaabbb cccddd Thanks in andvance (5 Replies)
Discussion started by: consta.v
5 Replies

4. Shell Programming and Scripting

text formatting

Hi, any idea input: mr.smith stvenson: /address #/tel no/ personal data profile. mrs.smith stevenson: /address #/tel no/occupation/ personal data profile. output: mr.smith stvenson address #: tel no: personal data profile. mrs.smith stevenson address #: tel no: occupation:... (7 Replies)
Discussion started by: kenshinhimura
7 Replies

5. UNIX for Dummies Questions & Answers

Formatting TEXT

Hello, I have the following lines in a text file: /var/spool/postfix/defer/1/15C86B0547C /var/spool/postfix/defer/1/19AD1B054A2 /var/spool/postfix/defer/2/25A16B05493 /var/spool/postfix/defer/6/626FBB05496 /var/spool/postfix/defer/6/634D4B0544A /var/spool/postfix/defer/6/6A8ACB05499... (2 Replies)
Discussion started by: mojoman
2 Replies

6. Shell Programming and Scripting

Text formatting

I have an input file as below. 1 Sanjib Gayen 2 Chetan Jadhav 3 Vijaykumar Uddi 4 Pinaki Sarkar I want to generate an output file as below. 1-Sanjib Gayen 2-Chetan Jadhav (4 Replies)
Discussion started by: R0H0N
4 Replies

7. Shell Programming and Scripting

Help with Text formatting

I am generating the o/p as: BLANSWER 112747 112747 TBLQSTN 983 692 INITIATIVE 35 35 PAIGN 3122 3538 IGNCONTACT 90136 93534 IGNGROUP 27 27 AIGNSTEP 16899 20437 AIGNTYPE ... (1 Reply)
Discussion started by: karumudi7
1 Replies

8. Shell Programming and Scripting

Text formatting help

I have bunch of files with data's like below. archive.log.0104 ar0104_akl ar0731_rln ar0731_rsl M70148I need to compile all those files into a single file(.xls file) in the below format. 1st row is file name - should come in 1st column in excel In 2 - 4 row, all entries starts with... (13 Replies)
Discussion started by: vasanth_123
13 Replies

9. Shell Programming and Scripting

Help Me with the formatting of text

Hi, I am new to this forum; I need a help for my scripting problem. I have made a script in Unix which is extracting a report but the issue is that report is not in a proper format. Original Report Ex: Field 1....................... a b c d e f g Field 2............. @ID.@ID Field... (4 Replies)
Discussion started by: tush
4 Replies

10. Post Here to Contact Site Administrators and Moderators

Text formatting

I know I've been away from the forums for past couple of months. But I am back now : ) I used to hit ctrl+B and ctrl+I after selecting the text to make text bold or italic respectively. (Pressing the keys would add and tags etc) However, that is not working anymore. Did I miss something? (13 Replies)
Discussion started by: clx
13 Replies
TRNA2SAP(1)						     NCBI Tools User's Manual						       TRNA2SAP(1)

NAME
trna2sap - convert tRNAscan-SE output to an ASN.1 Seq-annot object SYNOPSIS
trna2sap [-] [-a] [-c str] [-f str] [-i filename] [-j] [-m str] [-n str] [-o filename] [-p dir] [-r dir] [-s] [-t str] [-u] [-x str] DESCRIPTION
trna2sap reads a text file produced by tRNAscan-SE and produces a corresponding ASN.1 Seq-annot in the format understood by other NCBI tools. OPTIONS
A summary of options is included below. - Print usage message -a Add tRNAscan-SE citation -c str Comment -f str Substring Filter -i filename Single Input file (standard input by default) -j Just produce a five-column feature table, a la trna2tbl(1). -m str ReMark -n str Annotation Name (normally "tRNA"). -o filename Single Output file (standard output by default) -p dir Path to files -r dir Path for Results -s Ignore Pseudo tRNAs -t str Annotation Title (normally "tRNAscan-SE"). -u Ignore Undetermined tRNAs -x str File selection suffix with -p (.trna by default). AUTHOR
The National Center for Biotechnology Information. SEE ALSO
sequin(1), tbl2asn(1), trna2tbl(1). NCBI
2006-01-11 TRNA2SAP(1)
All times are GMT -4. The time now is 12:03 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy