Posted by strawberry on 09/30/96 11:42

Just a thought - why not find/replace "R ERR"/"ERR" prior to importing


Ian Robinson wrote:
> Hi,
>
> A newbie to php and mySql so please bear with me.
>
> I have imported some data into a table but the first field has a leading "R
> " which I need to trim off all 4,000 records.
>
> Typically the field content is "R ERR3340" and I need to modify this value
> to be "ERR3340"
>
> I have tried
>
>
> UPDATE part_num,
> LTRIM( part_num, "R " ) FROM `source_premier`
>
>
> to no avail
>
> TIA
> Ian

• Next in forum: Re: Trim the leading characters of a field
• Prev in forum: Re: How to prevent "view sourse" of php database file
• Thread view: Re: Trim the leading characters of a field

[Reply to this message]