Hi,

I have some imported data at a client site that has ended up with a leading
quotemark ( ' ) on a number of columns.  Is there anyway to trim it off?
I've tried the TRIM function but being a quotemark it confuses the
statement.

tried
TRIM ' FROM CustomerName
TRIM ''' FROM CustomerName

Any help would be appreciated.

--
Gavin Horne
www.hornesoftware.com.au

"Gavin Horne" <gavin@remove.me.hornesoftware.com.au> wrote on Thu, 8 Jun 2006 07:56:39 +0930

>Hi,
>
>I have some imported data at a client site that has ended up with a leading
>quotemark ( ' ) on a number of columns. Is there anyway to trim it off?
>I've tried the TRIM function but being a quotemark it confuses the
>statement.
>
>tried
>TRIM ' FROM CustomerName
>TRIM ''' FROM CustomerName
>
>Any help would be appreciated.
>
>--
>Gavin Horne
>www.hornesoftware.com.au
>
>
Gavin


I've never used it and I'm probably on a different version of DBISAM but ....

I'd expect you to need four quotes

i.e. TRIM '''' FROM CustomerName

HTH


Jeff



--
Jeff Cook
Aspect Systems Ltd
Phone: +64-9-424 5388
Skype: jeffcooknz
www.aspect.co.nz

Jeff Cook <jeffc@aspect.co.nz> wrote on Thu, 8 Jun 2006 10:39:14 +1200

>Gavin
>
>
>I've never used it and I'm probably on a different version of DBISAM but ....
>
>I'd expect you to need four quotes
>
>i.e. TRIM '''' FROM CustomerName
>

And reading the v3 manual - I think some parenthesis would be needed too:-

CustomerName = TRIM(LEADING '''' FROM CustomerName)

Cheers

Jeff
--
Jeff Cook
Aspect Systems Ltd
Phone: +64-9-424 5388
Skype: jeffcooknz
www.aspect.co.nz

Hi Jeff,

Thanks for that, it does help if you RTFM, stupid question  under pressure


However, I've also discovered that most of the fields have a leading space
before the quote as well so my statememt ended up

TRIM(LEADING '''' FROM LTRIM(AddressLine1))

Cheers,
Gavin Horne
www.hornesoftware.com.au


"Jeff Cook" <jeffc@aspect.co.nz> wrote in message
news:9C899A0D-1393-4EB3-9C9A-D2B2240045D7@news.elevatesoft.com...
> Jeff Cook <jeffc@aspect.co.nz> wrote on Thu, 8 Jun 2006 10:39:14 +1200
>
>>Gavin
>>
>>
>>I've never used it and I'm probably on a different version of DBISAM but
>>....
>>
>>I'd expect you to need four quotes
>>
>>i.e. TRIM '''' FROM CustomerName
>>
>
> And reading the v3 manual - I think some parenthesis would be needed too:-
>
> CustomerName = TRIM(LEADING '''' FROM CustomerName)
>
> Cheers
>
> Jeff
> --
> Jeff Cook
> Aspect Systems Ltd
> Phone: +64-9-424 5388
> Skype: jeffcooknz
> www.aspect.co.nz
>
>
>
>