Script batch with command sed

Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Script batch with command sed
# 8  
Old 10-25-2013
Could you paste the entire script? Ensure you have the hashbang line at the beginning to denote the shell.. Example: #!/usr/bin/ksh

Save it as a script -> .ksh or .sh and execute it
# 9  
Old 10-25-2013
this is the error:
./[6]: awk{print substr($0,1,7)}: not found

this is the script:
for FILE in $(ls $DIR)
  echo "insert into comments('"$(awk'{print substr($0,1,7)}' $DIR/$FILE)"','"$(cat $DIR/$FILE)"');" >> prova.txt

Last edited by Franklin52; 10-25-2013 at 09:47 AM.. Reason: Please use code tags
# 10  
Old 10-25-2013

$ echo "My name is Mark and I'm a child" | awk '{print "insert into tabella (""\x27"substr($0,1,7)"\x27","\x27"$0"\x27"")"}' OFS=,

insert into tabella ('My name','My name is Mark and I'm a child')

# 11  
Old 10-25-2013
like this work, but with file?

---------- Post updated at 10:01 AM ---------- Previous update was at 07:11 AM ----------

i resolve... this is the script
for FILE in $(ls $DIR)
   pippo=$(sed -e "s/'/''/g;s/\`/''/" $DIR/$FILE) 

  #echo $pippo | awk '{print "insert into tabella (""\x27"substr($0,1,7)"\x27","\x27"$0"\x27"")"}' >> prova.txt

thks at all
have a nice day

Last edited by vbe; 10-25-2013 at 12:33 PM.. Reason: code tags...
# 12  
Old 10-25-2013
why don't you show real input
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sed batch file issue

Hi!! I want to create a batch file so the sh file could change a file on a specific time. I made this config: sed -i 's/range;/option POLYCOM "tftp://";/g' /etc/dhcp3/dhcpd.conf My issue is that the sed does not accept the :// character.... (2 Replies)
Discussion started by: jocas9
2 Replies

2. UNIX for Advanced & Expert Users

Batch SFTP command Help

I need to run a test SFTP command in a batch mode and what I need to prompt my password after the sftp userid@hostname. I do not have have an ssh key exchanged between my server and the external server. I only have access to it as an sftp server. I must enter my password in my script. How do i... (2 Replies)
Discussion started by: mrn6430
2 Replies

3. Shell Programming and Scripting

Executing a batch of files within a shell script with option to refire the individual files in batch

Hello everyone. I am new to shell scripting and i am required to create a shell script, the purpose of which i will explain below. I am on a solaris server btw. Before delving into the requirements, i will give youse an overview of what is currently in place and its purpose. ... (2 Replies)
Discussion started by: goddevil
2 Replies

4. Shell Programming and Scripting

Sed or awk for batch replace file name

Can you please point me in the correct direction? I need a line or script to run though a given directory and find all files with "@domain.local" in there names and simple remove that. For example if the files were named 1234@domain.local the file would then become 1234. (1 Reply)
Discussion started by: binary-ninja
1 Replies

5. Shell Programming and Scripting

try to batch rename using sed (if this is best)

hi gooday I need some help with a rename I am attempting. I'd like to rename a bunch of files in a folder example list.dat.old to list_N.dat query.dat.old to query_N.dat note the two periods in (.dat.old) to become _N.dat I tried using sed like this ls *.dat.old | sed... (3 Replies)
Discussion started by: johnstrong
3 Replies

6. Shell Programming and Scripting

use sed do batch wildcard string replace

Hi, Here is what I want to do I want to search local directory and its sub directory, all the files which contain any string like _12345, then remove this string. String is a combination of _ plus a random integer number. For example, here is one line in a file before <properties... (1 Reply)
Discussion started by: bp5000
1 Replies

7. UNIX for Dummies Questions & Answers

batch file using sed command in msdos

<! pad_meth: <! program = "/usr/lib/drivers/pse/x29d -p" how should i program it in oder to display this: <! pad_meth: <! program = "/usr/lib/drivers/pse/x29d -p" ;) (1 Reply)
Discussion started by: rita1985
1 Replies

8. Shell Programming and Scripting

su command in batch mode

Hi, how do we change user in a shell script- batch mode. Thanks, Rajesh (3 Replies)
Discussion started by: Rajesh Gohad
3 Replies

9. UNIX for Dummies Questions & Answers

batch command in a shell script

How do I execute a batch command from a script, which "waits" with the next command until the first one has finished? ======= A piece of my script looks like this: #!/bin/sh (...) # run a long batch job: ./ # then rename resulting file: mv output.dat backup.dat (...) ... (7 Replies)
Discussion started by: ivvo
7 Replies

10. Shell Programming and Scripting

Using Batch command

Hi All I have a need due time constraint to issue the mail command in background. I have a script that sends a message to a mail address as follows :- echo "$MLINE" | mail -s "$HOST - $TEXT" & The script runs frequently and I check to see if the script is active and if it is , it... (5 Replies)
Discussion started by: jhansrod
5 Replies
Login or Register to Ask a Question

Featured Tech Videos