This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have multiple String fields passing through a data cleansing tool before output to MDB. However, all the fields are output with whitespace to take up the defined size of each field, even if no whitespace exists before. Output to CSV does not show the same issue, so I know the data was trimmed properly with the data cleansing tool. What's the best way to make sure my output to MDB is also trimmed?
For an MDB file, it saves the string field as the text content plus whitespace padding to fill in the field. Changing to a variable-length v_string allows the field to be saved in an MDB file without this padding issue.