Login or Register to Ask a Question and Join Our Community


Programming

need help with creating a sh script

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Programming need help with creating a sh script
# 1  
Old 03-02-2011
need help with creating a sh script
Hi everyone
I’m not a programmer and my knowledge of scripting is very poor, now I’m stock in a task at work and would really appreciate it if someone could help me out.
Here is the problem:
1. I have a file with 9 million entries that look like this :
Code:
611424167
610864581
611881523
609585386
611022742
609283755
610960266

So basically there are 9 million lines and in each line there is a 9 digit number
2. I need to create a script that would group all these 9-digit numbers one after another with no space, put every to line into parentheses and add a text before every 10 line, which will eventually look like this :


Code:
Update table set location=55 (15848716,16743438,10116069,15635325,2281848545,16542381,10264272,537237738,16663957,10138040,10278391,1073929615,537578664,1074118324,1074201594,539647058,1074510375,1074414154,1074708478,1074746890,1075021290,1074513470,1075068666,1074988439,1075367528,540340963,1075597395,1075856225,1075902769,608293080,614368237,1075189157,1076843973,1077072172,1074201594,539647058,1074510375,1074414154,1074708478,1074746890,1075021290,1074513470,1075068666,1074988439,1075367528,540340963,1075597395,)
Update table set loation=55 15848716,16743438,10116069,15635325,2281848545,16542381,10264272,537237738,16663957,10138040,10278391,1073929615,537578664,1074118324,1074201594,539647058,1074510375,1074414154,1074708478,1074746890,1075021290,1074513470,1075068666,1074988439,1075367528,540340963,1075597395,1075856225,1075902769,608293080,614368237,1075189157,1076843973,1077072172,1074201594,539647058,1074510375,1074414154,1074708478,1074746890,1075021290,1074513470,1075068666,1074988439,1075367528,540340963,1075597395,)

your help would be very much appreciated...
i hope I hear from someone soon.Smilie
Moderator's Comments:
Mod Comment
Please use code tags when posting data and code samples!
Last edited by vgersh99; 03-02-2011 at 04:59 PM.. Reason: code tags, please!
# 2  
Old 03-02-2011
Code:
nawk -v n=10 '{fnr=FNR}FNR%n==1{printf "Update table set location=55 ("}{printf("%s", !(FNR%n)?")\n":$1 ",")}END{if(fnr%n) print ")"}' myFile

# 3  
Old 03-02-2011
Code:
gawk -v title="Update table set loation=55" 'NR%10==0{V=V","$0")"}
NR%10>1{V=V==0?$0:V","$0}
NR%10==1{V=V==0?title" ("$0:V"\n"title" ("$0}
END{print V}'

# 4  
Old 03-03-2011
need help with creating a sh script
Thank you very much for your help, unfortunately I still couldn't successfully use these scripts and I'm sure it is because I'm not understanding it correctly ;
1. Where should I locate the file that the script should read from?
2. Where should I ask it to save the changes?
3. Should I save the script in a bash script? #!/bin/sh

I will try to find these answers myself as well but I'm running out of time and so desperate to find a solution, your help again would be very much appreciated.

So far , here is what I've managed to do :

· cat cingular.txt | xargs -n10 | awk '{ print $1","$2","$3","$4","$5","$6","$7","$8","$9","$10}' ( this command managed to make my file look like this : ( this goes on for almost 6 million lines)
· 613382230,614112492,642422294,614219643,614335239,614004204,611549637,610115247,611639280,611107468,
Now here is the logic of the command that I'm looking for :
1. For every 10 lines, add “update table set location=54 (“ at the beginning of the first line and put “,0)” at the end of the 10th line.
2. Create one space line ( blank line ) after every 10 lines.
3. Repeat this task for 6000 times.
Again I really appreciate your help , thank you.

---------- Post updated at 12:55 PM ---------- Previous update was at 10:20 AM ----------

I think I figured out most of it, with a long , long way, probably you can find a much easier way.

sed 'n;n;n;n;n;n;n;n;n;n;s/^/update table set location= where location in
(/' file.txt > file2.txt

# add "," at the end of each line
sed 's/$/,/g' file.txt > file.txt

---------- Post updated at 12:56 PM ---------- Previous update was at 12:55 PM ----------

the only part that I'm stock with is this :

if a line begins with "update", add "0)" to the previous line

how can I do that through sed command ?
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Creating script in rc.d

Hi, I have created customized scripts to start httpd and postgres (For CentOS 6) in /etc/init.d. However for it to work even after reboot, I have to put the script in /etc/rc.d/rc0.d, rc1.d, etc. # ls -lrt total 60 -rwxr-xr-x 1 root root 20199 Oct 4 2017 rc.sysinit -rwxr-xr-x 1... (6 Replies)
Discussion started by: anaigini45
6 Replies

2. Shell Programming and Scripting

Help with creating a script

Hi everyone, I am completely new to this forum and I have some questions regarding a script I am writing. I would be happy if anyone could help me with the small and precise script which should include if, then, else, while until, case and select. The scenario is as follows: 1) A user... (3 Replies)
Discussion started by: codenotfound
3 Replies

3. Shell Programming and Scripting

Creating IN list in PLSQL script dynamically by using shell script

Hi all, I have a PLSQL script which has a IN list where it takes some ids as input. For example SELECT * FROM EMPLOYEE WHERE EMPLOYEE_ID IN (comma separated list ) I want to run this quest inside a shell script but I would like to prepare the IN list dynamically where the employee ids... (1 Reply)
Discussion started by: LoneRanger
1 Replies

4. Shell Programming and Scripting

Need help in creating file restoration script from a backup script.

Hi all i am struggling in creating a restore of env files while doing applications clone. the first file i created for copying the important configurations file which is running perfect now for reverting the changes i mean when i am restoring these files to its original places i have to do... (7 Replies)
Discussion started by: javeedkaleem
7 Replies

5. UNIX for Dummies Questions & Answers

Creating a script

Alright, well I did some more research since I originally posted this thread, and as much as I'd like to delete it, I can't, so I'll just extend my initial question a little. Right now I have 3 scripts: 1#!/bin/bash # script1 - Write all files modfied x days ago find .. -daystart -mtime 0... (2 Replies)
Discussion started by: Aussiemick
2 Replies

6. Shell Programming and Scripting

help needed with creating challenging bash script with creating directories

Hi, Can someone help me with creating a bash shell script. I need to create a script that gets a positive number n as an argument. The script must create n directories in the current directory with names like map_1, map_2 etcetera. Each directory must be contained within its predecessor. So... (7 Replies)
Discussion started by: I-1
7 Replies

7. Shell Programming and Scripting

(Urgent):Creating flat file using sql script and sqlplus from UNIX Shell Script

Hi, I need help urgently for following issue. Pls help me to resolve this issue. I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql) I given... (6 Replies)
Discussion started by: praka
6 Replies

8. Shell Programming and Scripting

Need help creating a script

I need to automate the following process: I have a list of ip address for printers in a file called iplist.txt, I need to take that list and run the command snmpget -v 1 -c public ip address sysName.0 for each ip address to see if the printer is running snmp, I want to the create a file... (4 Replies)
Discussion started by: inLine6
4 Replies

9. UNIX for Dummies Questions & Answers

creating a script

I am trying to create a application in OSX through UNIX that will run a script to mount an image from a CD-ROM and run the application which it corresponds to, all with double clicking on a icon in OSX. Any thoughts or ideas? -Mad (3 Replies)
Discussion started by: madknowledge
3 Replies

10. Programming

creating a new C script

All right. Heres the deal, I need to know everysingle command or funtion there is to create a new c file (file.c). Heres the catch: I cannot use text editors!!!:mad: I heard of a "gcc" command is that any good?:confused: Thanks..:cool: (2 Replies)
Discussion started by: AbRa-KaDabRa
2 Replies
Login or Register to Ask a Question