Remove few words after meet specific words

[DTECH (Frank DTech)]

Greeting,

How do I remove few words once the specific words is meet inside string. For example,

Apple Blue NO. : 4320980

I want to remove NO. : 4320980 so it become Apple Blue
The word “NO. :” didn’t change except the number behind.

Appreciate the simple guidance

[Dhanush_Naik]

Hi,

Use split method
split(“Apple Blue NO. : 4320980”,“NO.”)(0)

or else build regex

Regards,
Dhanush

[DTECH (Frank DTech)]

Thanks man, appreciate

[ahmad_sarrawi (Ahmad AL-Sarrawi)]

“Apple Blue NO. : 4320980”.Split({“NO.”},StringSplitOptions.None)(0)