Skip to Content
0

Parse Out specific text from a string

Jan 12, 2017 at 07:44 PM

20

avatar image
Former Member

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!

10 |10000 characters needed characters left characters exceeded

in which tool are you looking?

webi?

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Jan 13, 2017 at 11:55 AM
0

If you are looking in webi then use this formula.

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

Share
10 |10000 characters needed characters left characters exceeded