Share
Report
140Hi,
I have a csv export setup for payment journals and it is exporting the file I want, mostly correctly
However it seems to ignore my data transformation rules on the mapping.
I want the first field to truncate at 32 characters. but one of my sample lines has 34 chars so throws an error when i export and the filed is set to 32. So I temporarily set it to 35
in the field mapping i set it to use a custom transform rule
The transform rule, when tested using the sample box, successfully truncates to 32 chars
but my output for field 1 looks like this:"Caribbean Welding Supplies Limited"
When it should be "Caribbean Welding Supplies Limit"
Similarly, another substitution rule i put using 'REPLACE' function is being ignored. But if i put a transform on a numeric field using math like multiply, it carries it out no problem.
Any ideas?
All responses (
Answers (
