lpad & substr

Comments

4 comments

  • Official comment
    Sabeel

    Hi Aditya,

    Thanks for posting this question. Please find my comments below.

    'substr' function is pretty straightforward in Datameer, below is the link which you can refer to get more details about this function.

    https://documentation.datameer.com/documentation/display/DAS70/SUBSTR

    In your case, SUBSTR("PROPERTY",1,5) this will return the below result:

    "ROPER"

     

    For the LPAD function, we have the alternative at Datameer, we just need to combine LEFT() AND REPT() functions to get the  desired output.

    Here is an example to demonstrate the same:

    Formula:

    LEFT(REPT("0";2)+LEFT("PROPERTY;10);10)

    Here is the document which you can refer

    LEFThttps://documentation.datameer.com/documentation/display/DAS70/LEFT

    REPT: https://documentation.datameer.com/documentation/display/DAS70/REPT

    Please find the screenshot of the same: I had divided the subfunctions for the testing purpose, it generates the result similar to LPAD(left padding).

     

     

    Please try this example and let me know if you have any concerns or doubts.

    Regards,

    Sabeel

    Datameer inc.

     

     

    Comment actions Permalink
  • Joel Stewart

    Aditya, I noticed quite a few posts recently about using some standard functions in Datameer. If you're interested, you may want to look into some of the courses we offer at http://education.datameer.com/ this may help you understand more Datameer functions so you can easily build your own use cases without having to wait for input from others in the community. 

    -1
    Comment actions Permalink
  • Aditya Koyyaamudi

    Thanks Sabeel, that works.

    0
    Comment actions Permalink
  • Aditya Koyyaamudi

    Thanks Joel, i'll definitely do that.

    0
    Comment actions Permalink

Please sign in to leave a comment.