��� in an index

RE: ��� in an index

thanks for opening my eyes. I�ll try that.
BTW:
I stopped the times for reindexing a table in a4v6.2 and a5version4.5. The results were:

a4v6.2 13 seconds index files are 5.4 MB
a5v4.5 38 seconds index file is 800 KB


Lu

RE: ��� in an index

thanks for opening my eyes. I�ll try that.
BTW:
I stopped the times for reindexing a table in a4v6.2 and a5version4.5. Ther results weree:

a4v6.2

[csda1]

RE: ��� in an index

Ludwig,

It's telling you that it has an undefined function in the line.

STRTRN is not a function. STRTRAN is.

When in doubt, go back to the original code listed which worked.

Regards,

Ira J. Perlow
Computer Systems Design & Associates
[email protected]

RE: ��� in an index

I tried that. These are my conditions:
My customer table has a field named K_name.
I have created an index Name01 with an expression expression trim(K_name).

I tried to use the index expressions:
de_Umlaute(trim(K_Name)
de_umlaute(K_Name)
de_Umlaute(trim(K_Name)
which were created with the expression builder. Are those valid expressions or should they be named like

function de_Umlaute(trim(K_Name) ???

When I use the first ones I get an error saying

command:
de_Umlaute=strtan(de_Umlaute,trim(substr(oldvals,i,2)),trim(substr(newvals,i,2))
function is not recognized
This message only shows two ) at the end of the expression. In the expression builder I have 3)
Why???????



L. Beil
EMAIL: [email protected]

RE: ��� in an index

I tried that. These are my conditions:
My customer table has a field named K_name.
I have created an index Name01 with an expression expression trim(K_name).

I tried to use the index expressions:
de_Umlaute(trim(K_Name)
de_umlaute(K_Name)
de_Umlaute(trim(K_Name)
which were created with the expression builder. Are those valid expressions or should they be named like

function de_Umlaute(trim(K_Name) ???

When I use the first ones I get an error saying

command:
de_Umlaute=strtan(de_Umlaute,trim(substr(oldvals,i,2)),trim(substr(newvals,i,2))
function is not recognized
This message only shows two ) at the end of the expression. In the expression builder I have 3)
Why???????



L. Beil
EMAIL: [email protected]

[whanigsberg]

RE: ��� in an index

Ludwig:

You made a small typo. Try
function de_Umlaute as C(input_string as c)

Bill

RE: ��� in an index

Hi, Ira and others!
I�m new with a5, so I need a lot of help. I tried to use the function to change my index.

1. the table
Let�s say I have a simpe index for a table named customer.
Order expression is K_name

2. the function
I�ve tried to enter the following code with the Code Editor

function de_Umlaute as C()

oldvals="� � � � � � � "
newvals="AeOeUeaeoeue�!"

de_Umlaute=input_string
lenstg=len(newvals)
for i=1 to lenstg step 2
de_Umlaute=strtan(de_Umlaute,trim(substr(oldvals,i,2)),trim(substr(newvals,i,2)))

next

end function

3. saving
I then saved this function and tried to use it in the Index Builder. I found the new function in the list, so I tried to enter
de_Umlaute(K_name) or de_Umlaute(trim(K_Name)) under order expression and save it I got an error saying "Too many parameters"

Where�s my fault?????

L. Beil
EMAIL: [email protected]

[csda1]

RE: ��� in an index

Hi Bill,

Yes. Using a user-defined function, or any, non-standard dBase III/IV function for that matter in the index expression makes the index expression (stored in the *.cdx file) incompatible with other programs that may use the index directly. This would typically be another dBase III/IV compatible program using and changing the index outside the confines of Alpha 5. Using an ODBC connection would not have this problem.

Regards,

Ira J. Perlow
Computer Systems Design & Associates
[email protected]

[whanigsberg]

RE: ��� in an index

Hi again,

Ira, are you aware of any reliability issues connected to using user-defined functions in index expressions. I suppose there might be a speed penalty but is there anything else to worry about?

Thanks,
Bill

RE: ��� in an index

super, super, super!!!!

[csda1]

RE: ��� in an index

Hi Bill,

And just to obsess to the n'th degree, I combined unrolling the loop with less assignments and got this version that's about 8 times faster than your original.

function No_accents as C(input_string as C)
' Replaces accented characters with unaccented equivalents for sorting
' and indexing
no_accents=strtran(strtran(strtran(strtran(strtran(strtran(\
strtran(strtran(strtran(strtran(input_string,"�","E"),"�","E")\
,"�","C"),"�","e"),"�","e"),"�","e")\
,"�","c"),"�","a"),"�","a"),"�","o")

end function

The continuation line character backslash seems to have no effect on the final speed in case you are wondering.

Regards,

Ira J. Perlow
Computer Systems Design & Associates
[email protected]

[csda1]

RE: ��� in an index

Hi Bill,

I forgot one of the most useful spped enhancing techniques, referred to as "unrolling a loop"

While less generic, this runs about 5.5 times faster than your original example

function No_accents as C(input_string as C)
' Replaces accented characters with unaccented equivalents for sorting and indexing

no_accents=input_string

no_accents=strtran(no_accents,"�","E")
no_accents=strtran(no_accents,"�","E")
no_accents=strtran(no_accents,"�","C")
no_accents=strtran(no_accents,"�","e")
no_accents=strtran(no_accents,"�","e")
no_accents=strtran(no_accents,"�","e")
no_accents=strtran(no_accents,"�","c")
no_accents=strtran(no_accents,"�","a")
no_accents=strtran(no_accents,"�","a")
no_accents=strtran(no_accents,"�","o")

end function

Regards,

Ira J. Perlow
Computer Systems Design & Associates
[email protected]

[csda1]

RE: ��� in an index

Ludwig,

Just modify the expression simply as

function No_accents as C(input_string as C)
' Replaces accented characters with unaccented equivalents for sorting and indexing

oldvals="� � � � � � � � � � � � � � "
newvals="E E C e e e c a a o Aeaeoeoe"

no_accents=input_string

lenstg=len(newvals)
for i=1 to lenstg step 2
no_accents=strtran(no_accents,trim(substr(oldvals,i,2)),trim(substr(newvals,i,2)))
next

end function

My question is would the string "aof" come before or after "a�c" Depending on what you want, you may have to translate the o to o!, A to A! etc to make sure the regular alphabet characters show up where you want in the sort.

Regards,

Ira J. Perlow
Computer Systems Design & Associates
[email protected]

RE: ��� in an index

well done.
One problem lasts. Each letter repalces one other letter exactly but how can I replace by two?
� is equivalent to ae so how can I replace � by ae � by oe and � by oe?

Lu

RE: ��� in an index

Thanks for your help!!!!
I hope there is no remarkable speed difference when handling this way with 20000 records.
Lu