Ignore 0 Data Field From Excel Follow
i have excel file with list of people and address.
the address is split to address,num,apt, pob,,,,,,in the apartment colume whenever there is no real data there is 0 value/
in the advance data source, i add 1 sub-string with data-screen call "apt.", so the word apt. apeare whenever there is a value in this colum.
i checked the "suppress if the -next - sub-srting is empty.
and then i add the apt. data field.
but beacuse there is a 0, its printing the "apt." word all the time like this "apt. 0"
i need to ignore 0 value.
how can i vb this on the vb script assistant
please help :(
Michael Toupin (mtoupin
Please sign in to leave a comment.