Hi - I’m being sent a flat file that has a special character in it - apparently it’s an extended ascii value for 1/4" (¼) it’s ascii 172. I also found on the 'net that it’s a windows extension. I would like to tell the vendor to send us it as 3 bytes (ie 1/4) as they have in other cases but they’re telling me that’s what the user is entering in their system.
It’s bombing out when I do convertToValues saying malformed input.
Is there an encoding setting when I do convertToValues that will handle it? Even if I get it past webmethods it will have to get into SAP and SQL server as well. Any assistance would be appreciated! I would prefer to tell the vendor just to change it to 1/4 before they send it but I’m looking for other possible alternatives if it’s not to onerous.