Sponsored Content
Full Discussion: Parsing data
Top Forums Shell Programming and Scripting Parsing data Post 302408862 by alister on Tuesday 30th of March 2010 06:27:53 PM
Old 03-30-2010
Hello, jaygimini:

No offense, but you were a bit lazy with your help request. There are five lines of sample input and not a single complete example of desired output. It would have been much better if you had, for each input sample, provided the corresponding sample output exactly as it is desired. At least, I, personally, think it would have been very helpful. (For example, I'm not sure if the "-" in the output is desired in the actual output or if you merely used it in the example to make it more readable.)

For the first part of the problem, you state that you only want the data in the exclamation point-delimited field when it follows a word of the form x.x.x.x? Are fields 1 and 2 an exception to that rule, because 4 and 101 are not preceded by an x.x.x.x word?

Unlike your first line of sample data, the four lines at the end of your post have an additional exclamation point-delimited field. Should it be treated like the first part of the line, if it begins with a x.x.x.x word, include it in the output?

Any other special cases that may have been overlooked?

Regards,
Alister

---------- Post updated at 06:27 PM ---------- Previous update was at 05:18 PM ----------

In case it's of any help:
Code:
sed 's/! TICKET NBR : //; s/! GSI : //; s/! \([0-9]\{1,\}\.\)\{3\}[0-9]\{1,\} *\([^!]*\)/\2/g;
s/ *!\( *[^ ]*\)\{0,2\}//g; s/<\([^>]*\)>\([^<]*\)<\/\1> */\2 /g' data

This solution assumes that every exclamation point that appears in the line serves as a delimiter.

Test run on a data file which consists of 5 lines, the same 5 lines you provided in your original post, in the same order as they occurred in your post (the one line near the beginning of it and the four at the end). I originally included the contents of the data file, but they broke the forum layout at my current display resolution. Speaking of being lazy, I suppose I could've attached it Smilie
Code:
4 101 04/03/2010 12:33:33 acc_22640827031004 CYCL_ST 2898381018 00092898381018 Mobility 10.00 0.50  Inactive     10.00 0.50 302612898381018 
1 101 04/03/2010 14:08:24 acc_22640827031004 CYCL_ST 2898381018 00092898381018 Mobility 10.00 0.50  Active     10.00 0.50 302612898381018 4
2 101 04/03/2010 15:59:59 acc_1234567890 CYCL_ST 7805250631 007805250631 Mobility 0.00 0.00  Active     0.00 0.00 000007805250631 4
3 101 04/03/2010 15:26:22 acc_1234567890 CYCL_ST 7805250631 007805250631 Mobility -10.00 0.00  Inactive     -10.00 0.00 000007805250631 4
4 101 04/03/2010 12:33:33 acc_22640827031004 CYCL_ST 2898381018 00092898381018 Mobility 10.00 0.50  Inactive     10.00 0.50 302612898381018 4

Alister

Last edited by alister; 03-30-2010 at 08:07 PM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Parsing the data in a file

Hi, I have file (FILE.tmp) having contents, FILE.tmp ======== filename=menudata records=0000000000037 ldbname=pinsys timestamp=2005/05/14-18:32:33 I want to parse it bring a new file which will look like, filename records ldbname timestamp... (2 Replies)
Discussion started by: Omkumar
2 Replies

2. Shell Programming and Scripting

Parsing the data

Hi I need to parse the following data using shell script Table ----- stage4n_abc 48 stage4o_abcd 4 adashpg_abc_HeartBeat 1 stage4l_asc 168 Can anyone gimme the solution. I want each value to get stored in an array or variable and want the value to be greped from another file.... (1 Reply)
Discussion started by: Archana.Dheepan
1 Replies

3. Shell Programming and Scripting

More efficent Data Parsing

I am looking for a way to parse out some numbers from text. This is an excerpt from a larger script that I am trying to make run a little smoother. Specifically this script is used to Capture DV video streams on a linux machine from the terminal. The setup does 6 streams at once, and this part... (3 Replies)
Discussion started by: Starcast
3 Replies

4. Shell Programming and Scripting

Parsing the data

Hi friends, I need to parse the following data in the given format and get the desired output. I need a function, which takes the input as a parameter and the desired output will be returned from the function. INPUT(single parameter as complete string) A;BCF;DFG;FD ... (3 Replies)
Discussion started by: sumesh.1988
3 Replies

5. Shell Programming and Scripting

Help in Parsing data

I have below string Transaction_ID:SDP-DM-151204679 , Transaction_DateTime:2011-02-11 00:00:15 GMT+05:30 , Transaction_Mode:WAP , Circle_ID:4 , Circle_Name:BJ ,Zone: , CustomerID:B_31563486 , MSISDN:7870904329 , IMSI:405876122068099 , IMEI: , Sub_Profile:Pre-Paid , CPID:Nazara , CPNAME:Nazara ,... (6 Replies)
Discussion started by: poweroflinux
6 Replies

6. Shell Programming and Scripting

Data parsing

Hi, I do have a data file which is divided into compartments by ---------. I would like to extract (parse) some of the data and numbers either using awk or sed The file has the format: CATGC Best GO enrichment: Genes/ORF that have the motifs (genes are sorted by max(pa+pd+po)): ... (6 Replies)
Discussion started by: Lucky Ali
6 Replies

7. Shell Programming and Scripting

Help with parsing data with awk , eliminating unwanted data

Experts , Below is the data: --- Physical volumes --- PV Name /dev/dsk/c1t2d0 VG Name /dev/vg00 PV Status available Allocatable yes VGDA 2 Cur LV 8 PE Size (Mbytes) 8 Total PE 4350 Free PE 2036 Allocated PE 2314 Stale PE 0 IO Timeout (Seconds) default --- Physical volumes ---... (5 Replies)
Discussion started by: rveri
5 Replies

8. Shell Programming and Scripting

Parsing file data

Hey Guys, I'm a novice at shell scripts and i need some help parsing file data. Basically, I want to write a script that retrieves URLs. Here is what I have so far. #!/bin/bash echo "Please enter start date (format: yyyy-mm-dd):\c" read STARTDATE echo "Please enter end date... (7 Replies)
Discussion started by: silverdust
7 Replies

9. Shell Programming and Scripting

Parsing XML (and insert data) then output data (bash / Solaris)

Hi folks I have a script I wrote that basically parses a bunch of config and xml files works out were to add in the new content then spits out the data into a new file. It all works - apart from the xml and config file format in the new file with XML files the original XML (that ends up in... (2 Replies)
Discussion started by: dfinch
2 Replies

10. Shell Programming and Scripting

Parsing Bulk Data

Hi All, :D Actullay I am looking for a smart way :b: to parse files in a directory whose count is around 2000000 :eek: in a single day. Find is working with me but taking a lot of times :confused:, sometimes even a day which is not helping me.:wall: So anyone can help me know a smart... (5 Replies)
Discussion started by: jojo123
5 Replies
Packet sample action in tc(8)					       Linux					     Packet sample action in tc(8)

NAME
sample - packet sampling tc action SYNOPSIS
tc ... action sample rate RATE group GROUP [ trunc SIZE ] [ index INDEX ] tc ... action sample index INDEX DESCRIPTION
The sample action allows sampling packets matching classifier. The packets are chosen randomly according to the rate parameter, and are sampled using the psample generic netlink channel. The user can also specify packet truncation to save user-kernel traffic. Each sample includes some informative metadata about the original packet, which is sent using netlink attributes, alongside the original packet data. The user can either specify the sample action parameters as presented in the first form above, or use an existing sample action using its index, as presented in the second form. SAMPLED PACKETS METADATA FIELDS
The metadata are delivered to userspace applications using the psample generic netlink channel, where each sample includes the following netlink attributes: PSAMPLE_ATTR_IIFINDEX The input interface index of the packet, if there is one. PSAMPLE_ATTR_OIFINDEX The output interface index of the packet. This field is not relevant on ingress sampling PSAMPLE_ATTR_ORIGSIZE The size of the original packet (before truncation) PSAMPLE_ATTR_SAMPLE_GROUP The psample group the packet was sent to PSAMPLE_ATTR_GROUP_SEQ A sequence number of the sampled packet. This number is incremented with each sampled packet of the current psample group PSAMPLE_ATTR_SAMPLE_RATE The rate the packet was sampled with OPTIONS
rate RATE The packet sample rate. RATE is the expected ratio between observed packets and sampled packets. For example, RATE of 100 will lead to an average of one sampled packet out of every 100 observed. trunc SIZE Upon set, defines the maximum size of the sampled packets, and causes truncation if needed group GROUP The psample group the packet will be sent to. The psample module defines the concept of groups, which allows the user to match spe- cific sampled packets in the case of multiple sampling rules, thus identify only the packets that came from a specific rule. index INDEX Is a unique ID for an action. When creating new action instance, this parameter allows to set the new action index. When using existing action, this parameter allows to specify the existing action index. The index must 32bit unsigned integer greater than zero. EXAMPLES
Sample one of every 100 packets flowing into interface eth0 to psample group 12: tc qdisc add dev eth0 handle ffff: ingress tc filter add dev eth0 parent ffff: matchall action sample rate 100 group 12 index 19 Use the same action instance to sample eth1 too: tc qdisc add dev eth1 handle ffff: ingress tc filter add dev eth1 parent ffff: matchall action sample index 19 SEE ALSO
tc(8), tc-matchall(8) psample(1) iproute2 31 Jan 2017 Packet sample action in tc(8)
All times are GMT -4. The time now is 04:10 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy