Hello all,
I have a database table and I need to export it in .txt format. However i'm unsure how to do this.
Here is the format I need.
- Each record is in a single line.
- Each field in a record in separated by pipe sign '|'.
Couple of other points to be noted is :
2. The fields with empty values should ideally be separated by pipe sign and denoted as |""| , if thats difficult then separator with nothing in between as ||
I know in the export tab in PhpMyAdmin I need to choose CSV format and change the filename to .txt, however what goes in below:
Fields terminated by
Fields enclosed by
Fields escaped by
Fields terminated by
I would apreciate any help.
Thanks
MK