Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

HELP : awk substr

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting HELP : awk substr
# 1  
Old 05-10-2015
HELP : awk substr
Hi,
- In a file test.wmi
Code:
Col1 | firstName | lastName
4003 | toto_titi_CT- | otot_itit

- I want to have only ( colones $7,$13 and $15) with code 4003 and 4002. for colone $13 I want to have the whole name untill _CT- or _GC-

1- I used the command egrep with awk

Code:
#egrep -i "EventID=4002|EventID=4003" test.wmi |awk -F '[=|<|>]' '{print $7, substr($13,1,38),$15 }'

file out:
Code:
4003   GTWPRD_FT_Assurnet_controle_flux_CT-As         st_assurnet_controleMSG_decompte_rejet_AMO:
4003   SAVKHE_SV_SAVJ_GC_ALICIA_RH_SAUVEGARDE    lance_tina:
4003   ASSNET_ST_CYCLIQUE                                     expl_st_pilot_export:
4003   ASSNET_ST_CYCLIQUE                                     expl_st_cftenv:
4003   GTWPRD_FT_Assurnet_controle_flux                    CT-Assurnet_controle_flux:
4003   GTWPRD_FT_Assurnet_controle_flux_CT-As          Put_Fichier_Decompte_AMC:
4003   GTWPRD_FT_Assurnet_controle_flux_CT-As          Put_Fichier_Assure_AMC:

2- I used sed to avoid the : in the end of 3rd colone
Code:
[tmp]# egrep -i "EventID=4002|EventID=4003" test.wmi |awk -F '[=|<|>]' '{print $7, substr($13,1,38),$15 }' | sed 's/:[ \t]*//'

file out-
Code:
4003  GTWPRD_FT_Assurnet_controle_flux_CT-As           st_assurnet_controleMSG_decompte_rejet_AMO
4003  SAVKHE_SV_SAVJ_GC_ALICIA_RH_SAUVEGARDE      lance_tina
4003  ASSNET_ST_CYCLIQUE                                       expl_st_pilot_export
4003  ASSNET_ST_CYCLIQUE                                       expl_st_cftenv
4003  GTWPRD_FT_Assurnet_controle_flux                      CT-Assurnet_controle_flux
4003  GTWPRD_FT_Assurnet_controle_flux_CT-As             Put_Fichier_Decompte_AMC
4003  GTWPRD_FT_Assurnet_controle_flux_CT-As             Put_Fichier_Assure_AMC

- in the case i Have a name with _CT-"GTWPRD_FT_Assurnet_controle_flux_CT-As" i want only have the name before _CT- " GTWPRD_FT_Assurnet_controle_flux"
Can someone help me to find the command to do this
thks
georg
Last edited by georg2014; 05-10-2015 at 05:03 AM.. Reason: Add CODE and ICODE tags.
# 2  
Old 05-10-2015
I am completely lost.

You show us an input file containing 2 lines.

You show us an egrep that selects lines from that file containing the case insensitive string EventID and you magically produce seven lines of output when that string does not appear anywhere in your sample input file.

You show us a sample input file that contains two pipe symbols (|) and an awk script that uses the characters =, |, <, and > as field separators and prints all or parts of fields 7, 13, and 15 when your input file only contains three fields.

I do not understand where any of the data you showed us as sample output came from???
This User Gave Thanks to Don Cragun For This Post:
georg2014
# 3  
Old 05-10-2015
Wrong subforum... Please watch out where to post your problems!
This User Gave Thanks to DukeNuke2 For This Post:
georg2014
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk and substr

Hello All; I have an input file 'abc.txt' with below text: 512345977,213458,100021 512345978,213454,100031 512345979,213452,100051 512345980,213455,100061 512345981,213456,100071 512345982,213456,100091 512345983,213457,100041 512345984,213451,100011 I need to paste the first field... (10 Replies)
Discussion started by: mystition
10 Replies

2. Shell Programming and Scripting

awk substr

Hello life savers!! Is there any way to use substr in awk command for returning one part of a string from declared start and stop point? I mean I know we have this: substr(string, start, length) Do we have anything like possible to use in awk ? : substr(string, start, stop) ... (9 Replies)
Discussion started by: @man
9 Replies

3. Shell Programming and Scripting

Substr with awk

Hi to all, I'm here again, cause I need your help to solve another issue for me. I have some files that have this name format: date_filename.csv In my shell I must rename each file removing the date so that the file name is filename.csv To do this I use this command: fnames=`ls ${fname}|... (2 Replies)
Discussion started by: leobdj
2 Replies

4. Shell Programming and Scripting

awk substr

HI I am using awk and substr function to list out the directory names in the present working directory . I am using below code ls -l | awk '{ if ((substr($1,1,1)) -eq d) {print $9 }}' But the problem is i am getting all the files and directories listed where as the requirement i wrote... (7 Replies)
Discussion started by: prabhu_kumar
7 Replies

5. Shell Programming and Scripting

Help with awk and substr

I have the following to find lines matching "COMPLETE" and extract parts of it using substr. sed -n "/COMPLETE/p" 1.txt | awk 'BEGIN { FS = "\" } {printf"%s %s:%s \n", substr($3,17,3),substr($6,4,1), substr($7,4,1)}' | sort | uniq > temp.txt Worked fine until the numbers in 2nd & 3rd substr... (5 Replies)
Discussion started by: zpn
5 Replies

6. UNIX for Dummies Questions & Answers

substr first element using awk

I have a variable '$test' that has the following string value: $test = 123|456|789|0123 How would I select just the first element ('123') using awk. Note: '|' is the delimiter, and the length of each field can vary. Thanks, - CB (3 Replies)
Discussion started by: ChicagoBlues
3 Replies

7. Shell Programming and Scripting

awk substr

Hi I have multiple files that name begins bidb_yyyymm. (yyyymm = current year month of file creation). What I want to do is look at the files and where yyyymm is older than 1 month I want to remove the file from the server. I was looking at looping through the files and getting the yyyymm... (2 Replies)
Discussion started by: colesga
2 Replies

8. UNIX for Dummies Questions & Answers

awk or substr

i have a variable 200612 the last two digits of this variable should be between 1 and 12, it should not be greater than 12 or less than 1 (for ex: 00 or 13,14,15 is not accepted) how do i check for this conditions in a unix shell script. thanks Ram (3 Replies)
Discussion started by: ramky79
3 Replies

9. Shell Programming and Scripting

How to use awk substr ?

Hi all, I have a flatfile I would like to get ext = 7950 , how do I do that ? if ($1 == "CTI-ProgramStart") { ext = substr($9,index($9,"Extension")+11,4); But why it is not working ???? Please help . Thanks (1 Reply)
Discussion started by: sabercats
1 Replies

10. Shell Programming and Scripting

awk substr?

Sorry if this has been posted before, I searched but not sure what I really want to do. I have a file with records that show who has logged into my application: 2003-03-14:I:root: Log_mesg: registered servername:userid. (more after this) I want to pull out the userid, date and time into... (2 Replies)
Discussion started by: MizzGail
2 Replies
Login or Register to Ask a Question