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 particular letter in the first column

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= НЕСЕБЪР

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 --=NewRecord=-- delimiter between fields and data

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

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

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 starts with skill_begin and it ends with skill_end. between those 2

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 and it ends with skill_end. between those 2 words