Skip to Content
avatar image
Former Member

Parse Out specific text from a string

I have a very specific description that gets added and I need to pull out only the text that starts with CM -

The text is

External Application Servicepls and External Application Number CM123456789 has been added

So anytime the description has the CM number I want to pull only the CM number. Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 13, 2017 at 11:55 AM

    If you are looking in webi then use this formula.

    =Substr([Text];Pos([Text];"CM");Length([Text]))

    Add comment
    10|10000 characters needed characters exceeded