Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: [awk] grep a part of filename as entry file
Top Forums Shell Programming and Scripting [awk] grep a part of filename as entry file Post 302695391 by pamu on Monday 3rd of September 2012 02:09:00 AM
Old 09-03-2012
Use below code to give date from the file name into the file entry...

As you have not clearly mentioned how you want the output of your csv, You can just add what you want to add(just grep after sed).

Code:
for i in *.csv
do
Date_var=$(echo "$i" | awk -F "[_.]" '{ print $6,$7,$8 }' OFS="_" )
sed 's/server1.example.com/'$Date_var',server1.example.com/1'   
done

If you are getting your desired output or need to add some specific data just add after the sed....
Code:
sed 's/server1.example.com/'$Date_var',server1.example.com/1'  | grep "erver1.example.com" >> final_output.csv

This User Gave Thanks to pamu For This Post:
makan
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

grep and awk showing filename in loop

I am attempting to grep a list of files for a string an and then only extract the 3rd and 4th field of from the line. That's easy. But I want to prefix the line with the filename that the information came from. for filename in `ls -1 *.txt' do grep search_text $filename | awk '{print $3"... (5 Replies)
Discussion started by: sjohns6
5 Replies

2. UNIX for Dummies Questions & Answers

grep for password file entry

How would I grep for password file entry without using grep 'username' /etc/passwd? perhaps with who? I want to create alias that will find the password file entry regardless of the user who is using it. I am trying to get the same exact line from the file entry like: Name : Password : UserID... (7 Replies)
Discussion started by: alis
7 Replies

3. UNIX Desktop Questions & Answers

How to grep for password file entry

How would I grep for password file entry without using grep 'username' /etc/passwd? perhaps with who? I want to create alias that will find the password file entry regardless of the user who is using it. Thanks (4 Replies)
Discussion started by: alis
4 Replies

4. UNIX for Dummies Questions & Answers

to extract all the part of the filename before a particular word in the filename

Hi All, Thanks in Advance I am working on a shell script. I need some assistance. My Requirement: 1) There are some set of files in a directory like given below OTP_UFSC_20120530000000_acc.csv OTP_UFSC_20120530000000_faf.csv OTP_UFSC_20120530000000_prom.csv... (0 Replies)
Discussion started by: aealexanderraj
0 Replies

5. Programming

to extract all the part of the filename before a particular word in the filename

Hi All, Thanks in Advance I am working on a shell script. I need some assistance. My code: if then set "subscriber" "promplan" "mapping" "dedicatedaccount" "faflistSub" "faflistAcc" "accumulator"\ "pam_account"; for i in 1 2 3 4 5 6 7 8;... (0 Replies)
Discussion started by: aealexanderraj
0 Replies

6. Shell Programming and Scripting

Diff between grep .* file name and grep '.*' filename

Hi, Can anyone let me know what is difference between grep .* foo.c grep '.*' foo.c I am not able to understand what is exact difference. Thanks in advance (2 Replies)
Discussion started by: SasDutta
2 Replies

7. Shell Programming and Scripting

Need to grep certain entry out of log file

This one is a bit too challenging for me... Hopefully you guys can help. Let's say I have a log file called: "$MW_HOME/user_projects/domains/IDMDomain/servers/wls_ods?/logs/wls_ods1-diagnostic.log" In this log file I want to search for "DIP-10219". When I execute this $ cat... (7 Replies)
Discussion started by: exm
7 Replies

8. Shell Programming and Scripting

Use grep/awk to remove part of column

hi all, how can i use grep or awk to clean the following input data: n<>the<>96427210 861521305 123257583 n<>obj<>79634223 861521305 79634223 n<>nmod<>68404733 861521305 68422718 where the desired results is to remove all non-numeric characters?: 96427210 861521305 123257583 ... (5 Replies)
Discussion started by: owwow14
5 Replies

9. Shell Programming and Scripting

Grep/awk part of info of a column

I have a question that I am at a loss to solve. I have 3 column tab-separated data, such as: abs nmod+n+n-commitment-n 349.200023 abs nmod+n+n-a-commitment-n 333.306429 abs into+ns-j+vn-pass-rb-divide-v 295.57316 abs nmod+n+ns-commitment-n 182.085018 abs nmod+n+n-pledge-n ... (2 Replies)
Discussion started by: owwow14
2 Replies

10. UNIX for Dummies Questions & Answers

How to grep for first entry in a file?

Hello friends, I have a question. Sometimes I have to search for an entry in a file that is repeated thousands of times. Can you tell me how to search so that i get limited results? For example: file: myfile.txt grep "hello world" myfile.txt this above grep will generate 5000... (4 Replies)
Discussion started by: DallasT
4 Replies

LEARN ABOUT V7

asadmin-stop-instance

asadmin-stop-instance(1AS)					   User Commands					asadmin-stop-instance(1AS)

NAME

       asadmin-stop-instance, stop-instance - stops the specified server instance and all the services associated with it

SYNOPSIS

       stop-instance  [--user  admin_user]  [--password  admin_password]  [--host local_host] [--port 4848] [--local=false] [--domain domain_name]
       [--secure|-s]instance_name

       Use the stop-instance to stop the instance with the instance name specified. The stop-instance can be run both locally and  remotely.   The
       named instance must already exist within the given domain; and the instance must be running.

OPTIONS

       --user		       administrative user associated for the instance.

       --password	       administrative password corresponding to the administrative user.

       --host		       host name of the machine hosting the administrative instance.

       --port		       administrative port number associated with the administrative host.

       --local		       determines if the command should delegate the request to administrative instance or run locally.

       --domain 	       name of the domain.

       --passwordfile	       file containing passwords appropriate for the command (e.g., administrative instance).

       --secure 	       if true, uses SSL/TLS to communicate with the administrative instance.

OPERANDS

       instance_name	       name of the instance to be stopped.

       Example 1: Using stop-instance in local mode

       asadmin> stop-instance --local --domain domain1 server1
       Instance server1 stopped

       Where: the server1 instance associated with the domain1 domain is stopped locally.

       Example 2: Using stop-instance in remote mode

       asadmin> stop-instance --user admin --password bluestar --host localhost --port 4848 server1
       Instance server1 stopped

       Where: the server1 instance associated with the named user, password, host and port is deleted from the remote machine.

EXIT STATUS

       0		       command executed successfully

       1		       error in executing the command

INTERFACE EQUIVALENT

       Server Instance page

       asadmin-delete-instance(1AS),   asadmin-start-instance(1AS),  asadmin-create-instance(1AS),  asadmin-restart-instance(1AS),  asadmin-start-
       appserv(1AS), asadmin-stop-appserv(1AS), asadmin-start-domain(1AS), asadmin-stop-domain(1AS)

J2EE 1.4 SDK							    March 2004						asadmin-stop-instance(1AS)
All times are GMT -4. The time now is 11:52 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy