Hi,
Can someone let me know how I can acheive the following.
I have ~ delimited file and I need to convert into something like SQL insert statements.
SrcFile :
1~sjdsdj~asasas~
2~aaaaa~qwqwqwq~qwq
.....
I tried
AWK -F"~" '{print "INSERT INTO XX VALUES("$1 " ,\' "$2" \' , \' "$3 }'... (3 Replies)
Hi all,
It is a very stupid problem but I am not able to find a solution to it.
I am using awk to get a column from a file and I want to get the output field in between single quotes. For example,
Input.txt
123 abc
321 ddff
433 dfg
........
I want output file to be as
... (6 Replies)
For example:
I got a list of file end at .txt. I want all of them do the same command like
grep '^@' and attached it to a output .sh file.
This is the command I type:
ls *.txt | awk '{print "grep \' \^\@\' ",$1}' > txt.sh
My desired output is when I type the command "more txt.sh "
The... (4 Replies)
cat a | awk -F";" '{print "update db set column=' "$2" ' where column1=\""$1"\";"}' > ip-add.sql
Hi! I'm a new user!
i need to use single quote in the double quotes print string
The apex between che "$2" should not be interpreted, but....how?!
I'm trying to use \ but don't work correctly!
... (4 Replies)
How do you print out a single quote character in AWK? Using the escape character does not seem to work.
{printf "%1$s %2$s%3$s%2$s\n" , "INCLUDE", " \' ", "THIS" }
does not work. Any suggestions? (6 Replies)
Hi Guys,
Please someone help me to insert these numbers (enclosed with single quotes) to a statement using awk command. I'm having hard time of putting single quotes on these numbers.
input file:
10214
68441
07205
80731
92234
55432
DESIRED OUTPUT:
My ID Number='10214';... (1 Reply)
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
i have the output of a csh script piped to an awk script. In the awk script i was trying to assign a variable... (3 Replies)
From:
1,2,3,4,5,This is a test
6,7,8,9,0,"This, is a test"
1,9,2,8,3,"This is a ""test"""
4,7,3,1,8,""""
To:
1,2,3,4,5,This is a test
6,7,8,9,0,"This; is a test"
1,9,2,8,3,"This is a ''test''"
4,7,3,1,8,"''"Is there an easy syntax I'm overlooking? There will always be an odd number... (5 Replies)
Hello,
I'd like to print line if column 5th doesn't match with exm. But to reach there I have to make sure I match single quote.
I'm struggling to match that.
I've input file like:
Warning: Variants 'exm480340' and '5:137534453:G:C' have the same position.
Warning: Variants 'exm480345'... (9 Replies)
Discussion started by: genome
9 Replies
LEARN ABOUT DEBIAN
sc_warts2text
SC_WARTS2TEXT(1) BSD General Commands Manual SC_WARTS2TEXT(1)NAME
sc_warts2text -- simple dump of information contained in a warts file.
SYNOPSIS
sc_warts2text [-d ip2descr-file] [file ...]
DESCRIPTION
The sc_warts2text utility provides a simple dump of information contained in a sequence of warts files. The output is the same as that which
would have been provided by scamper if the text output option had been chosen instead of the warts output option when the data was collected.
The options are as follows:
-d ip2descr-file
specifies the name of a file with IP-address, description mappings, one mapping per line. See the examples section for further
information.
While the output of sc_warts2text is structured and suitable for initial analyses of results, the format of the output is not suitable for
automated parsing and analysis as the output of sc_warts2text will change overtime with no regard to backwards compatibility. Analyses of
the contents of a warts file should be made using specialised programs which link against the scamper file API.
EXAMPLES
The command:
sc_warts2text file1.warts file2.warts
will decode and print the contents of file1.warts, followed by the contents of file2.warts.
The command:
gzcat file1.warts.gz | sc_warts2text
will print the contents of the uncompressed file supplied on stdin.
Given a set of IP-address, description pairs in a file name mappings.txt:
192.0.2.1 "foo"
192.0.2.2 "bar"
then the command gzcat file1.warts.gz | sc_warts2text -d mappings.txt will print the description associated with a given destination address
before each result is presented.
SEE ALSO scamper(1), sc_wartsdump(1)AUTHORS
sc_warts2text is written by Matthew Luckie <mjl@luckie.org.nz>.
BSD October 15, 2010 BSD