on 06-14-2016 8:22 AM
Hi Team
We are getting 2 fields from CRM system something like this :
Dsitrict..> SA JOS#
Street...> RUA DR JOS# MAR
Now C4C people wants us to remove #
I have realised TRIM function will not work here (because the special character is not parsed correctly. Also it has been found in some cases the spl character is seen within a string) and I need to suppress #
Can anyone help me to solve it by some other way?
Thanks
Hello Neha
As Sreenivas suggested try with replace function(standard function)
Input----------------ReplaceAll---------------Output
("#",'')
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Can you please try with replace string function.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.