At 14:56 26/03/2017 -0400, Doug McNutt wrote:
Wow. The Sunday response is warmly appreciated.
No probs!
I'm going to change the fixed width to "tab separated".
As advised. Good.
There is also something called "text delimiter" ...
If your input data had text which looked like numbers (or
Wow. The Sunday response is warmly appreciated.
Re-copying from the spreadsheet into gedit
03/24/1703/24/17EPMTp$16.96COMM Consumer Cellular
03/24/1703/24/17EPMTp$159.64HOUSWaste Management
03/24/1703/29/17EPMTp$330.65CO
Hi,
I tried your example with the Fedora text editor and I was able to
reproduce the behaviour you are describing. The way out is to tell Calc
what type of data you have in the columns before you hit the "OK"
button of the import panel. To do so, make sure the arrows are placed
at the right place
At 11:50 26/03/2017 -0400, Doug McNutt wrote:
Here are three lines copied from a LibreOffice Calc page
03/24/1703/24/17EPMTp$16.96COMM Consumer Cellular
03/24/1703/24/17EPMTp$159.64HOUSWaste Management
03/24/1703/29/17EPMTp$3
2017-03-26 17:50 GMT+02:00 Doug McNutt :
> Here are three lines copied from a LibreOffice Calc page
> 03/24/1703/24/17EPMTp$16.96COMM Consumer Cellular
> 03/24/1703/24/17EPMTp$159.64HOUSWaste
> Management
> 03/24/1703/29/17EPMTp
Here are three lines copied from a LibreOffice Calc page
03/24/1703/24/17EPMTp$16.96COMM Consumer Cellular
03/24/1703/24/17EPMTp$159.64HOUSWaste Management
03/24/1703/29/17EPMTp$330.65COMMPair Networks
The first two c