imbedded carriage returns?
Altair EmployeeI 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.
Find more posts tagged with
Altair EmployeeHi 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 Employeesorry but out for a bit I do not have this resolved as of yet?
Altair Employeesorry but out for a bit I do not have this resolved as of yet?
also version is monarch13 13.3.1.6079
Altair EmployeeHi 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.
From there, please try the two "Ignore" options.
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 EmployeeHi 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.
From there, please try the two "Ignore" options.
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!
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