Android Question Touble parsing TAB or ASC (9)

[JamesGreaves]

I am having to parse text which has been exported from Excel with a TAB or ASC(9) delimiter.
The code show how I have attempted to split the data.
I am not getting this right. Any advice?

    Dim Data As String
    Data = "A    B    C    D    E" ' Separated by TAB or ASC(9)
        
    Dim Numbers() As String
    Numbers = Regex.Split(Asc(9),Data)
    
    Dim Each_Entry As List     
    Each_Entry.Initialize2(Numbers)
    
    Dim First_Entry As String
    First_Entry = Each_Entry.Get(0)
    
    Log(First_Entry)

 

[JamesGreaves]

I found my problem!! It should be Chr(9), not ASC(9).

 

[sorex]

there is also the TAB keyword...

Log($"a${TAB}b"$)

 

[thetahsk]

same same

Numbers = Regex.Split(TAB,Data)

 

[JamesGreaves]

same same

Numbers = Regex.Split(TAB,Data)

Brilliant, thanks good to know, I didn't know that.