Hello everyone, i'm importing with FIM sync rules a phone number as a string which looks like that +33 (6) 99 99 99 99 i'd like to reformat it to look like that +33699999999 any ideas ? i tried to use the replace string function but it doesnt seem to work Hitch Bardawil

I use classic advanced flow rules for this sort of thing - far more flexible. http://www.wapshere.com/missmiis

How does your replace string function looked like? These could be the base ingredients: ReplaceString(phone," ","") ReplaceString(phone,"(","") ReplaceString(phone,")","") And how with some nesting: ReplaceString(ReplaceString(ReplaceString(phone,")",""),"(","")," ","") -> properPhone Carol has a point. But you have to decide for yourself whether this way of working is ok or not. http://setspn.blogspot.com

thanks carol, i used classic advanced flow rules as you said and it worked greatHitch Bardawil