I’ve created a decode BizTalk Pipeline Component that can replace any character or any string in an inbound file.
Here are some uses for it:
Replace a Trading Partner ID before BizTalk receives the file in the Message Box.
Replace HEX Characters in a flat file.
Insert carriage returns in an EDI file as the Segment Terminator.
In Pipeline Properties choose the characters you’d like to replace in the form of <character to replace>,<replacement character>. You can replace as many character pairs as you’d like.
In this example I’m replacing %u00bb with N and a with w.
Here’s a sample input file:
Here’s the output:
Email me if you would like a copy.