Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: sed string manipulation in shell script
Top Forums Shell Programming and Scripting sed string manipulation in shell script Post 302421600 by mirfan on Saturday 15th of May 2010 03:14:56 AM
Old 05-15-2010
Hello,

None of the commands work for me. Anyways when i run following on commandline gives me error. Please let me know how to execute this

Code:
 
sed -e 's/VALUES (/VALUES (4255889,/' "INSERT INTO test (id,name) VALUES ('A');

Error: File name too long

Desire result should be

Code:
INSERT INTO test (id,name) VALUES (4255889,'A');


Also is there any way to tell shell script to ignore error and continue execution. Like

Code:
INSERT INTO test (id,name) VALUES (1,'A');
INSERT INTO test1 (id,name) VALUES (1,'A');
INSERT INTO test (id,name) VALUES (2,'A');

If test1 not exist .. script should continue and enter records for next table. I have only table in database which is test and test1 not exist. when i try to execute sql file through shell script. It gives me error that test1 table not exist and shell script terminates.

I want shell script continue execution and enter next records from sql file and ignore errors for tables which not exist in database.

Thank you.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need shell/sed script for grep+string replacement

Hi, Let me explain the situation. There are many files in a directory and its sub-directories that conatin the string pattern "pa". I want to replace all such instances with the pattern "pranavagarwal" doing a grep "pa" `ls` does give me all the instances of the occurence of that... (3 Replies)
Discussion started by: pranavagarwal
3 Replies

2. Shell Programming and Scripting

How to use sed for string manipulation

Hi, I would like to know How to use use sed for manipulating string for the following situation. Basically my objective is to check validity of the filename in my shell script. I am getting a parameter like this for my shell script. Check my folder is having some space. $1=/root/krishna... (2 Replies)
Discussion started by: hikrishn
2 Replies

3. Shell Programming and Scripting

Pattern manipulation in korn shell script using sed.

Hi, Could any one let me know, how can I cut the last field in below mentioned line. net,-hopcount,0,-netmask,255.255.255.0,,,,,192.168.37.0,10.253.0.1 net,-hopcount,0,-netmask,255.255.255.0,,,,,192.168.1.0,10.253.0.1 net,-hopcount,0,-netmask,255.255.255.0,,,,,192.168.38.0,10.253.0.1... (3 Replies)
Discussion started by: ajilesh
3 Replies

4. Shell Programming and Scripting

sed string manipulation

hi I am using sed to split a string this string is 11byteabc I would like to just get the numeric digits. echo "11byteabc" | sed 's/*// returns 11byteabc only solution that works is repeating number of times for the letters which is pointless grateful for any suggestions thanks (4 Replies)
Discussion started by: speedieB
4 Replies

5. Shell Programming and Scripting

Shell scripting string manipulation

Hi, if I have a string delimited by commas how can I put each character on a new line followed by a carriage return, and output this to a filee.g from: s,t,r,i,n,g to s t r i n g thanks you (3 Replies)
Discussion started by: Wahmed9
3 Replies

6. UNIX for Advanced & Expert Users

string manipulation in bash shell

Hi All, I am using a bash shell and want to the following thing. A process sends the following string to my script BACKUP_FAIL_REASON="Failed - Application Dump CDMACA-0:grep: /opt/nortel/ca/data/1245184/sd00/image1/S110907070708HIS... (4 Replies)
Discussion started by: Pkumar Sachin
4 Replies

7. Shell Programming and Scripting

String manipulation using ksh script

Hi, I need to convert string "(joe.smith" into "joe_smith" i.e. I need to remove the leading opening brace '(' and replace the dot '.' with an under score '_' can anyone suggest a one liner ksh script or unix command for this please (3 Replies)
Discussion started by: sdj
3 Replies

8. Shell Programming and Scripting

Manipulation with the string using sed

hello All, When I run find command on certain directory I may get one of the following output depending on configuration A. ./rel/prod/libpam.a B. ./rel/fld/libpam.a C. ./deb/detail/libpam.a D. ./deb/err/libpam.a I want to get output as below A. rel/prod B.... (2 Replies)
Discussion started by: anand.shah
2 Replies

9. Shell Programming and Scripting

Text manipulation with sed/awk in a bash script

Guys, I have a variable in a script that I want to transform to into something else Im hoping you guys can help. It doesn't have to use sed/awk but I figured these would be the simplest. DATE=20160120 I'd like to transform $DATE into "01-20-16" and move it into a new variable called... (8 Replies)
Discussion started by: dendenyc
8 Replies

10. Shell Programming and Scripting

sed for string manipulation

I have a file which contains contents like below proxy.config.cluster.mc_group_addr 224.0.1.37 proxy.config.log.logging_enabled 3 proxy.config.log.squid_log_enabled 1 Need to modify to 'proxy.config.cluster.mc_group_addr': '224.0.1.37' 'proxy.config.log.logging_enabled': '3'... (10 Replies)
Discussion started by: esham
10 Replies

LEARN ABOUT PHP

fbsql_insert_id

FBSQL_INSERT_ID(3)							 1							FBSQL_INSERT_ID(3)

fbsql_insert_id - Get the id generated from the previous INSERT operation

SYNOPSIS

       int fbsql_insert_id ([resource  $link_identifier])

DESCRIPTION

	Gets the id generated from the previous INSERT operation which created a DEFAULT UNIQUE value.

       Note

	       The value of the FrontBase SQL function fbsql_insert_id(3) always contains the most recently generated DEFAULT UNIQUE value, and is
	      not reset between queries.

PARAMETERS

	      o $
		link_identifier -A FrontBase link identifier returned by fbsql_connect(3) or fbsql_pconnect(3).If optional and not specified,  the
		function  will	try  to  find  an  open  link to the FrontBase server and if no such link is found it will try to create one as if
		fbsql_connect(3) was called with no arguments.

RETURN VALUES

	Returns the ID generated from the previous INSERT query, or 0 if the previous query does not generate an DEFAULT UNIQUE value.

	If you need to save the value for later, be sure to call this function immediately after the query that generates the value.

SEE ALSO

       fbsql_affected_rows(3).

PHP Documentation Group 													FBSQL_INSERT_ID(3)
All times are GMT -4. The time now is 03:36 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy