We have a lot of chemistry MCQs in an excel file with lot of chemistry formulas and equations. When we tried to import these MCQs into mySQL based database all subscripts used in formulas lost and taken as normal character e.g, H2SO4, CO2, CH3 etc and makes our formulas and elements name nonsense. We need any solution by which mySQL can import subscript and superscript as it is from excel Or any solution by which we can force excel to consider subscript and superscript as inserted symbols because mySQL can pick symbols as it is.
Our exam application made by PHP and mySQL and we need permanent solution for it e.g, method, utility etc. A sample file with chemistry formula with sub and super script is attached.
Bu iş için 6 freelancer ortalamada $77 teklif veriyor
Hello Sir, I have understood your issue to capture superscript or subscript so that Formulas would not look like nonsense. I can develop such import script from CSV to MYSQL for you. So it will not kill the look Daha Fazla
I read job description and I can do your project.I can even work on urgent basis and complete your project soon..contact me for more information