<div class="gmail_quote">On Thu, Apr 18, 2013 at 9:59 PM, John Ghormley KJ4UFG <span dir="ltr"><<a href="mailto:kj4ufg@sera.org" target="_blank">kj4ufg@sera.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br><br><div class="gmail_quote"><div><div class="h5">On Thu, Apr 18, 2013 at 8:21 PM, Gregory Pittman <span dir="ltr"><<a href="mailto:gpittman@iglou.com" target="_blank">gpittman@iglou.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div>On 04/18/2013 07:58 PM, John Ghormley KJ4UFG wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
When trying to get a csv file into a text frame using the method, right<br>
click in the frame and select Get Text, then selecting the proper .csv<br>
file, using the Comma Separated Value Files importer and the System<br>
encoding and not selecting the Import Text Only box, my file was imported<br>
correctly with the exception of a tabulator at the very beginning of each<br>
line. There are six fields in each row of the spreadsheet. I have looked<br>
at the sheet with a text editor and no comma or tab character exist at the<br>
beginning of the line. I have saved the file from the text editor<br>
(Bluefish) which should remove any spaces at the end of line and insure a<br>
valid EOL character is there. However, the first character of each line is<br>
indented to the first tabulator setting, throwing off the entire column<br>
format.<br>
<br>
Each line should be at the left side of the text box as shown below and the<br>
other data fields in the listing should be tabbed to form columns down the<br>
page.<br>
<br>
Here are a few lines from the .csv file:<br>
<br>
,,,,,<br>
GEORGIA,,,,,<br>
10 Meters,,,,,<br>
N4BZJ,29.68,+,Dalton,141.3,☺<br>
KQ4XL,29.62,+,Monroe,0,☺<br>
WR4MG,29.66,+,Warner Robins,0,☺<br>
,,,,,<br>
<br>
Any ideas what to look for or how to fix the problem using Scribus? I<br>
cannot figure out how to remove the space at each line beginning short of<br>
deleting the space on each of the 3300+ lines.<br>
<br>
<br>
</blockquote></div></div>
What I have found is that you have to have what we might call a "dummy" tab at the beginning of your tabulator settings. I don't know why, but when I have put that extra one in there, everything comes out all right.<br>
<br>
I'm currently using Scribus with csv files to keep track of my patients, and make lists for various purposes, so I use Scribus with csv import every day (multiple times a day). I have even made a script that loads the files into the pre-formatted document with styles with tabs already created. A great timesaver.<br>
<br>
I would also add that you don't need these empty fields and commas at the end (,,,,).<br>
<br>
Greg<br>
<br>
</blockquote></div></div><div><br>Thanks, Greg.<br><br>I'll work with a dummy tab at the beginning of each line. Since I did not expand the cells in LO Calc, I got the multiple commas on blank lines and short title lines. I just figured I'd delete them since there were not so many and I have to replace the titles with some title boxes, anyway. It will be interesting to see how the first character comma works out.<div class="im">
<br>
<br clear="all">John Ghormley KJ4UFG<br>Editor, SERA <i>Repeater Journal</i><br>Walkertown, NC USA<br><a href="mailto:editor@sera.org" target="_blank">editor@sera.org</a></div></div></div><br>
</blockquote></div><br>Unless I misunderstood your instructions, Greg, this is not working for me. Each of the lines in the entire file is imported tabbed to the first marked tabulator. No other application I know has this property. Am I doing something to cause this, or is there a setting that typically causes this behaviour in 1.4.2 on Linux?<br>
<br clear="all"><div>John Ghormley KJ4UFG<br>Editor, SERA <i>Repeater Journal</i><br>Walkertown, NC USA<br><a href="mailto:editor@sera.org" target="_blank">editor@sera.org</a><br></div>
<br>