Help: Parsing Fields using Character Patterns

Hi everyone,

How can I parse a field to only include Regions > A > B > C > D > E ... Z and ignore everything else before it and after the last value (Z in this case) from the example below? Z would be followed by a comma, or be the end of the string.

Thank you,

regions.PNG

Output

Parse

Common Use Cases

Expression

Accepted answers

CharlieS

@waqaraphoto

Sure. Just update the Regular Expression in my attached example to: (Regions)+(.+)

All comments

ivoller

Hi,

You can use the Regex tools or functions or Text to Columns. Can you post the expected output so we can advise more fully.

Cheers,

Iain

waqaraphoto

Hi ivoller,

Thanks for your response. Please see example of output in below screenshot.

Thanks ivoller!

current vs desired.PNG

CharlieS

@waqaraphoto

Like @ivoller mentioned, RegEx is the way to go here. I'm not great at RegEx, but I've attached an example that should put you on the right track.

20180501-Region Parse.yxmd

waqaraphoto

Hi CharlieS,

I have an idea. Would you know how to (in regex) show a word and show everything after that word?

For example:

Parse:

TS Portfolio Journal, Regions>LATAM, Regions>LATAM>Corporate and include everything for the rest of the string after the word Region is found? I can organize my data so that the Region list shows up last in the field.

Thanks!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703