Android Question This is how to search in access in Arabic with ignoring modulation. I want to convert the code to b4a search in SQlite

alfaiz678 said:

This is how to search in access in Arabic with ignoring modulation. I want to convert the code to b4a search in SQlite

B4X:

Public Function Gstr(str As String) As String

        Dim r As String = ""

        For Each c As Char In str

            r &= c & "%"

        Next

        Return r

End Function

Click to expand...

alfaiz678 said:

Is it not possible to convert b4a?

Click to expand...

Log(Gstr("alfaiz"))   'returns : a%l%f%a%i%z%

Sub Gstr(str As String) As String
        Dim r As String = ""
        For i =0 To str.Length-1
            Dim c As Char= str.CharAt(i)
           ' r = r & c & "%"  'this one works too
             r =$"${r}${c}%"$    
        Next
        Return r
End Sub

Mahares said:

Are you looking for something like this:

B4X:

Log(Gstr("alfaiz"))   'returns : a%l%f%a%i%z%

Sub Gstr(str As String) As String
        Dim r As String = ""
        For i =0 To str.Length-1
            Dim c As Char= str.CharAt(i)
           ' r = r & c & "%"  'this one works too
             r =$"${r}${c}%"$   
        Next
        Return r
End Sub

Your question is not clear. Please clarify with an example if the above code does not answer your question.

Click to expand...