cancel
Showing results for 
Search instead for 
Did you mean: 

UDF to remove # in idoc to ws interface

0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member186851
Active Contributor
0 Kudos

Hello Neha

As Sreenivas suggested try with replace function(standard function)

Input----------------ReplaceAll---------------Output

                            ("#",'')

0 Kudos

Hi Raghu

I dont want to replace it with space

I want to remove this

Any help?

former_member190293
Active Contributor
0 Kudos

Hi Neha!

Raghu is right. It's not the ' ' (space) but empty string ''.

Regards, Evgeniy.

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Neha,

Can you please try below UDF.

Thanks&Regards,

Akhila.A

former_member191435
Contributor
0 Kudos

Can you please try with replace string function.