Parsing Input for my Database
Posted: Sun Jun 26, 2005 3:43 pm
Hi guys,
Basically I want to put something like the following in a <TEXTAREA> and then add it to my database:
101|555|some text
130|666|more text
...that would be two rows. In this example I chose the bar (|) as the delimiter. Do I parse it myself ? What about the line feeds, do I need to worry about the \r\n vs. \n for Windows, Unix ?
Maybe there are some build-in functions for doing this ? An example would be nice.
Thanks.
Basically I want to put something like the following in a <TEXTAREA> and then add it to my database:
101|555|some text
130|666|more text
...that would be two rows. In this example I chose the bar (|) as the delimiter. Do I parse it myself ? What about the line feeds, do I need to worry about the \r\n vs. \n for Windows, Unix ?
Maybe there are some build-in functions for doing this ? An example would be nice.
Thanks.