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 :
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.
Moderator's Comments:
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!
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
03-02-2011
