If ur SQL supports unique indexes (I don't know why it wouldn't) u can let
it take care of the unique records problem. Decide what fields constitute a
"unique record" and make that a primary key, the database won't allow those
records to be duplicated. Then all u have to do is fire everything u'v
If ur SQL supports unique indexes (I don't know why it wouldn't) u can let
it take care of the unique records problem. Decide what fields constitute a
"unique record" and make that a primary key, the database won't allow those
records to be duplicated. Then all u have to do is fire everything u'v
>
> (1) use string length (number of characters a string holds):
>
> $length = length($name);
>
I'd stay away from this as it will eventually let you down. For example:
my $str1 = 'I'd stay away from this as it will eventually let you down.'
my $str2 = 'My Mom will not stop looking at Internet
If ur SQL supports unique indexes (I don't know why it wouldn't) u can let
it take care of the unique records problem. Decide what fields constitute a
"unique record" and make that a primary key, the database won't allow those
records to be duplicated. Then all u have to do is fire everything u'v
On Apr 11, 2005 11:22 AM, Craig Cardimon <[EMAIL PROTECTED]> wrote:
> I am working with huge ASCII text files and large text fields.
>
> As needs and wants have changed, I will be reprocessing data we have
> already gone through to see if more records can be extracted.
>
> I will need to compare
[EMAIL PROTECTED] wrote:
> I am working with huge ASCII text files and large text fields.
>
> As needs and wants have changed, I will be reprocessing data we have
> already gone through to see if more records can be extracted.
>
> I will need to compare strings to ensure that records I am inserti
I am working with huge ASCII text files and large text fields.
As needs and wants have changed, I will be reprocessing data we have
already gone through to see if more records can be extracted.
I will need to compare strings to ensure that records I am inserting
into our SQL Sever 2000 database
