Converting TXT to CSV with a complex custom delimiter
If you've made the decision to add to the text file the string ^|^,^|^ the results are consistent with the request to the software. The start and end of your text lines are not ^|^,^|^ but are ^|^ which provides the results as displayed.
Consider to replace in your text file the string containing the comma with the string ^|^ which will still provide the delimiting you require.