Hey, so I have some automatic correction on an address box which seemingly works but some random invisible characters are appearing?
The field containing - "19 Lacaster Road,
Bfirmi Fng Ham
City
Road England" is 50 characters long but after going through the process to auto capitalize -
Set(r52, Trim(Concat(Split(DataCardValue52.Text,""),If(IsMatch(Result, "(\w|,|\s)"),If(IsMatch(Result, "\s") && !(Result = " "), "//////////", Result))))); Set(r52, Trim(Concat(Split(r52," "),Concatenate(Upper(Left(Result,1)),Lower(Mid(Result,2)))," "))); Set(r52, Trim(Concat(Split(r52,"//////////"),Concatenate(Upper(Left(Result,1)),Mid(Result,2)),"
"))); Reset(DataCardValue52)
It comes out with the same thing but 53 characters long? (when a lowercase version is entered a correct capitalized version is returned but with the 3 invisible characters still)
if I delete a character and type it back in or add a character then delete the added character it goes back to 50 characters automatically.
The invisible characters are throwing off my validation which is frustrating since this is one of the last few things in a large project.
Anyone able to help?
