how do i remove blanks from a list
HI i have a script that creates a list but it also creates blanks is there anyway i can remove blanks.
sorry i thought i uploaded a picture for some reason i tried to upload a pdf
What kind of list? A series of records? Posting the script might help.
To post a script to the forum:
it's not the most eligant in the world but i'm teaching myself.
OK, but if you don't describe what you are trying to do in more detail, it's pretty much impossible to help you. Posting the script is one way for others to see what you have tried so far. You might even get a few pointers on how to improve your scripting.
Ok, this is not a script, it's a calculation. And you appear to want a list of numbers separated by returns. The list function can be used to produce your list of values and it will automatically drop out null (empty) values when it does so.
Please note that this entire calculation looks a bit strange--especially using PatternCount in this manner, but you could use it with the list function if you rewrote it like this:
List ( If ( E.Europe = 0 ; PatternCount ( ListOfRegions ; "E.Europe" ) ) ; If ( W.Europe = 0 ; PatternCount ( ListOfRegions ; "W.Europe" ) ) ; If ( //and so forth... )
you are a star.
If you think thats a mess you should see the whole database. I'm teaching myself as I go so it lacks planning. It's a bit like building the 'Empire state building' on the foundations for a "bungalow"
Retrieving data ...