This content has been marked as final. Show 3 replies
Is this a delimited import format?
Do you have to do this through a script?
You could just put the following in the Like map to ignore the total columns when validating:
?? map to Ignore
??? map to Ignore
I cannot map ??? to Ignore.
The problem is that it is not always true that 3-digit account have to be ignored.
If the following account has only 2 digits then the 3-digit account should not be ignored.
You can use the conditional mapping to check the 'length' via the VBScript LEN option.
Then based on the returned LEN you can do your required work.
Hopefully that helps,