Remnoving extraneous delimiters within a *.txt output file

[SLITTLE]

I have created a  "|" 'piped' delimited *txt file with records with variable number of fields and length by using the UNION and OUTPUT to a *.txt file. 

However the shorter records,  there are extra delimiters which I need to remove. Does anyone know of a way to remove these extra delimiters?

#I|213198-001|ACME|ACME1|06/02/2023|0.00|USD|||||006||||Macro Upload
#Z|99USDZV1|||06/02/2023|||||||||||

#D|448.31|019304-0026|NOTAXIN|80293|G.Mathews - Breakfast - Cold Continental on May 18 2023|H0150|||||||||
#D|793.74|019304-0026|NOTAXIN|80293|G.Mathews - Lunch - Hot (Two Entrees) on May 18 2023|H0150|||||||||

[SLITTLE]

No worries - all good.  I appreciate the assistance.  😀

[jdminton]

Did that fix your issue? 

[SLITTLE]

Actually, after the UNION, I did an IF statement based on the record type to output to a single field by concatenating all required fields required along with the required number "|" for each record type.  

Thank you again for your guidance