Hi Folks,

Could not find anyway to load the description field data (With carriage return) using GRLoader. Tried giving \\0012 at the end of each line but the the data loaded with \\0012 suffixed for each line.

Please suggest and post your thoughts.

Any thoughts for Anusha?

Thanks

Carriage Return in description field- GRLoader

Hi Folks,

Could not find anyway to load the description field data (With carriage return) using GRLoader. Tried giving \\0012 at the end of each line but the the data loaded with \\0012 suffixed for each line.

Please suggest and post your thoughts.

Tired adding the <br /> inside the <!{CDATA]]> for description field data but no luck.

Hi Anusha,

1. Can you give us more details as to why you need the "carriage returns"? Is this for cosmetic (i.e. formatting, easier reading) purposes?

2. If you enter the carriage returns via the GUI directly, are they retained?

Kind Regards,

Brian

Hi Brian,

Thanks for your reply!! This is for easy reading. If i use GUI it works.

Thanks!

Regards,

Anusha

Hello Anusha

CHAR(13) is the Line break or Line Feed for Excel in Windows. Can you specify this in your input file (Hope its excel)

Regards

Nas

HI Nas,

I tried this but CHAR(13) loaded as a string.

This is starting to look like it is not possible. Have you logged an official Support Case? May be worth checking with Sustaining Engineering or Development if this is possible OOTB...

Hi Anusha.

I used the following input file:

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<GRLoader>
  <ci>
    <id>D0AAB074691E3925A51887E0B25662D6</id>
    <description>Hello
Mikel</description>
  </ci>
</GRLoader>

And this worked just fine....

Hope that helps.

Kind regards

...........Michael

Thanks for sharing Michael.