+ Start a Discussion
tzuvytzuvy 

Removing Unwanted Characters from Fields

Hi,

 

I have a field populated with values that look like this:

 

{"Features":["Operations Reports","Save Engage-sessions to DB"]}

 

I need to create another field that contains the same that but cleaned. I need it to be

 

"Operations Reports","Save Engage-sessions to DB"

 

So basically I need to remove the word Features and the "{,},[,]"

 

Is there a way tom do this?

 

Thanks

Tzuvy.

Alok_NagarroAlok_Nagarro

Hi,

you can use split() method to split string and then truncate the unwanted character from string.

 

 

Thanks.

tzuvytzuvy

Alok thanks for the reply.

 

Can you give an example on how to accomplish this with this string?

 

How can I make this :  {"Features":["Operations Reports","Save Engage-sessions to DB"]}

 

Look like this:  "Operations Reports","Save Engage-sessions to DB"

 

Thanks

 

tzuvy