OOTB function to trim desired sentence from a string

Hello Guys,

I have a requirement where I need to remove a desired sentence from a string.

Eg input string: “I love your (shoes etc.). Where did you get it/them?”

Now, I want to trim (shoes etc.) from the above string.

Eg output string: “I love your. Where did you get it/them?”

So, I am expecting a function which should take 2 inputs, 1 is entire string and 1 is desired string to trim.

Hi @BATTINIRAMESH,

You can use the replaceAll function.

replaceAll(“I love your (shoes etc.). Where did you get it/them?”,“(shoes etc.)”,“”)

Regards,

K Chandra Prakash.

@KAMINENICHANDRAP

Thanks for the response,

This will add space instead of desired string, But I want to remove it instead of replacing with space.

Hi @BATTINIRAMESH,

replaceAll(“I love your (shoes etc.). Where did you get it/them?”," (shoes etc.)",“”)

It will simply remove the desired string.

Hi @BATTINIRAMESH

Did you find a solution for achieving your outcome? If so, can you please share it here. Any example regarding trim functionality also helps.

Regards,

Sivani.

@Chandra Prakash

input = :“2023-08-17T14:34:03.697Z”

I want to replace the colon of hh:mm:ss

by using @pxReplaceAllViaRegex with Regular Expression :[0-9]

it is removing colon and the number, i want only the colon in the hh:mm:ss to replace.

14:34:03==>143403

how can we achieve this? to get the output like this?

Output= :“2023-08-17T143403.697Z”

@SivaniP the original poster marked Chandra’s response as the solution.

This post is now a year old.

If you need help could I suggest that you Ask a New Question?

First please carry out a PSC search and check our available documentation