Re: How to sum up values

2007-04-25 Thread Stanislav Nedelchev
Rob Dixon wrote: > Andrej Kastrin wrote: >> Dear all, >> >> Question about the sum function; the file structure is as follows: >> >> A|100 >> A|200 >> A|150 >> B|20 >> B|90 >> C|10 >> C|30 >> C|300 >> >> The result I want to obtain is to sum values in the second column >> (columnB) for each particu

Re: Data Mungling - Address Book;

2007-04-10 Thread Stanislav Nedelchev
Chas Owens wrote: > On 4/10/07, Stanislav Nedelchev <[EMAIL PROTECTED]> wrote: >> Hi to all >> Here is my problem . I'm trying to export this data to SQL database . >> Here is example data.Don't pay attention on encoding. Every new record >> is starting

Data Mungling - Address Book;

2007-04-10 Thread Stanislav Nedelchev
Hi to all Here is my problem . I'm trying to export this data to SQL database . Here is example data.Don't pay attention on encoding. Every new record is starting --=NewRecord=-- delimiter between fields and data is = . Contact=АГППМП-СЪНИМЕД-ООД Manager= Region=РЗОК Бургас Municipality= НЕСЕБЪР Se

Text parsing ?

2007-04-06 Thread Stanislav Nedelchev
Hi to all, I;m trying to parse one text file and insert it into database . Here is the example of Data CONTACT : Chemico Ltd. MANAGER : Michael Kor STATE: Blagoevgrad CODE : 4005 City: Blagoevgrad Address : Neupaoer Str. 1 Phone : 073/880755 Name : Valeri lItov lItov - Cadr Name : Nikoilai Michev

Re: Data manipulation.

2007-03-23 Thread Stanislav Nedelchev
Rob Dixon wrote: > Stanislav Nedelchev wrote: >> >> Hi to all , >> I'm trying to make one script that analyzes some data from a file. >> One guy from internet help me a lot . >> Here is how data is organized . >> Every row starts with skill_begin an

Re: Data manipulation.

2007-03-23 Thread Stanislav Nedelchev
John W. Krahn wrote: > Stanislav Nedelchev wrote: >> Hi to all , > > Hello, > >> I'm trying to make one script that analyzes some data from a file. >> One guy from internet help me a lot . >> Here is how data is organized . >> Every row sta

Data manipulation.

2007-03-23 Thread Stanislav Nedelchev
Hi to all , I'm trying to make one script that analyzes some data from a file. One guy from internet help me a lot . Here is how data is organized . Every row starts with skill_begin and it ends with skill_end. between those 2 words there is field_name = some_data and etc. Some rows has more field