How to remove text in a string

[E.T.S]

I am unsure how to use the replace activity to remove text from a string - can anyone explain simply how to configure this?

[supermanPunch (Arpan)]

@E.T.S

I have a data table which includes text I want to remove

Hi @E.T.S ,

Could you provide us with the Input Data and the Expected Output for that data? This is asked so that we can analyse and provide the appropriate suggestions for your case.

[E.T.S]

Hi,

My string looks like this: abcn/a
And I want it to look like this: abc

So the n/a is removed

I can’t use the trim method as there a lot of ‘n/a’ in the string

I am confused what these options do:

[supermanPunch (Arpan)]

@E.T.S

abcn/a

@E.T.S ,

I believe you are using the Replace activity, we could try with the below configuration :

Here we are assuming that n/a is at the end of the string always. If it is not at the end always, then you could remove the $ symbol at the End of the Pattern and check.

[Parvathy (PS Parvathy)]

Hi @E.T.S

Use this in Assign activity

originalString=abcn/a
modifiedString= originalString.Replace("n/a", "")

Hope it helps

[E.T.S]

Please could you show me these configurations in the ‘configure regular expression’ setting

[E.T.S]

That worked thanks! Is there a way I can replace multiple characters in the original string in the same line of code or would that require multiple assigns

[Parvathy (PS Parvathy)]

You can remove multiple n/a in one string.

If you have another you need to have another assign activity with same syntax.

Regards

[supermanPunch (Arpan)]

@E.T.S ,

The Configuration is done like below, Although I did directly assigned it from the Properties Panel.