Strange delimiters problem

[Andrej Kastrin <andrej.kastrin@xxxxxxxx>]

Dear all,

I am experiencing difficulty in trying to copy the file structure below 
into PostgreSQL table:

||001||,||Classification||,||Economics||,||N||
||001||,||Classification||,||Trends||,||Y||
etc...

Although I can preprocess the input file with e.g awk, I would like to 
know is it possible to do that directly in PostgreSQL.

Thanks in advance for any suggestions.

Best, Andrej