Below it's my screen, when i tried to run. I created a vi file called output.awk, wrote your code in it, then gave the root permissions to the file, then executed with sh output.awk, i got an error awk not found.
Code:
"output.awk" [New file] 24 lines, 815 characters
[gil@cx01:~]$
>chmod 777 output.awk
[gil@cx01:~]$
>ls -la
total 9570034
drwxr-xr-x 2 bscscx bscs 4 Feb 16 12:25 .
drwxr-xr-x 8 bscscx bscs 19 Feb 16 08:12 ..
-rw-r--r-- 1 bscscx bscs 4895889520 Feb 16 08:37 input
-rwxrwxrwx 1 bscscx bscs 815 Feb 16 12:25 output.awk
[gil@cx01:~]$
>sh output
output.awk: wk: not found
Moderator's Comments:
Seriously: PLEASE use CODE tags as required by forum rules!
Last edited by RudiC; 02-16-2017 at 08:17 AM..
Reason: Added CODE tags.
As I can't see that file's contents, I can't comment. There's no wk command in my script. Trying to replicate what you describe (a file with the script in post#6 as is), I find it works perfectly.
Did you consider the hint in post#11?
Below it's my screen, when i tried to run. I created a vi file called output.awk, wrote your code in it, then gave the root permissions to the file, then executed with sh output.awk, i got an error awk not found.
Code:
"output.awk" [New file] 24 lines, 815 characters
[gil@cx01:~]$
>chmod 777 output.awk
[gil@cx01:~]$
>ls -la
total 9570034
drwxr-xr-x 2 bscscx bscs 4 Feb 16 12:25 .
drwxr-xr-x 8 bscscx bscs 19 Feb 16 08:12 ..
-rw-r--r-- 1 bscscx bscs 4895889520 Feb 16 08:37 input
-rwxrwxrwx 1 bscscx bscs 815 Feb 16 12:25 output.awk
[gil@cx01:~]$
>sh output
output.awk: wk: not found
Moderator's Comments:
Seriously: PLEASE use CODE tags as required by forum rules!
As I already noted in here....
Save the code post 5 in a file called gil.awk and execute it as awk -f gil.awk input > output
I'm not sure how much easier the explanation can be....
Where exactly are you stuck?
@Rudic, please i'm very new with this. Below your code, just how i wrote it on my file. I created a vi file called gil. In it i put your code, and then i executed it as a sh script with sh filename(gil) command. My input file is DS2_export100217.ldif, and i redirect the result in an output file called output. Please tell me if i did something wrong.
This doesn't match what you posted in post#16.
As I said in post#17, when I do exactly what you describe in post#20, I don't have a problem, a file "output" is created with the expected contents.
What's your OS, shell, and awk versions? Any error messages when you run your approach?
Hi everyone,
I have a csv file which has data with different heading and column names as below.
Static Data Ingested
,,,,,,,,,,,,Known Explained Rejections
Column_1,column_2,Column_3,Column_4,,Column_6,Column_7,,% Column_8,,Column_9 ,Column_10 ,... (14 Replies)
Hi Guys,
I am new to shell script.I need your help to write a shell script.
I need to write a shell script to extract data from a .csv file where columns are ',' separated.
The file has 7 columns having values say column 1,column 2.....column 7 as below along with their values.
Name, Address,... (7 Replies)
Hi Guys,
I am new to shell script.I need your help to write a shell script.
I need to write a shell script to extract data from a .csv file where columns are ',' separated.
The file has 5 columns having values say column 1,column 2.....column 5 as below along with their valuesm.... (1 Reply)
hi
i am trying to extract some specific data out of a text file using regular expressions with shell script
that is using a multiline grep .. and the tool i am using is pcregrep so that i can get compatibility with perl's regular expressions
for a sample data like this, i am trying to grab... (6 Replies)
If I have a log like :
Mon Jul 19 05:07:34 2010; TCP; eth3; 52 bytes; from abc to def
Mon Jul 19 05:07:35 2010; UDP; eth3; 46 bytes; from aaa to bbb
Mon Jul 19 05:07:35 2010; TCP; eth3; 52 bytes; from def to ghi
I will need an output like this :
Time abc to def... (1 Reply)
Hello Scripting Gurus,
I need help with extracting data from the XML file using shell script.
The data is in a large XML and I need to extract the id values of all completedworkflows. Here is a sample of it. Input and output data is also in the attached text files.
<wfregistry>... (5 Replies)
give me a shell-script which extract data from log file on a server by giving date and time as input (for both start time and end time) and it will give the logs generated during the given time as output. (4 Replies)
Hi,
This is the xml file that i have.
- <front-servlet platform="WAS4.0" request-retriever="SiteMinder-aware" configuration-rescan-interval="60000">
<concurrency-throttle maximum-concurrency="50" redirect-page="/jsp/defaulterror.jsp" />
- <loggers>
<instrumentation... (5 Replies)
Hello All,
I am starting with UNIX. Any help is highly appreciated.
How to extract data using UNIX shell script? And how do you export data using UNIX shell scripts into Microsoft Excel format?
Thank you. (3 Replies)
02-16-2017
