How to remove text in a string variable

[Kindergarden]

Hi,

I have an excel file output for example,

Sales for Today (Average price: 20 euro)
Bargain shampoo (Average price: 3 euro).

Please advise how I could remove the (Average price: 20 euro) and (Average price: 3 euro) to produce.

Sales for Today
Bargain shampoo

Thanks

[Jumbo (Jumbo Suzuki)]

@Kindergarden

If string “(average price” is fixed and it is unique, how about split whole text with it?

J,

[Kindergarden]

Can u share the example. Actually, the text following (Average…) is towards the end and not needed. So yes, we could make the assumption.

[Jumbo (Jumbo Suzuki)]

@Kindergarden
Please refer this.

How to Split a String

Hi @sampaddas, You can try this StringVaraible.Split({“not”},StringSplitOptions.None) [image] Thanks, Vikas Reddy

like this.

[Kindergarden]

Thanks. I will try.

[q-z (Remus Pirvu)]

Hi! For something more generic, please try this:
"Sales for Today (Average price: 20 euro)".Substring(0,"Sales for Today (Average price: 20 euro)".IndexOf(" ("))

Let me know if it works or if you need something else!

[Kindergarden]

Thanks. I will check it out.