Format Phone Number
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
June 22nd, 2011 11:14am
I use classic advanced flow rules for this sort of thing - far more flexible.
http://www.wapshere.com/missmiis
Free Windows Admin Tool Kit Click here and download it now
June 22nd, 2011 9:38pm
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
June 22nd, 2011 10:44pm
thanks carol,
i used classic advanced flow rules as you said and it worked greatHitch Bardawil
Free Windows Admin Tool Kit Click here and download it now
June 28th, 2011 2:40pm