Forum Discussion

AMPAllie's avatar
AMPAllie
Helper II
3 years ago

Extract Text with Wildcards

I have a column of project names. Somewhere in that string is the circuit ID. It begins with uppercase "C" and will have 3 OR 4 numbers behind it. Then a space, or a hyphen.  The circuit ID is not in the same place in the string every time.  And it may not be the only "C" or the only set of numbers in the string.
Any ideas on how to extract it from the string?

Need Help

2 Replies

    • AMPAllie's avatar
      AMPAllie
      Helper II
      3 years ago

      Here's a sample set. The circuit ID "CXXX" or "CXXXX" can be anywhere in the string.

       

      SDG&E PRiME C448-III
      SDG&E PRiME C448-Q
      SDG&E PRiME OPS 2021 C1076 C RECON
      SDG&E PRiME C448-T
      SDG&E PRiME C448-N
      SDG&E PRiME OPS 2021 C276 D Recon
      SDG&E PRiME C448-YY
      SDG&E PRiME OPS 2021 C276 E RECON
      SDG&E PRiME OPS 2021 C303 H RECON
      SDG&E PRiME OPS 2021 C1483 A RECON