05-21-2009
create Insert script from a file
Hi ,
I have a text file text.txt which contains values as
ULTRA,OTHERS,Mumbai,16912
ULTIMATE,OTHERS,Mumbai,16913
ULTIMATIUM,OTHERS,Mumbai,16914
I want to read the file line by line and create insert scripts like
INSERT INTO TAB ( DESC,PLACE,NUMBER ) VALUES (ULTRA,OTHERS,Mumbai,16912)
INSERT INTO TAB ( DESC,PLACE,NUMBER ) VALUES (ULTIMATE,OTHERS,Mumbai,16913)
INSERT INTO TAB ( DESC,PLACE,NUMBER ) VALUES (ULTIMATUM,OTHERS,Mumbai,16914)
Please Help
Thanks and Regards
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi all,
I have a test.dat file.In that file i have many lines of data.
IN between some lines i want to insert a new line while running the test.ksh.
Say for ex:
In the dat file i have data like
N001 100.00
N001 200.00
N001 300.00
N001 400.00 <==
After this line i want to... (2 Replies)
Discussion started by: Sona
2 Replies
2. UNIX for Dummies Questions & Answers
I have a file with over 500 MAC addresses. Each address is on a new line. However, the MACs do not have ":"
I need a script that will read the file, line by line and insert colons in the addresses and then print the results to a new file.
current.txt looks like this
111111111111
222222222222... (4 Replies)
Discussion started by: canopus15
4 Replies
3. Shell Programming and Scripting
I'm in a time crunch here and I don't know how to write scripts.
I have a file of data that looks like the following:
1 7.652073E+00 0.000000E+00 7.146691E+02 1.704154E+01
2 7.652068E+00 6.031387E+00 7.146636E+02 2.499305E+01
3 7.645906E+00 1.509455E+01 7.144158E+02 1.822061E+02
4... (7 Replies)
Discussion started by: pk218703
7 Replies
4. Shell Programming and Scripting
Hi Guys,
I need to create a insert query for the below file
Fri Sep 4 06:25:51 2009
ACTION : 'CREATE INDEX S100S_DC.PLInsuranceReportRules_testI1 ON S100S_DC.PLInsuranceReportRules_test1(ENTITY_KEY)'
DATABASE USER: '/'
PRIVILEGE : SYSDBA
CLIENT USER: oracle
CLIENT TERMINAL: pts/3... (6 Replies)
Discussion started by: mac4rfree
6 Replies
5. UNIX for Dummies Questions & Answers
Hi,
I am new to shell scripting. I need a bash shell scripts which search and grep a parameter value from input.txt file and insert it in between two semicolon of second line of output.txt file.
For example
The shell script search an IP address as parameter value from input.txt ... (2 Replies)
Discussion started by: sunilkumarsinha
2 Replies
6. Shell Programming and Scripting
Hi all.
This is my first post on this forum. I've previously found great help in the huge knowledgebase that is here, but this time I have not been able to find a solution to my problem.
I have a large text file that looks like this:
typedef struct ABC_struct_nbr1_ {
char attr1; /*... (0 Replies)
Discussion started by: Yagi Uda
0 Replies
7. Shell Programming and Scripting
Hello,
I think I need sed, but perhaps awk could help.
I am trying to add a function to a C source file based off a struct declaration.
for example:
struct Rational
{
int numerator;
int denominator;
};
becomes
struct Rational (4 Replies)
Discussion started by: afulldevnull
4 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I need to insert "Hello World" text into a file called hai.txt using shell scripting. Kindly help me.
For eg: If I open the file hai.txt by giving linux command cat hai.txt, the content of the file should have the text Hello World in it.
Thanks (5 Replies)
Discussion started by: karthick nath
5 Replies
9. UNIX for Beginners Questions & Answers
Hi All ,
I am looking to create one TCL script to insert one text based on some regular expression match on one file as stated below
Input File
module (mem1 ,mem2 , bist1 , ten2 , sen1 , land2 , taane2 ,
ran1 , ran2 , tri2 , tri8 , fly1 , fly2 , san2 );
output ran1 , ran2 , tri2 ,... (1 Reply)
Discussion started by: kshitij
1 Replies
LEARN ABOUT MOJAVE
osacompile
OSACOMPILE(1) BSD General Commands Manual OSACOMPILE(1)
NAME
osacompile -- compile AppleScripts and other OSA language scripts
SYNOPSIS
osacompile [-l language] [-e command] [-o name] [-d] [-r type:id] [-t type] [-c creator] [-x] [-s] [-u] [-a arch] [file ...]
DESCRIPTION
osacompile compiles the given files, or standard input if none are listed, into a single output script. Files may be plain text or other
compiled scripts. The options are as follows:
-l language
Override the language for any plain text files. Normally, plain text files are compiled as AppleScript.
-e command
Enter one line of a script. Script commands given via -e are prepended to the normal source, if any. Multiple -e options may be given
to build up a multi-line script. Because most scripts use characters that are special to many shell programs (e.g., AppleScript uses
single and double quote marks, ``('', ``)'', and ``*''), the command will have to be correctly quoted and escaped to get it past the
shell intact.
-o name
Place the output in the file name. If -o is not specified, the resulting script is placed in the file ``a.scpt''. The value of -o
partly determines the output file format; see below.
-x Save the resulting script as execute-only.
The following options are only relevant when creating a new bundled applet or droplet:
-s Stay-open applet.
-u Use startup screen.
-a arch
Create the applet or droplet for the specified target architecture arch. The allowable values are ``ppc'', ``i386'', and ``x86_64''.
The default is to create a universal binary.
The following options control the packaging of the output file. You should only need them for compatibility with classic Mac OS or for cus-
tom file formats.
-d Place the resulting script in the data fork of the output file. This is the default.
-r type:id
Place the resulting script in the resource fork of the output file, in the specified resource.
-t type
Set the output file type to type, where type is a four-character code. If this option is not specified, the creator code will not be
set.
-c creator
Set the output file creator to creator, where creator is a four-character code. If this option is not specified, the creator code will
not be set.
If no options are specified, osacompile produces a Mac OS X format script file: data fork only, with no type or creator code.
If the -o option is specified and the file does not already exist, osacompile uses the filename extension to determine what type of file to
create. If the filename ends with ``.app'', it creates a bundled applet or droplet. If the filename ends with ``.scptd'', it creates a bun-
dled compiled script. Otherwise, it creates a flat file with the script data placed according to the values of the -d and -r options.
EXAMPLES
To produce a script compatible with classic Mac OS:
osacompile -r scpt:128 -t osas -c ToyS example.applescript
SEE ALSO
osascript(1), osalang(1)
Mac OS X November 12, 2008 Mac OS X