Skip to main content
Question

Empty Cells with Space should be Nulls


I have excel file where empty Cells but have space on cells so when i transfer from excel to SQL so row are not Null so there is any way to remove space from cells in FME ??

3 replies

ebygomm
Influencer
Forum|alt.badge.img+39
  • Influencer
  • August 2, 2019

You could use a nullattributemapper to set all values that are only spaces to null


  • Author
  • August 2, 2019

how can .. im new


fmelizard
Safer
Forum|alt.badge.img+19
  • Safer
  • August 2, 2019
skorpion wrote:

how can .. im new

Hi @skorpion. Please refer to the product documentation: http://docs.safe.com/fme/2019.0/html/FME_Desktop_Documentation/FME_Transformers/Transformers/nullattributemapper.htm


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings