RE: [sqr-users] Special Characters

["Alexander, Steve" <Steven.Alexander@sanjoseca.gov>]

The problem is that your database sort is by ascii values.  You might check
on whether there is an option for a dictionary sort, and if so, how it
works.  A dictionary sort might just be case-insensitive, or it might be
accent-mark insensitive.

If there isn't a sort option that helps, you might create another field on
the table (or use a view) that has only unaccented letters.

Or you could read the (almost) sorted data into an array, translate the name
to another field, removing the accents, and go through the array doing a
"touch-up" sort that shouldn't take very long.

-----Original Message-----
From: Miller, Danika [mailto:MillerD2@ndu.edu]
Sent: Thursday, July 22, 2004 1:37 PM
To: 'This list is for discussion about the SQR database reporting
languagef rom Hyperion Solutions.'
Subject: RE: [sqr-users] Special Characters


My code is in the actual print procedure,  which is after the order by
clause.

My procedure is as follows:

---------------------------------------------------------------------------
Begin-select 
a.last_name
a.first_name
a.middle_name

        move &a.last_name to $last_name
        move &a.first_name to $first_name
        move &a.middle_name to $middle_name

        do print-data

From table
Where 
Order by last name

---------------------------------------------------------------------------
Begin-procedure print-data
    if $middle_name = ' '
       let $final_name = $first_name  || ' ' || $last_name
     else
       let $final_name = $first_name || ' ' || $middle_name || ' ' ||
$last_name
     end-if

      do translate-characters($final_name, $final_name-fmt)

   print $final_name-fmt
        
end-procedure



-----Original Message-----
From: Bob Stone [mailto:bstone@fastenal.com] 
Sent: Thursday, July 22, 2004 4:13 PM
To: 'This list is for discussion about the SQR database reporting language
from Hyperion Solutions.'
Subject: RE: [sqr-users] Special Characters

I'm sure the ordering goes down to the ASCII where the special o is listed
after the regular o's.  although I'm not sure how sqr might handle that.
with your function are you ordering by last name with the special chars
before the do translate or are you translating first and ordering after?

I think you have to make your ó look like an o while you order it, and then
back to the ó for display.  Perhaps you could have a non-special char name
variable that would list Gómez as Gomez, then order it and print the actual
name?  

bob stone

-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org]On Behalf Of
Miller, Danika
Sent: Thursday, July 22, 2004 2:56 PM
To: 'sqr-users@sqrug.org'
Subject: [sqr-users] Special Characters


Has anyone worked with special characters before?

 

I have a last name of Gómez Suarez and a last name of Gutiérrez Roa.  When I
order by last name Gutierrez Roa comes first???  

Any ideas??

 

I have the following code in my program that translates special characters:

 

   do translate-characters($final_name, $final_name-fmt)

 

 

 

 

Please help!!!

 

 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users