CA Service Management

  • 1.  HTML Format Report

    Posted Apr 18, 2018 11:24 AM

    Hello Community,

     

    My team and i worked on a report from the "ci_doc_templates" specifically from the column "page_html" and give format on BOXI and it pass from a HTML code to this:

     

     
    Real data was changed.

     

     

    How can i take those information like "Investigacion", "Evidencia", "Herramientas y/o tecnologias" and set them on different columns on the report?

     

     

    Any suggestions?

     

     

     

    Regards.



  • 2.  Re: HTML Format Report

    Posted Apr 20, 2018 12:57 PM

    Hi Jason,

     

    Maybe this could help you:

     

    Split a string value separated by / to multiple columns 

     


    You can do this with POS and SUBSTR. I would begin by working out the position of all of the Backslashes in the string:

    FirstBackslash:

    Code:
    =Pos([LocationName];"/")


    SecondBackslash:

    Code:
    =Pos(Substr([LocationName];[FirstBackSlash]+1;100);"/")+[FirstBackSlash]


    ThirdBackslash:

    Code:
    =Pos(Substr([LocationName];[SecondBackSlash]+1;100);"/")+[SecondBackSlash]


    ...etc.

    You can then derive the columnar contents using SUBSTR:

    Region:

    Code:
    =Substr([LocationName];[FirstBackSlash]+1;[SecondBackSlash]-([FirstBackSlash]+1))


    Country:

    Code:
    =Substr([LocationName];[SecondBackSlash]+1;[ThirdBackSlash]-([SecondBackSlash]+1))


    You see the pattern.

    HTH

    NMG



  • 3.  Re: HTML Format Report
    Best Answer

    Posted Apr 24, 2018 10:09 AM

    Hello Andrade,

     

    We checked this scope but it was difficult to find a character to split the values among all the HTML code.

     

    What we did was some customizations on the KD forms to accept all the info we need.

     

     

    Thanks for the suggest anyways!