Gossamer Forum: Products: Gossamer Links: Discussions: Looking for some way to check data

Apr 8, 2004, 8:48 AM

carfac

Veteran (1240 posts)

Apr 8, 2004, 8:48 AM

Post #1 of 3

Shortcut

Looking for some way to check data

Hi:

The way my links install is set up, I have many fields that it is important that they end in the last character of the entry- my templates supply a period after the data. Now and again, I get a little sloppy, and a final space get's in there- let's face it, a space is not too easy to spot. But that space looks really ugly in the page view- a space between the enty and the period just looks sloppy!

Is there some quick and dirty code I can run (perl orMySQL) on specific fields that will return all ID numbers of links that the field ends in a space?
dave

Big Cartoon DataBase
Big Comic Book DataBase

Apr 8, 2004, 9:39 AM

pugdog

Veteran / Moderator (6956 posts)

Apr 8, 2004, 9:39 AM

Post #2 of 3

Shortcut

Re: [carfac] Looking for some way to check data In reply to

From the mysql docs:

Quote:

Values in VARCHAR columns are variable-length strings. You can declare a VARCHAR column to be any length from 0 to 255, just as for CHAR columns. (Before MySQL 4.0.2, the length of VARCHAR may be from 1 to 255.) However, in contrast to CHAR, VARCHAR values are stored using only as many characters as are needed, plus one byte to record the length. Values are not padded; instead, trailing spaces are removed when values are stored. (This space removal differs from the standard SQL specification.) No case conversion takes place during storage or retrieval.

Quote:

TRIM([[BOTH | LEADING | TRAILING] [remstr] FROM] str) [/url]Returns the string str with all remstr prefixes and/or suffixes removed. If none of the specifiers BOTH, LEADING or TRAILING is given, BOTH is assumed. If remstr is not specified, spaces are removed. mysql> SELECT TRIM(' bar '); -> 'bar' mysql> SELECT TRIM(LEADING 'x' FROM 'xxxbarxxx'); -> 'barxxx' mysql> SELECT TRIM(BOTH 'x' FROM 'xxxbarxxx'); -> 'bar' mysql> SELECT TRIM(TRAILING 'xyz' FROM 'barxxyz'); -> 'barx'

on a test set of data (not your live data)

Try something like:

update prefix_Links
set field_name = TRIM(TRAILING ' ' FROM field_name)

PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.

Apr 9, 2004, 7:46 AM

carfac

Veteran (1240 posts)

Apr 9, 2004, 7:46 AM

Post #3 of 3

Shortcut

Re: [pugdog] Looking for some way to check data In reply to

Thanks Pugdog-
dave

Big Cartoon DataBase
Big Comic Book DataBase