Isolate a portion of a string with repeated character

[avaccaro (AVakk)]

Hello!
I saw a few topics around string manipulation, but I got lost, and did not find a good clean solution so far.
I need to manage a string where the format is:

AAAA_BBBB_information+extra
mystring = AAAA_BBBB_information+extra

(note: the actual string uses a “asterisk” before extra, but the edit of this chat make it messy with BOLD characters, so i’ve substituted with a plus sign.)

I want to isolate “information”
I found a workaround, but it looks overcomplicated to me.
Any suggestion? here below what I have

1- removing the extra seemed reasonably easy (extra is a repetitive info, so i use mystring.replace(“extra",“”).replace("”,“”) <<-- yes the “*” is not removed from the 1st replace…
2- Removing AAAA_BBBB_ is a challenge. I’m doing a sequence of ‘indexof’ then substring that dose not seem that nice

a=mystring
aa=a.IndexOf(“_”)
aaa=a.Substring(aa)
aaaa=aaa.Substring(1)

b = aaaa
bb=b.IndexOf(“_”)
bbb=b.Substring(bb)
bbbb=bbb.Substring(1)

c = bbbb.replace(“*RpaExc”,“”).replace(“Rpa",“”).replace("”,“”)

information =c

[postwick (Paul)]

Just use RegEx.

System.Text.RegularExpressions.RegEx.Match(inputstring,"(?<=AAAA_BBBB_)(.*)(?=\*extra)")

regex101: build, test, and debug regex

Also, when writing posts or replying, just use the </> button at the top (with text highlighted) to have it not interpret code.

[ppr (Peter Preuss)]

EDITED: incorporated * on end+extra, Thanks to Paul

give a try at:

(.)\1+_(.)\2+_\*(.*)(?=\*)

and refer to group

But maybe a simple pattern also will work

@avaccaro

but the edit of this chat make it messy with BOLD characters

use </> Format button from editor

[avaccaro (AVakk)]

Thx to all the replies.
I’m close but not done completely.

Here’s a test string that will probably clarify what I need to achieve.
I need to chop away after the 2nd “_”; I want to retain “Information_Difficult”

TEST_test33_Information_Difficult*Extratoremove

Opposite to the examples, I’m not splitting after the 1st “_”
I did some trials, but no success so far!

[Yoichi]

Hi,

How about the following pattern?

(?<=^[^_]+_[^_]+_)[^\*]+

Regards,

[ppr (Peter Preuss)]

sample differs from orgin use case description, as there are no repeating chars (told at the begin)
Lets refer to @Steven_McKeering SOP

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…

and for the basics

[CheatSheet] - System.Text.RegularExpressions | RegEx

This CheatSheet introduces the basic use of regex functions. With further examples also special cases are presented. Introduction From the namespace System.Text.RegularExpressions following methods are offered: Regex.Match Regex.Matches Regex.isMatch Regex.Replace Regex.Split A simple usage for example would look like this: [grafik] Recommendation: add System.Text.RegularExpressions to the imports: [grafik] it allows to use the shortened statement, as the namespace part can be ommited…

Example:

Reminder

@ppr

use </> Format button from editor

[Steven_McKeering]

Hello

SOP is always gives you the best reply from the community (cheers @ppr) - What if there are three, four or five words (instead of one or two)???

There will be better ways but give this one a try in the meantime:

.NET Regex Tester - Regex Storm

[avaccaro (AVakk)]

works perfectly! Thank you!

[Steven_McKeering]

Hi again @avaccaro ,

An additional option for a dynamic length string which only relies only on the underscores and the asterisk. Lets remove the unwanted text rather than match the text we need.

You will need to use a regex replace by inserting the below into an ‘Assign’ activity:
System.Text.RegularExpressions.Regex.Replace(youStr, “(?<=\*).*|^[^_\n\r]+_[^_\n\r]+_”, “”)

.NET Regex Tester - Regex Storm

Examples - noting the highlighted text will be removed
1 word:

2 words:

3 words:

Cheers

Steve

[avaccaro (AVakk)]

@Steven_McKeering

You will need to use a regex replace by inserting the below into an ‘Assign’ activity:

That’s great! thank you!