SAP LSMW read txt file as unrecognized character and other issues

  I created a LSMW tools to create material master, the original file is MS excel , extension is XLSX ,and I need cover it to txt file for upload .

  

I noted that after I converted XLSX to TXT ,double quotation marks (character ") will be add to both left and right side for some field automatically ,no idea what happened  .




Ha, so far, you know why, right? A cell which have a comma will be added quotation marks after we convert it to TXT file.
So,what you have to do is replace the comma with a special character say ALT+225 (Number PAD)  in xlsx file and replace it back in txt file.

Next issues, after I execute the step of "Read data" in LSMW ,and then "Display ready data" ,I can see as below :




The solution is ,Save you file as a tab file ,then save it as  a UTF-8 format . Now, it working well .the txt file was contained some unrecognized character .

  










This experience has taught by my colleague ,I really annoying before I can solve it  .I can't find any good solution in internet ,so ,I learned it I shared with you .