Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Script to extract fields
Top Forums Shell Programming and Scripting Script to extract fields Post 302269373 by cfajohnson on Wednesday 17th of December 2008 01:23:51 PM
Old 12-17-2008
Code:
sed '
s/.*<agiml>//  # remove up to <agiml>
s|</agiml>.*|| # remove </agiml> to end of line
s/<[^>]*>/,/g  # convert tags to commas
s/,,*/,/g      # compress multiple commas to a single comma
s/^,//         # remove leading comma
s/,$//         # remove trailing comma
' FILE

Last edited by cfajohnson; 12-17-2008 at 02:42 PM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to extract fields for /etc/passwd

hi, i would like to extract the just name field from /etc/passwd file, and nothing else. ie grep pauline, and Pauline Fowler comes back. cheeers paul mc (6 Replies)
Discussion started by: mopimp
6 Replies

2. Shell Programming and Scripting

Extract fields from from this

thank youuuu (0 Replies)
Discussion started by: rnallamothu
0 Replies

3. Shell Programming and Scripting

Awk Command to extract Fields

Hi I am newbie.My requirement is: I have start time :Wed Apr 30 3:30:45 End time :Wed Apr 30 3:35:45 which is stored in a file. I have to extract timestamp 3:30:45 using awk. And Subtract the same The script: ---------- #!/bin/ksh LOG_FILE=$1 START_TIME=`head -2 $LOG_FILE... (1 Reply)
Discussion started by: usshell
1 Replies

4. Shell Programming and Scripting

Extract fields

Hi, I have a tmp file like below: <ADATA> ANUM=900 ADESC=Saving ATYP=0 TXREGD=0 </ADATA> <ADATA> ANUM=890 ADESC=Saving ATYP=0 ABAL=9000 TXREGD=1 </ADATA> <ADATA> (2 Replies)
Discussion started by: kunigirib
2 Replies

5. UNIX for Dummies Questions & Answers

How to extract fields from etc/passwd file?

Hi! i want to extract from /etc/passwd file,the user and user info fileds, to a another file.I've tried this: cut -d ':' -f1 ':' -f6 < file but cut can be used to extract olny one field and not two. maybe with awk is this possible? (4 Replies)
Discussion started by: strawhatluffy
4 Replies

6. Shell Programming and Scripting

Extract fields from different rows.

Hi, I have data like below. SID=D6EB96CC0 HID=9C246D6 CSource=xya Cappe=1 Versionc=3670 MAR1=STL MARS2=STL REQ_BUFFER_ENCODING=UTF-8 REQ_BUFFER_ORIG_ENCODING=UTF-8 RESP_BODY_ENCODING=UTF-8 CON_ID=2713 I want to select CSource=xya (18 Replies)
Discussion started by: chetan.c
18 Replies

7. Shell Programming and Scripting

Need to run an API from a script and extract fields from output of API

Hi, I need to call an API (GetUsageDetails)from inside a shell script which takes an input argument acct_nbr. The output of API will be like : <usageAccum accumId="450" accumCaptn="PM_125" inclUnits="1410.00" inclUnitsUsed="744.00" shared="true" pooled="false" prorated="false"... (1 Reply)
Discussion started by: rkrish
1 Replies

8. UNIX for Dummies Questions & Answers

Extract fields before search pattern

Hi, I have below file structure and need to display hours, minutes and seconds as different fields. Incase hour or minute field is not there it should default to zero. *** Total elapsed time was 2 hours, 54 minutes and 40 seconds. *** Total elapsed time was 42 minutes and 36 seconds.... (7 Replies)
Discussion started by: fristyguy
7 Replies

9. Shell Programming and Scripting

How to extract fields containing specific strings?

Hello I have a log file with thousands of lines like below Sep 21 13:02:52 lnxtst01 kernel: New TCP in: IN=eth0 OUT= MAC=00:1a:4b:50:b7:32:00:08:e3:ff:fc:04:08:00 SRC=10.184.46.4 DST=10.162.139.21 LEN=60 TOS=0x00 PREC=0x00 TTL=59 ID=52961 DF PROTO=TCP SPT=55688 DPT=22 WINDOW=5840 RES=0x00 SYN... (3 Replies)
Discussion started by: magnus29
3 Replies

10. UNIX for Beginners Questions & Answers

How to extract fields from a CSV i.e comma separated where some of the fields having comma as value?

can anyone help me!!!! How to I parse the CSV file file name : abc.csv (csv file) The above file containing data like abv,sfs,,hju,',',jkk wff,fst,,rgr,',',rgr ere,edf,erg,',',rgr,rgr I have a requirement like i have to extract different field and assign them into different... (4 Replies)
Discussion started by: J.Jena
4 Replies

LEARN ABOUT HPUX

rpccp_help

help(1m)																  help(1m)

NAME

       help - Displays a list of commands or the options of a specified command

SYNOPSIS

       rpccp help [rpccp-command]

ARGUMENTS

       Specifies one of the following control commands:

DESCRIPTION

       The help command displays information about the RPCCP command set or the options and argument associated with a specific command.

NOTE

       This command may be replaced in future releases by the dcecp command, and may no longer be supported at that time.

EXAMPLES

       The  following  command operates from the system prompt to display the internal commands of the control program: $ rpccp help The following
       commands start the control program and display the syntax of the remove entry command: $ rpccp rpccp> help remove entry

RELATED INFORMATION

       Commands: add element(1m), add entry(1m), add member(1m), export(1m), import(1m), remove element(1m), remove entry(1m),	remove	group(1m),
       remove  mapping(1m),  remove member(1m), remove profile(1m), rpccp(1m), show entry(1m), show group(1m), show mapping(1m), show profile(1m),
       show server(1m), unexport(1m)

																	  help(1m)
All times are GMT -4. The time now is 07:25 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy