Zero Length String
Published · Updated
It has been noticed that when exporting data from a 3rd party software, at times the data contains "zero length strings" for columns where numeric data is expected.
Alternative 1 - Steps to remove Zero length Strings
1. Select the Full Column which contains zero length strings (one column at a time)
2. Select "Data >> Text to Columns"
3. Select "Delimited"
4. Untick all the delimiters and select the Text qualifier as "none"
5. Click the "Finish" button
6. Follow the steps 1 to 5 for all the Columns
7. Save the Excel sheet
After this, run udiMagic to import the Excel sheet into Tally.
Alternative 2
If you are using a Formula to fetch the data from another Excel sheet (or another source), kindly note the correct way to import numeric data:
Incorrect way: =If(P2=0,"",P2)
Correct way: =If(P2=0,0,P2)
PS: Notice that the incorrect way shown above returns "zero length string" instead of 0 (numeric zero)