# \[Solved\] Stuck with formatting csv elements
**URL:** https://community.thunkable.com/t/solved-stuck-with-formatting-csv-elements/545961
**Category:** Questions about Thunkable X
**Tags:** solved, parse-csv
**Created:** [March 30, 2020, 9:39pm UTC](https://community.thunkable.com/t/solved-stuck-with-formatting-csv-elements/545961 "2020-03-30T21:39:31Z")
**Posts on this page:** 12
**Page:** 1
### Author:  [@bartiiee](https://community.thunkable.com/u/bartiiee)
#### Post date: [March 30, 2020, 9:39pm UTC](https://community.thunkable.com/t/solved-stuck-with-formatting-csv-elements/545961/1 "2020-03-30T21:39:31Z")
Hye all
I’m building an app where I read data from my online database. Data is exported as csv so the app can read it.
I’m able tot get all the rows and read them as row.
Also able to select 1 row from the result list.
But I’m stuck when I want to split this row into pieces.
So, started with reading and used delimiter “newline”.
Selected a row (testing purpose atm)
tryed to format this row with delimiter “,”. But that gives no result at all.
Not with data from database, not with testlist I created in picture.
(with data in picture first step gives “a,b,c” and “d,e,f”. Second step gieves “d,e,f”. Last step gives nothing).
Been trying and searching for the last hour and a half so I could really use some help (really frustrated atm.)
Thanks in advance!
---
### Author:  [@jared](https://community.thunkable.com/u/jared)
#### Post date: [March 30, 2020, 10:02pm UTC](https://community.thunkable.com/t/solved-stuck-with-formatting-csv-elements/545961/2 "2020-03-30T22:02:25Z")
how many columns are there?
---
### Author:  [@bartiiee](https://community.thunkable.com/u/bartiiee)
#### Post date: [March 31, 2020, 10:52am UTC](https://community.thunkable.com/t/solved-stuck-with-formatting-csv-elements/545961/3 "2020-03-31T10:52:34Z")
For the one I’m trying now, 8 columns (and for the moment 2 rows for testing purpose, will be more afterwards)
(Sorry for late responce; posted it just before I went to bed)
---
### Author:  [@jared](https://community.thunkable.com/u/jared)
#### Post date: [March 31, 2020, 1:21pm UTC](https://community.thunkable.com/t/solved-stuck-with-formatting-csv-elements/545961/4 "2020-03-31T13:21:07Z")
what Are you using for your database?
---
### Author:  [@bartiiee](https://community.thunkable.com/u/bartiiee)
#### Post date: [March 31, 2020, 1:42pm UTC](https://community.thunkable.com/t/solved-stuck-with-formatting-csv-elements/545961/5 "2020-03-31T13:42:06Z")
mariadb.
But don’t think database is the problem
App gets info trough webAPI en pulls csv file from database.
I can split the data that comes in with the “newline” functions into rows.
If I change “newline” to “,” in instance where data comes in, it splits it into cells.
Problem is I can’t do both. If I split it into rows, I get no result if I repaet it and try to split it into cells.
---
### Author:  [@jared](https://community.thunkable.com/u/jared)
#### Post date: [March 31, 2020, 2:14pm UTC](https://community.thunkable.com/t/solved-stuck-with-formatting-csv-elements/545961/6 "2020-03-31T14:14:42Z")
can you try something like this?
---
### Author:  [@bartiiee](https://community.thunkable.com/u/bartiiee)
#### Post date: [March 31, 2020, 2:46pm UTC](https://community.thunkable.com/t/solved-stuck-with-formatting-csv-elements/545961/7 "2020-03-31T14:46:48Z")
For some reason, this works now. Pretty sure I tried this yesterday but I can be mistaken.
Thank you for the help!
Gonna try to put this in a loop now for each row when there are more then 1 line I need. Hope that works too.
Great work, thank you again!
---
### Author:  [@jared](https://community.thunkable.com/u/jared)
#### Post date: [March 31, 2020, 2:56pm UTC](https://community.thunkable.com/t/solved-stuck-with-formatting-csv-elements/545961/8 "2020-03-31T14:56:58Z")
Great work! All it takes is perseverance! Would you mind marking that as a solution? 🙂
---
### Author:  [@bartiiee](https://community.thunkable.com/u/bartiiee)
#### Post date: [March 31, 2020, 7:50pm UTC](https://community.thunkable.com/t/solved-stuck-with-formatting-csv-elements/545961/9 "2020-03-31T19:50:10Z")
Seems someone beated me in marking a soluation 🙂
---
### Author:  [@Michael\_Rogulla](https://community.thunkable.com/u/Michael_Rogulla)
#### Post date: [March 31, 2020, 11:31pm UTC](https://community.thunkable.com/t/solved-stuck-with-formatting-csv-elements/545961/10 "2020-03-31T23:31:35Z")
Hi @bartiiee,
would you mind to tell me how to import a CSV file into an app?
I would also import some data into an app, but I haven’t found an import function.
---
### Author:  [@domhnallohanlon](https://community.thunkable.com/u/domhnallohanlon)
#### Post date: [March 31, 2020, 11:33pm UTC](https://community.thunkable.com/t/solved-stuck-with-formatting-csv-elements/545961/11 "2020-03-31T23:33:58Z")
Hah! That was me @bartiiee 😂
---
### Author:  [@ioannis](https://community.thunkable.com/u/ioannis)
#### Post date: [November 8, 2024, 11:39am UTC](https://community.thunkable.com/t/solved-stuck-with-formatting-csv-elements/545961/12 "2024-11-08T11:39:33Z")