Need a piece of software to convert Excel file to TXT for uploading to MYOB

Need a piece of software that will take file called "Synaps 3 [login to view URL]" and convert into format like "output may [login to view URL]" for me to upload into MYOB. (Sample files are attached) Software needs to allow" - Importing xls in format provided - Smart enough to know that that if the field in "Synaps 3 [login to view URL]" call "Amount Paid" is empty or 0 then ignore line. - Have the ability to allocate product code to the Description in field called "Shipping method" i.e $4.99 FRDLE Courier to NON RURAL address = FRDLE and use as a sales line in export file. There should be ability to add multiple variable into the software for this and allocate Stock code against it. - The Following is how the fields are mapped in the "output" file compared to the Input file Co./Last Name = Source First Name = No used Addr 1 - Line 1 = Shipping address - Line 2 = Shipping address - Line 3 = Shipping address - Line 4 = Shipping address Invoice No. = Blank as this is generated by MYOB Date = Sale Date Customer PO = Reference Ship Via = This should be be linked to "Freight stock code" i.e FRDLE = Courier Post or FRNZPOST = NZ Post Delivery Status = P Item Number = Product Code Quantity = Qty Sold Description = Blank as MYOB picks this up Price = Sales Price Inc-GST Price = Sale Price Discount = 0 Total = Sale price X Qty Inc-GST Total = Sale price X Qty Job = Blank Comment = Ship Ref Journal Memo = Sale;Source i.e Sale;Trademe or Sales;Sella Salesperson Last Name = Blank Salesperson First Name = Blank Shipping Date = Blank GST Code = NT GST Amount = 0 Freight Amount = BLANK Freight GST Code = NT Freight GST Amount = 0 Sale Status = I Terms - Payment is Due = 1 - Discount Days = 0 - Balance Due Days = 0 - % Discount = 0 - % Monthly Charge = 0 Referral Source = Blank Amount Paid = Blank Payment Method = Blank Payment Notes = Blank Name on Card = Blank Card Number = Blank Expiry Date = Blank Authorisation Code = Blank Cheque Number = Blank Inclusive = X Category = Blank Card ID = Linked to Source, Should have ability to set in software ie: Source = Trade Me = Card ID: TRADE ME, Record ID = 5 Record ID = Linked to Source