imbedded carriage returns?

Altair Forum User
Altair Forum User
Altair Employee
edited February 2018 in Community Q&A

I have a report that I have modeled and one of the fields is what looks like [] mark from the end of the record. I am assuming that is a carriage return as the field can change width.

 

how do I remove that from my exports using the template?

 

cheers brad.

Tagged:

Answers

  • Altair Forum User
    Altair Forum User
    Altair Employee
    edited February 2018

    Hi Brad,

     

    If you are OK with the input side of things and only the output is a concern on approach might be to use a calculated field (Formula Field in recent terminology) to strip out the unwanted characters/source and then report the new field as the output.

     

    However you may also have some input and export Options to consider.

     

    Sorry for the rather generic answer but specifics might somewhat depend on the Monarch version you are working with and whether Classic or DPS.

     

    Pre-preparation of the file may also be an option but could have other effects to consider depending on the approach you are taking for the modelling and data ingestion.

     

     

    Grant

  • Altair Forum User
    Altair Forum User
    Altair Employee
    edited March 2018

    Hi Brad,

    Did you get this resolved?  Were you able to find the input options Grant has referred to?  If not, please reply with your version of Monarch nd we can point you towards them.

  • Altair Forum User
    Altair Forum User
    Altair Employee
    edited March 2018

    sorry but out for a bit I do not have this resolved as of yet?

  • Altair Forum User
    Altair Forum User
    Altair Employee
    edited March 2018
    Altair Forum User said:

    sorry but out for a bit I do not have this resolved as of yet?

    also version is monarch13 13.3.1.6079

  • Altair Forum User
    Altair Forum User
    Altair Employee
    edited March 2018

    Hi Brad,

     

    From your description, it sounds like you are using Classic. If so, the options Grant referred to can be found from in the Home->Options menu.

    Capture.JPG

    From there, please try the two "Ignore" options.

     

    Capture.JPG

     

    If this doesn't work or you are using Data Prep Studio, would you be able to provide a sample of the report for testing please?

     

    Regards,

    Steve.

  • Altair Forum User
    Altair Forum User
    Altair Employee
    edited March 2018
    Altair Forum User said:

    Hi Brad,

     

    From your description, it sounds like you are using Classic. If so, the options Grant referred to can be found from in the Home->Options menu.

    Capture.JPG

    From there, please try the two "Ignore" options.

     

    Capture.JPG

     

    If this doesn't work or you are using Data Prep Studio, would you be able to provide a sample of the report for testing please?

     

    Regards,

    Steve.

    yes that worked perfectly thks so much!

     

    cheers!

Categories