Skip to Content


Hi Experts,

There is requirement where initially the client wanted us to extract the number from the below column and told that the pattern of the data in this column is same . For example The column was having the below data .

Getty ID 165188125.jpg

Getty ID 526297179.jpg

Getty ID 580329317.jpg

Out put should be:




Now we have achieved this output by creating a object at the universe level with the below formula .

left(substring(@catalog('CELUMPD')."CELUMPDUSR"."RPT_ASSET"."CURR_FILENAME",10,length(@catalog('CELUMPD')."CELUMPDUSR"."RPT_ASSET"."CURR_FILENAME")) , locate('.',substring(@catalog('CELUMPD')."CELUMPDUSR"."RPT_ASSET"."CURR_FILENAME",10,length(@catalog('CELUMPD')."CELUMPDUSR"."RPT_ASSET"."CURR_FILENAME")))-1)

Now again the client has come up with some more requrement where the column will have different format as shown below .

Getty ID 580329317.jpg

Shutterstock offset ID 80121.jpg

Shutterstock ID 51148402.jpg


and the output should be





Kindly let me know if this can be acheived in webi and provide your valuable suggestions.

Thanks for the help !


Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Dec 07, 2016 at 03:21 PM

    Hi DP,

    Please have a look on the belwo link.Try to create either 2 objects or single objects like below.

    1. Create a object to get the data from first Number letter and same way create another object to get the data from last number letter and accordingly try to get the data between these two.



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 08, 2016 at 05:27 AM

    Thansk Durga for the quick reply , I'm trying this hope it work

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.