MySql text table retrieve
Posted: Wed Oct 05, 2005 4:09 am
Here is my problem:
I got a text table that has a text file like this:
----start----
name
workstep
workstep
workstep
.
.
-*--
status
--*--
comment
comment
.
.
---*--
part
part
.
.
---end----
Now I need to split this text file into lines. I got no experience with how MySQl delivers the text file. I expect to get a newline and ch.return
So I thought to first explode each part at the marks (e.g. -*--) and then explode it by the newline char if that is possible but I suspect there might be a more elegant way.
is there a function like fget for strings?
Any ideas?
I got a text table that has a text file like this:
----start----
name
workstep
workstep
workstep
.
.
-*--
status
--*--
comment
comment
.
.
---*--
part
part
.
.
---end----
Now I need to split this text file into lines. I got no experience with how MySQl delivers the text file. I expect to get a newline and ch.return
So I thought to first explode each part at the marks (e.g. -*--) and then explode it by the newline char if that is possible but I suspect there might be a more elegant way.
is there a function like fget for strings?
Any ideas?