Mapping with series from master file and calculate count Post: 302451726

Sponsored Content

Top Forums Shell Programming and Scripting Mapping with series from master file and calculate count Post 302451726 by poweroflinux on Wednesday 8th of September 2010 12:27:57 AM

09-08-2010

Registered User

Mapping with series from master file and calculate count

Hi rdcwayx,

The above is the sample text in the file and the lines containing "ShortCode=tel:" are as follows:

Code:

08-Sep-2010 06:25:13,790|BJ#18774093|phtunes_app|1283544417589|NotifySmsReception|CP URL to be called : http://172.30.24.52/unitech_sms/unit...5027&ContentID=
08-Sep-2010 06:25:22,065|8923686645|ingames_off_app|1282497011910|NotifySmsReception|CP URL to be called : http://122.170.122.198/uninor/Triger...IN,1,IN,146530
08-Sep-2010 06:25:25,087|TN#18535122|phtunes_app|1283544417589|NotifySmsReception|CP URL to be called : http://172.30.24.52/unitech_sms/unit...5043&ContentID=
08-Sep-2010 06:25:32,892|9173004391|aclwireless_app|1282498070897|NotifySmsReception|CP URL to be called : http://203.122.58.164/uninorintegrat...OIN%20TIGERWEB
08-Sep-2010 06:25:35,764|UK#13410667|phtunes_app|1283544417589|NotifySmsReception|CP URL to be called : http://172.30.24.52/unitech_sms/unit...5056&ContentID=
08-Sep-2010 06:25:54,890|UK#22838630|phtunes_app|1283544417589|NotifySmsReception|CP URL to be called : http://172.30.24.52/unitech_sms/unit...5067&ContentID=
08-Sep-2010 06:25:58,736|7398952682|aclwireless_app|1282498070897|NotifySmsReception|CP URL to be called : http://203.122.58.164/uninorintegrat...IN%20CUTEPRIYA
08-Sep-2010 06:25:59,728|8923686645|ingames_off_app|1282497011910|NotifySmsReception|CP URL to be called : http://122.170.122.198/uninor/Triger...IN,1,IN,146530
08-Sep-2010 06:26:08,146|7398952682|aclwireless_app|1282498070897|NotifySmsReception|CP URL to be called : http://203.122.58.164/uninorintegrat...N%20CUTE_PRIYA
08-Sep-2010 06:26:19,274|UP#23845782|phtunes_app|1283544417589|NotifySmsReception|CP URL to be called : http://172.30.24.52/unitech_sms/unit...5077&ContentID=

Quote:

Originally Posted by rdcwayx

I don't see the string "ShortCode=tel:" in your sample file.

poweroflinux

View Public Profile for poweroflinux

Find all posts by poweroflinux

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

calculate the average of time series data using AWK

Hi, I have two time series data (below) merged into a file. t1 and t2 are in unit of second I want to calculate the average of V1 every second and count how many times "1" in V2 is occur within a second Input File: t1 V1 t2 V2 10.000000...

2. Programming

Mapping all file at once or by page

This might be a silly question but I was wondering if, in case of huge files (2-3GB), it is more efficient to map the whole file at once, or to map it page by page. The file has to be processed sequentially from the start to the end. Thanks.

3. Shell Programming and Scripting

Parse file from remote server to calculate count of string existence in that file

Hi I need to parse the file of same name which exist on different servers and calculate the count of string existed in both files. Say a file abc.log exist on 2 servers. I want to search for string "test" on both files and calculate the total count of search string's existence. For...

4. Shell Programming and Scripting

Grep string from logs of last 1 hour on files of 2 different servers and calculate count

Hi, I am trying to grep a particular string from the files of 2 different servers without copying and calculate the total count of its occurence on both files. File structure is same on both servers and for reference as follows: 27-Aug-2010...

5. Shell Programming and Scripting

Calculate age of a file | calculate time difference

Hello, I'm trying to create a shell script (#!/bin/sh) which should tell me the age of a file in minutes... I have a process, which delivers me all 15 minutes a new file and I want to have a monitoring script, which sends me an email, if the present file is older than 20 minutes. To do...

6. Shell Programming and Scripting

Creating unique mapping from multiple mapping

Hello, I do not know if this is the right title to use. I have a large dictionary database which has the following structure: where a b c d e are in English and p q r s t are in a target language., the two separated by the delimiter =. What I am looking for is a perl script which will take...

7. Shell Programming and Scripting

Search and replace with mapping from a mapper file in a target file

Hello, I have a special problem. I have a file in 8 bit and would like to convert the whole database to 16Bit unicode. The mapping file has the following structure: The mapper is provided as a zip file The target file to be converted contains data in English and 8 bit Urdu mapping, a...

8. UNIX Desktop Questions & Answers

How can I replicate master master and master master MySQL databse replication and HA?

I have an application desigend in PHP and MySQl running on apache web server that I is running on a Amazon EC2 server Centos. I want to implement the master-master and master slave replication and high availability disaster recovery on this application database. For this I have created two...

9. Shell Programming and Scripting

Replacing 12 columns of one file by second file based on mapping in third file

i have a real data prod file with 80+ fields containing 1k -2k records. i have to extract say 12 columns out of this which are sensitive fields along with one primary key say SEQ_ID (like DOB,account no, name, SEQ_ID, govtid etc) in a lookup file. i have to replace these sensitive fields in...