Textmanagement missing convert to propercase

[flabes]

Find in Helpfile Uppercase and lowercase.

But I did not find Propercase.

(Convert First letter in Upper- rest in lowercase)

Any Idea where to find this function?

[water]

Something like

[flabes]

Hallo Water,

I have downloaded yr excelEx

It is great to see, what your Functions are doing and i keep it for further use.

But it doesn't solve my Problem.

I am Catching from a Website the deliveryadress.

Sometimes I get this:

frank nobody

mainstreet 24

frankfurt

I like to have that:

(This is how it looks after conversion into Propercase with VB)

Frank Nobody

Mainstreet 24

Frankfurt

That means:

In Visual Basic I have 3 possibilities.

Convert into Uppercase, Lowercase and Propercase

Cant find anything like this in your ExcelEx.

Any more Ideas?

[BrewManNH]

You need to click on the link he posted, there's a snippet of code there for casing the strings like you asked for.

This is what I use, but it's probably not very Unicode friendly.

Func _TitleCaseString($s_String) ; modified _StringProper function, correctly capitalizes after ' ( ) and numbers
    If IniRead($sIniFile, "Settings", "AutoCorrect", 1) = 0 Then Return $s_String
    Local $iX = 0
    Local $CapNext = 1
    Local $s_nStr = ""
    Local $s_CurChar
    For $iX = 1 To StringLen($s_String)
        $s_CurChar = StringMid($s_String, $iX, 1)
        Select
            Case $CapNext = 1
                If StringRegExp($s_CurChar, "[a-zA-Z\xC0-\xFF0-9]") Then
                    $s_CurChar = StringUpper($s_CurChar)
                    $CapNext = 0
                EndIf
            Case Not StringRegExp($s_CurChar, "[a-zA-Z\xC0-\xFF'0-9]")
                $CapNext = 1
            Case Else
                $s_CurChar = StringLower($s_CurChar)
        EndSelect
        $s_nStr &= $s_CurChar
    Next
    Return $s_nStr
EndFunc   ;==>_TitleCaseString

There is also a _StringProper function in the Strings.au3 file, that this is based off of, but that works like the Proper function in Excel and has many issues with text casing.

[water]

Exactly. ExcelEX has - as the name implies - to do with Excel, not text processing