Thank you. The challenge is clearing previously set fixed width definitions. If you have a .CSV with 240 characters per line and 20-columns. Then a new .CSV with 96 characters prt line with 5 columns to import. The second file import has the columnar selections from the first. All the way out to the 240 character point. But since the second file is 96-char/line, you cannot scroll any wider then the file. Missing the 240-96 character field and associated column delimiters. To access the excess, you must edit the .CSV with additional characters to force line scrolling and enable the deletion of errant, formerly defined columnar delineation points/marks. I am not seeing where these delimiter points/marks are/can be cleared pre-import. This feature seems to be an enhancement in V3.3.0-WIN.
>>> On 07/07/2011 at 21:22, <[email protected]> wrote: Jim, If you want to clear them during the import dialog, clicking the red dot in the ruler area should clear them. Click again and one is added. As to how to make OOo forget them altogether the user setting is in: /home/yours/.openoffice.org/registrymodifications.xcu or C:\Documents and Setting\username\Application Data\OpenOffice.org\3\user\registrymodifications.xcu Look for text like: <item oor:path="/org.openoffice.Office.Calc/Dialogs/CSVImport"><prop oor:name="FixedWidthList" oor:op="fuse"><value>0;16;33;49;</value> On 07/01/2011 12:45 PM, Jim Parkhurst wrote: > Windows XP > Service Pack 3 > All current patches > I monitor and check various networked systems. Part of the process is to > export the information (reports, columnar format) as type .CSV. Then > using OO I import the file. OO will bring up the Text Import screen > which I will verify/select > Then > and process the column information. With V3.2 I would have a clean > identifier slate. With V3.3 it appears that I have the previous > iteration of import specification. I realized this more when I was > performing a similar import which kept returning wrong information. I > finally modified the first record and added a massive number of "x" > characters. When I processed the file, I was able to locate - and > delete/remove - the somewhere in history defined column indicators. > I have searched help ... for information on clearing the delimiter marks > but have not found anything - yet. > Thoughts? Best regards, Carl -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help ====================================================== Hurricane season is underway. Do you have a Personal Plan for your family's safety? Visit www.txdot.gov/travel/hurricane.htm -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help
