Unable to update supplier address (with space in the system) through FBDI template

Summary:

Hi,

We are masking master data as part of requirement. While uploading the FBDI template in Update mode, some of the supplier addresses failed with invalid value. When furthuer checked, we see in the system some of the suppliers address name has training space (at the end). So we tried keeping the exact address name with space (as is in system) enclosed by double quotes, assuming anything in double quotes is treated with complete value including space and update the record. But this is also failing.

Can you please advice if there is any way to update in such cases where we have trailing spaces at the end of the names. There are quite a number of records with spaces, so manual update is not viable.