I want to store exactly the same data as the QR code contains. But when I add an entry through scanning the QR code, blank spaces will be all deleted when it is stored to the Google Sheets.
Before saving the entry the data will be like this.
[)> 06 P7183885530 10SB3 Z;45P 2P Z;17Q0001000 30T210721 2C Z;D Z;46P 1W 22VF11 Z;26P Z;23V895 16D Z;6V 31T 1C1T-0FJ2OA
After saving the entry, the data will be like this.
[)>06P718388553010SB3Z;45P2PZ;17Q000100030T2107212CZ;DZ;46P1W22VF11Z;26PZ;23V89516DZ;6V31T1C1T-0FJ2OA
If I copy and paste the data, it goes like this:
[)>06P718388553010SB3Z;45P2PZ;17Q000100030T2107212CZ;DZ;46P1W22VF11Z;26PZ;23V89516DZ;6V31T1C1T-0FJ2OA
Is there any way to avoid this problem??
Thank you.
Solved! Go to Solution.
Yeah, sounds like a good idea to me.
User | Count |
---|---|
15 | |
14 | |
8 | |
7 | |
4 |