UFFE - Preserve Whitespace

Answered

Alex MacDonald

• April 14, 2017 09:43

Hey,

 

I'm trying to create an output using UFFE.  When i export though it's trimming whitespace.  While i would normally say this is great in this circumstance it's actually not doing what i need.

 

The file is flat file so unlike csv everything is done on field length.  Therefore when i output the field that is essentially a long blank string it becomes excluded.  Are there any work arounds for this?

 

Cheers

 

Alex

Vote

0

• Official comment

  

  Thomas

  • April 18, 2017 06:26

  Hi Alex,

  The problem here is that SDK trims the data. Please test it like this if you can get it working:

  Example: Make CardCode with spaces so it is always 30 chars
  
  SELECT TOP 10 RIGHT(space(30) + CardCode, 30) AS CardCodeWithSpaces FROM OCRD
  
  

  And then test it with the UFFE.

  If it doesn't work, you can do this through C# source by using PadLeft and PadRight methods.

  Thanks,

  Thomas

   
• 

  Alex MacDonald

  • April 18, 2017 07:57

  Hey Thomas,

   

  Thanks for the reply.

   

  I am padding out the space in SQL but it still removes the whitespace.  In the end i encased all data in speech marks and then wrote a custom script to remove only the speech marks before sending on the file.

   

  I did try in the handle as C# to put my code in here to remove the speechmarks but it wouldn't work.

   

  In almost all situations it's beneficial to trim whitespace though so thanks for putting this in place.

   

  Thanks

   

  Alex
• 

  Rafael Oliveira

  • June 09, 2020 17:24

  Thomas,

  I have a bank file that I need to generate with blank spaces in it.

  I tried to use the RPAD function in HANA and the result includes the spaces that I need.

  But when I export the file with UFFE the spaces, in the end, are removed.

  Any idea on how to keep the spaces in the file?

   

  Thanks,

   

  Rafael

Please sign in to leave a comment.