Help! create a PSV file using macros

[mrexcel1716]

dear Excel guru's

I have small requirement, i need to create a PSV file ( Pipe seperated file). looking for a macro which will generate Output with PSV

[TABLE="width: 576"]
<colgroup><col span="9"></colgroup><tbody>[TR]
[TD]Filed 1[/TD]
[TD]Filed 2[/TD]
[TD]Filed 3[/TD]
[TD]Filed 4[/TD]
[TD]Filed 5[/TD]
[TD]Filed 6[/TD]
[TD]Filed 7[/TD]
[TD]Filed 8[/TD]
[TD]Filed 9[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD]b[/TD]
[TD]c[/TD]
[TD]d[/TD]
[TD]e[/TD]
[TD]f [/TD]
[TD]g[/TD]
[TD]h[/TD]
[TD]i[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD]ab1[/TD]
[TD]ab2[/TD]
[TD]ab3[/TD]
[TD]ab4[/TD]
[TD]ab5[/TD]
[TD]ab6[/TD]
[TD]ab7[/TD]
[TD]ab8[/TD]
[TD]ab9[/TD]
[/TR]
[TR]
[TD="colspan: 7"]Last line in the table TOTAL NUMBER OF CONSUMER RECORDS IS 000000000&Count of records[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Output should be like
Filed 1|Filed 2|Filed 3|Filed 4|Filed 5|Filed 6|Filed 7|Filed 8|Filed 9|
a|b|c|d|e|f |g|h|i|
1|2|3|4|5|6|7|8|9|
ab1|ab2|ab3|ab4|ab5|ab6|ab7|ab8|ab9|
TOTAL NUMBER OF CONSUMER RECORDS IS |0000000003|