Android Question Arranging the .txt file

Izmirov.Yaminovich · Jul 1, 2016

Hi,

I have this saved .txt file in my app where it will record down the datas when I click save. However, the .txt file shows it in an arrangement like this:

0
1
2
3

I would like it to be like this:
0 1 2 3

It would be better if I can add in coma in between as well. How do I arrange it that way?

ilan · Jul 1, 2016

B4X:

Sub Save_click
  Dim str As String = "0,1,2,3"
   
  Dim writer As TextWriter
  writer.Initialize(File.OpenOutput(File.DirApp,"data.txt",True))
  writer.WriteLine(str)
  writer.Close
End Sub

and if you want to save the content from views then like this

B4X:

Sub Save_click
  Dim str As String = Edittext1.text & "," & Edittext2.text & "," & Lat.Text" & "," & Lon.Text & "," & Time.Text
   
  Dim writer As TextWriter
  writer.Initialize(File.OpenOutput(File.DirApp,"data.txt",True))
  writer.WriteLine(str)
  writer.Close
End Sub

NOTE that i wrote "TRUE" in the Append argument since you want to attach another line to the text file and not rewrite the textfile

Erel · Jul 1, 2016

In most cases it is better to avoid using TextWriter / TextReader.

If you want to create a CSV file then use StringUtils.WriteCSV:

B4X:

Sub SaveData(Items() As String)
Dim su As StringUtils
Dim rows as List = Array (Items)
su.SaveCSV(File.DirInternal, "data.txt", ",", rows)
End Sub

ilan · Jul 1, 2016

Erel said:
In most cases it is better to avoid using TextWriter / TextReader.

If you want to create a CSV file then use StringUtils.WriteCSV:

B4X:

Sub SaveData(Items() As String) Dim su As StringUtils Dim rows as List = Array (Items) su.SaveCSV(File.DirInternal, "data.txt", ",", rows) End Sub

to get values from that file i will need to split the list item correct?

i cannot handle it like an excel file where i have rows and columns?

is there a way to save everything to a csv file and load it to a table that is not a VIEW so i can handle like an excel table (columns, rows)? (except of sql)

sorex · Jul 1, 2016

ilan said:
i cannot handle it like an excel file where i have rows and columns?

sure, split on crlf and you have your rows.

split the row on comma and you have the cell/column.

if you need to do a lot of operations you might want to dump the data to a multi dimensional array

ilan · Jul 1, 2016

sorex said:
sure, split on crlf and you have your rows.

split the row on comma and you have the cell/column.

i dont want to split everytime the string i would like to hold all data in a virtual table
where i can always say label1.text = table(x,y)

a 2d array could be a solution but is there a simple way to save/load a 2d array?

ilan · Jul 1, 2016

ilan said:
i dont want to split everytime the string i would like to hold all data in a virtual table
where i can always say label1.text = table(x,y)

a 2d array could be a solution but is there a simple way to save/load a 2d array?

i guess a 2d array is not a solution here since i need to add new rows to it (like in a table)
but anyway i think it is better to open a new thread for this question

sorex · Jul 1, 2016

sqlite or even a hidden datagrid(view) are other options

ilan · Jul 1, 2016

thanx @sorex

sorex said:
hidden datagrid(view)

i have a hidden tableview (would like another solution)

sorex said:
sqlite

any useful links? (tutorial)

sorex · Jul 1, 2016

forum search will give you a lot of sqlite stuff. it's maybe overkill for what you want to do tho.

Android Question Arranging the .txt file

Izmirov.Yaminovich

Member

ilan

Expert

Erel

B4X founder

ilan

Expert

sorex

Expert

ilan

Expert

ilan

Expert

sorex

Expert

ilan

Expert

sorex

Expert

Similar Threads

Android Question Arranging the .txt file

Member

Expert

B4X founder

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Similar Threads

Privacy & Transparency

Privacy & Transparency