IMPORTANT:
this is not a Support Forum! Experienced users might answer from time to time questions posted here. If you need a professional and reliable answer, or if you want to report a bug, please contact Altova Support instead.

[MF 2009sp1 EE] How to check an empty Excel cell? Options · View
Techteam
Posted: Wednesday, March 28, 2012 1:42:43 PM
Rank: Member

Joined: 5/4/2010
Posts: 21
Location: D
Hi,
I need to concat some cells per row from an Excel sheet into a string.
If all cells have a value, it works fine.
If one the cells has no value, I get no output.
How can I check, if a cell is empty, that I can insert an empty string as concat part?

Thanks in advance

Heiko
vlad
Posted: Friday, March 30, 2012 10:18:12 PM
Rank: Advanced Member

Joined: 12/13/2005
Posts: 2,856
Location: Mauritius
substitute-missing function (not sure whether it was available in MF2009 though)
Users browsing this topic
guest

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Use of the Altova User Forum(s) is governed by the Altova Terms of Use.