Skip to Content

Extract month's Days during transformation

Dear BW experts,

I want to extract days of month from 0CALDAY InfoObject

EX: 1,2,3,4,5,6, ....31

Which routine Type is the best solution , Formula or Routine ?

when i create a formula using Substring (0CALDAY,6 ,2) the result return correct day but with dots such as : . . 25

thanks in advance.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Aug 22, 2016 at 11:51 AM

    I have 0CALDAY InfoObject and i try to create routine it gives me error as this filed doesn't belong to source field. i create this formula and works fine SUBSTRING( CALDAY, 6, 2 ) where CALDAY is Characteristic infoobject with 2 CHAR length. thanks all so much

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 22, 2016 at 12:05 AM

    hi,

    the infoobject should be type numc then through routine also you can obtain your requirement. for example:

    result = <fieldname>+6(2).

    AM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 22, 2016 at 01:42 AM

    Hi,

    • create a new char with data type: numc like AM mentioed, but make sure you assing length as :2 (ex: zcalday)
    • add zcalday to target and map it with 0calday
    • field routine -->result = source_fields-calday+6(2)
    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.