Remove particular words from a string

[alan.prakash]

This is my input string
Udaya Group INVOICE DATE 2022-08-26
vijaynagar AMOUNT DUE $42,652.38
jabalpur, Madhya Pradesh, 482001
India
From here i want to remove invoice date and amount due using string manipulation
and my final output should be like this
Udaya Group
vijaynagar
jabalpur, Madhya Pradesh, 482001
India
Please help

[Yoichi]

HI,

How about the following?

System.Text.RegularExpressions.Regex.Replace(yourString,"(INVOICE DATE|AMOUNT DUE).*","")

Regards,

[Steven_McKeering]

Hi @alan.prakash

You can use a Regex.Replace like this:

System.Text.RegularExpressions.Regex.Replace(yourstring, “(INVOICE DATE [\d-]+|AMOUNT DUE [$\d,.]+)”, “”)

Take a look here at the preview

You can start to learn Regex using Regex MegaPost

Regex help tutorial MEGAPOST – Making your first Regex post, Reusable Regex Patterns, Regex Troubleshooting, Sample Workflow and more

THE PURPOSE OF THIS POST IS TO HELP NEW REGEX USERS If you need help with Regex be sure to provide in your post, a Sample, the Output and the Pattern (as much as you know). CONTENTS: Section : I need a Regex Pattern ASAP! - My first Regex Post Section : Regex samples that you can use! Section : I need help applying regex in UiPath Section : Regex Matches and Groups Section : Le…

Cheers

Steve

[Veera_Raj (Veeraraj Sethuraman)]

string.Split({vbLf},StringSplitOptions.RemoveEmptyEntries)

you can use this for split by new lines output is array

and after string_var.replace(array(0).tostring,“”).replace(array(1).tostring,“”)

you can try like this