HI There, we have an issue where data is being supplied to the MDM import manager with tabs in the description strings, causing issues on subsequent syndications. How can i remove these tabs from the stings, i know i could use the 'normalise' function in the import manager but this will remove all characters and i need some of those in there (spaces, commas etc). I need to control which characters i remove, using the find and replace feature would work, however i don't know how to specify a [TAB] or [RETURN] for the system to replace it with... has anyone come across this before?
I've investigated further and i need to strip out the CR and LF characters (ascii 13 and 10 respectively).
Edited by: Adam Sellers on Jun 25, 2009 10:15 AM
on further investigation, i have found that i can do the following in excel to remove these characters,
=substitute(<cell>, char(13), " ") and this removes the CR characters. How can i write an assignment in MDM to add into my import workflow to perform this function as well?
Edited by: Adam Sellers on Jun 25, 2009 11:08 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.