While importing data from text files, delimiters (symbols used for divide fields and lines) sometimes remains in data.

[Alexey Starchikhin]

Yes, i tried another delimiter, the same bug remains. If you look into
attached file in the Mantis, it's visible in line 58 of VDB
file.(there are other places too) Line 58 is absolutely the same as
other lines, so i can't find any logical explanation.

Alexey


RZ> On 12/2/08 11:51 AM, "Alexey Starchikhin" <ssa at sevenrays.ru> wrote:

>> Hello list,
>> 
>> I added this to Mantis, just copying it here to ensure that issue will
>> be noticed and addressed ASAP.
>> 
>> --------
>> I'm using text files to bring data from MS Access to Valentina (ODBC doesn't
>> work with some special symbols).
>> I'm using "|" as field delimiter and " as string container. When i use Vstudio
>> importer it
>> works good for most data, but some fields end up this way: |some text"  Fields
>> are splitted correctly, because
>> both previous and next field in this line are correct, but this field contains
>> delimiters inside for some strange reason.
>> More to it, if i use importer several times in a row (import file - clear
>> table - import file..), after several attempts
>> database is corrupted.

RZ> Hi  Aleksey

RZ> I think we can schedule this in 3-5 days.

RZ> Have you try to use OTHER delimiter symbols ?





-- 
Best regards,
 Alexey                            mailto:ssa at sevenrays.ru