6 Replies Latest reply on Jan 18, 2019 8:06 AM by Thomas Reinhard

    Import .csv with Atrium Integrator (Kettle) including Carriege Return in Attributes

    Thomas Reinhard
      Share This:

      Good Day,


      I am trying to Import a .csv file with Attributes, which contains carriege Returns.


      Attribut Example from source with  1 carriage return


      Good Day,

      test test test


      Value .csv;


      ..§Good Day, <??> test test test§....


      Attribut Value after Import through Atrium Integrator:


      Good Day, test test test



      Which Special character, character combination or character string I have to place within the text that Atrium Integrator can indentify to place a carriage return at this place in the text.

      ...§Good Day, <???> test test test§......

      I tried the follwing combinations at the place where I expect after import a carriege return.


      • \n
      • \r\n
      • \\r\\n
      • &BR()&
      • &CHAR(10)&


      Thanks for your help


      Best Regards