This content has been marked as final. Show 4 replies
I tried it like this with the 'Like' mapping
Rule Name = '*'
Rule Desc = '*'
Rule Definition = '*'
Target = '#SCRIPT'
X_STRING = LEFT(RIGHT(varValues(16), 6),5)
Result = X_STRING
But it gives me the error below
Error: An error occurred importing the file.
Detail: Invalid procedure call or argument
Any Help Highly appreciated
You can either do this as part of the mapping process or you can use an import script to parse out the desired value during the import.1 person found this helpful
If you do it in the mapping simply use your original full product string as the source and set the trimmed value as the target i.e. using explicit maps
In the import script use logic similar to your example to parse out the portion of the original product string you wish to pass as the source value. However you must ensure this logic is generic and will work consistently over all product strings.
From your criteria I imagine the mapping approach would be the simplest and easiest to manage solution
Thanks for the reply. I managed to do that through Import script. But the exported file doesn't have the headers. Is there an option to export the data with its header?
The standard export functionality will not create a header row. You will need to customise the adapter Export Action script to achieve your desired output1 person found this helpful