I would like to export an array to a csv file with a specific type of delimiter and a specific notation of the numbers (in this case scientific notation 1.234E-02).

How can I achieve this in a general form?

I now there is (reference: http://mathematica.stackexchange.com/questions/15086/how-to-export-csv-from-mathematica)

    Export["dataset.csv", dataset, "CSV"]

but I do not know how to change the delimiter (reference for similar problem: http://mathematica.stackexchange.com/questions/73968/comma-issue-from-number-point-in-csv-export?rq=1 - is there a nicer way now?) and the notation of the numbers in the csv file seems arbitrary. I would like to have something like a format specifier for the numbers. In particular I would like to have something like 1.234E-02 for the numbers format (which I guess is referred to as scientific).