How to use Cloudformation functions (i.e. Fn::Join) to populate a string variable?

Just to be clear, parsing the CloudFormation template won’t help. You need to look at the outputs from the stack after deployment.