Need some help in reading/parsing a weblog file. The weblog file is a flatfile.
Example Records:
Code: Select all
^69.167.3.6^[09/Sep/2006:00:00:00 -0700]^GET /includes/css.jhtml?SectionID=null&id=null HTTP/1.1^200^21^0^80^http://www.xyz.com/help/stores/index.jhtml^Mozilla/4.0^profile=8155368725; flashCookie=6; SephSessID=69.167.3.6.29756115778517715; JSESSIONID=VGS0YTLX0FOEFLAUCLABXCQ; disable=disable; cmRS=t3=1157785249641&pi=Home^SephSessID=69.167.3.6.29756115778517715^
^129.123.104.5^[09/Sep/2006:00:00:00-0700]^GET/assets/dyn/category/C10610/C10610_hero.jpgHTTP/1.0^200^3572^0^80^http://www.xyz.com/browse/brand_hierarchy.jhtml?brandId=3866^Mozilla/4.0^language=EnglishUS; profile=8355672542; flashCookie=6; SephSessID=129.123.104.5.284841157783677969; JSESSIONID=BEE1UW1N1QOBNLAUCJBRXCQ; disable=disable; ForeseeLoyalty_MID_kINYBhFpco=65^-^
^129.123.104.5^[09/Sep/2006:00:00:00 -0700]^GET /assets/dyn/category/C10610/C10610_hdr.jpg HTTP/1.0^200^1812^0^80^http://www.xyz.com/browse/brand_hierarchy.jhtml?brandId=3866^Mozilla/4.0^language=EnglishUS; profile=8355672542; flashCookie=6; SephSessID=129.123.104.5.284841157783677969; JSESSIONID=BEE1UW1N1QOBNLAUCJBRXCQ; disable=disable; ForeseeLoyalty_MID_kINYBhFpco=65^-^
^65.101.153.101^[09/Sep/2006:00:00:00 -0700]^GET /browse/brand_hierarchy.jhtml?brandId=5843 HTTP/1.1^200^71387^0^80^http://www.xyz.com/;jsessionid=OD0DKHD4REI3HLAUCJABXCQ^Mozilla/5.0^language=EnglishUS; flashCookie=6; profile=8369491739; SephSessID=65.102.160.146.102161157782878917; JSESSIONID=OD0DKHD4REI3HLAUCJABXCQ; disable=disable; ForeseeLoyalty_MID_kINYBhFpco=33^SephSessID=65.102.160.146.102161157782878917^
IP_ADDRESS
HIT_DATE_TIME
URL_REQUEST
BYTES_SENT
TIME_TAKEN
COUNT
PORT_NO
REFER_URL
BROWSER
COOKIE_IN
COOKIE_OUT
Focussing on the field 'COOKIE_IN', the COOKIE_IN values for the above four records are:
Code: Select all
profile=8155368725; flashCookie=6; SephSessID=69.167.3.6.29756115778517715; JSESSIONID=VGS0YTLX0FOEFLAUCLABXCQ; disable=disable; cmRS=t3=1157785249641&pi=Home
language=EnglishUS; profile=8355672542; flashCookie=6; SephSessID=129.123.104.5.284841157783677969; JSESSIONID=BEE1UW1N1QOBNLAUCJBRXCQ; disable=disable; ForeseeLoyalty_MID_kINYBhFpco=65
language=EnglishUS; profile=8355672542; flashCookie=6; SephSessID=129.123.104.5.284841157783677969; JSESSIONID=BEE1UW1N1QOBNLAUCJBRXCQ; disable=disable; ForeseeLoyalty_MID_kINYBhFpco=65
language=EnglishUS; flashCookie=6; profile=8369491739; SephSessID=65.102.160.146.102161157782878917; JSESSIONID=OD0DKHD4REI3HLAUCJABXCQ; disable=disable; ForeseeLoyalty_MID_kINYBhFpco=33;
Result:
Code: Select all
8155368725
8355672542
8355672542
8369491739
If the profile is stationary at one place I can use the 'Field()' function to retrieve the required. But how do I do it if the position is varying. Can I uses MATCHES?
Any idea/solution/suggestion would be greatly appreciated.
Many Thanks,