Why is Data Exch. Definition ignoring my Transformation rules?

(0) Share

Report

Posted on by IrieGP

140

Hi,

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 (1)

Answers (0)

Suggested answer

Marco Mels on at

Like (0)

Report

RE: Why is Data Exch. Definition ignoring my Transformation rules?

Hello,

Feel free to raise this issue to Microsoft via your partner or CSP if you do not get further traction from the community. We may ask you for some sort of repro steps in standard.

Thank you.