Hi Danilo,

export to MTF, create a simple XSLT stylesheet with a rule that copies the whole export file and apply the XPath function lower-case() to your <term> elements, and reimport the MTF file to an empty copy of your termbase. That's fast and easy.

Detlef

I would export the termbase to Excel (using the Glossary Converter), convert all to lowercase, and then reconvert to sdltb (termbase format).

Danilo Lopes Barbosa 

And just to add another idea... now you know how to use MS Access for your termbase you could save a copy of the termbase as an .accdb file and add this macro (Alt+F11):

Sub ConvertOrigTermToLower()
    Dim db As DAO.Database
    Dim rs As DAO.Recordset
    Dim sqlQuery As String

    Set db = CurrentDb()

    ' Process I_Portuguese table
    sqlQuery = "SELECT termid, origterm FROM I_Portuguese;"
    Set rs = db.OpenRecordset(sqlQuery, dbOpenDynaset)
    
    Do While Not rs.EOF
        rs.Edit
        rs!origterm = LCase(rs!origterm)
        rs.Update
        rs.MoveNext
    Loop
    rs.Close

    ' Process I_English table
    sqlQuery = "SELECT termid, origterm FROM I_English;"
    Set rs = db.OpenRecordset(sqlQuery, dbOpenDynaset)

    Do While Not rs.EOF
        rs.Edit
        rs!origterm = LCase(rs!origterm)
        rs.Update
        rs.MoveNext
    Loop
    rs.Close

    Set rs = Nothing
    Set db = Nothing

    MsgBox "All terms converted to lowercase successfully!", vbInformation
End Sub

Check the tables I used as this is for the last example we looked at.  But it seems to work and it's quick.

Just to add another possibility to the mix. Notepad++ has an easy function for converting everything to lowercase.

Thanks for all the responses! Converting the termbase to another format, then processing it, then re-importing it seems to be the way to go. I particularly like the possibilities that MS Access gives me!