Hi all , I have a file with billing CDR records in it. I need to parse that information (row format) . The purpose is to compare full content. The example I have given below is a single line record but it has two portions, (1) the line start with “!” and end with “1.2.1.8” and (2) second part where the data is separated by two strings (i.e.: <?> and </?>).
Please note I put "-" to separate the output.
Part1 : Each fields are separated by “!” , and I need the value only after x.x.x.x parameter.
Part 2:
I need just the values printed between the two fields (i.e.: <?> and </?>)
( Note: if the value is empty , we leave a space)
At the end I like to have the output printed together. Any help will be greatly appreciated.
Thanks
Gamini
more example ...
Last edited by vgersh99; 03-30-2010 at 05:36 PM..
Reason: code tags, PLEASE!
Not simple, but interesting. I want to proceed in different stages:
Here the first to cut the line with '!' delimiter and display the fields.
It's more readable for the next stage and that will give you an idea for the how-to (I'v put your data in 'infile') :
See what's the result, it's a beginning...
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:
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
Alister
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)
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)
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)
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)
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)
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)
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)
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)
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)