How to insert text after a variable outline # and before text?

Trying to parse an outlined document.

The bulk of my rows include [Orig] between the outline and the text I want to parse. I can parse this with a Regex Tool using (\d.+) (\[Orig\] .+) (thanks to the Community). This is NOT my question.

042-1 [Orig] General

My problem is outlined below. Pun totally intended.

There are a few "reject" rows that lack the [Orig].

233-4 Inversion Requirement
626-2.1.1 Seating Characteristics Blah Blah

How can I insert a "[Add]" to match the standard configuration and enable it to be parsed with a similar Regex Tool (\d.+) (\[Add\] .+)????

The outline is 1-N. So, its not just a matter of inserting it X positions from the left.

Thanks

Regex

Parse

Expression

Accepted answers

neilgallen

see attached. parsing using all non-whitespace seems to get you there.

parse non-whitespace.yxmd

All comments

neilgallen

I might think about this differently. Rather than specifically calling out "Orig" in the regex pattern, I would ask about the spacing.

Are the outline values always consecutive characters with no spacing? If so, then your delimiter isn't the [Orig], it's the space between them.

Your regex string could be ^.+\s.+

Then you wouldn't need the configuration for the [Orig]

hellyars

@neilgallen

So, I tried with marked groups. I want the outline in Col 1 and the Text that either begins or does not begin with [Orig] in Col 2.

( ^.+)\s(.+)

No joy. It did not throw an error, just [Null]s.

I also tried a variation of the expression I am currently using (.+) (\[Orig\] .+), without the "Orig" reference.

(.+) \s (.+)

No joy, more [Null]s.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335