Here is my Google Sheets :

My datas

I would like to import "QUERY" column M,N,O,P,Q,R into another tab (same sheet) but convert dot "." to coma "," from column Q and R.

I don't know if SUBSTITUTE is the best way and also don't know how to use this inside a QUERY formula.

This formula don't work : =QUERY({Hoopzi_FlatFileAllOrdersReportbyLastUpdate!M2:Q;SUBSTITUTE(Hoopzi_FlatFileAllOrdersReportbyLastUpdate!Q2:R;".";","))}; "SELECT *")

Thanks for your help :)

CodePudding user response：

use:

=INDEX({Hoopzi_FlatFileAllOrdersReportbyLastUpdate!M2:P\
 SUBSTITUTE(Hoopzi_FlatFileAllOrdersReportbyLastUpdate!Q2:R; "."; ",")*1})

CodePudding user response：

Try

=query({Hoopzi_FlatFileAllOrdersReportbyLastUpdate!M2:P\arrayformula(1*substitute(Hoopzi_FlatFileAllOrdersReportbyLastUpdate!Q2:R;".";","))};"select *")