Output Help

Question

Hi Team

I have the below input and I'm trying to remove the last digits with '-+numbers' and the separate the AIC + numbers and AVC + numbers to C + numbers. Also those that don't have a AVC/AIC/C will be blank

This is my input :

Name189976STP AYU AIC1234-5678AIO-ARE AVC468-790AIC RQU C1678TYU AIE AIC1679AHU AIR HUO

The Output should be ref

NameRef189976 STP AYU AIC1234-5678C1234AIO-ARE AVC468-790C468AIC RQU C16C16TYU AIE AIC167989C167989AHU AIR HUO

Is this possible?

Emil_Kos · Answer

Glad that I could help @stephenrodgers1990

BretCarr · Answer

I like @Emil_Kos ’s answer but if there is ever a letter C followed by numbers for some reason somewhere before the end of the string, you may get extra information or an erroneous set.

To get more specific, I used the expression pattern of:

(?:AI|AV| )(C\d+)

If you still get extra info due to odd pattern followings, this one should take care of those pesky trailing information that tear up the ref#:

(?:AI|AV| )(C\d+).*?$

Good luck!

AngelosPachis · Answer

Hi @henrygeorge ,

You can use a RegEx tool to parse an expression containing C and then one or more digits.

That's C\d+ as a regular expression.

Hope that helps.

Angelos

example.yxmd