How would i go about creating a material where i can use a color ramp to control areas or total transparency?
use the texture as the factor of a mix node between the surface material and a transparent node.

Hope this helps.