On Thu, 2006-07-20 at 16:25 -0400, Bill wrote: > On Mon, 17 Jul 2006 16:21:41 -0400 > Bill <[EMAIL PROTECTED]> spake: > > > > > Hello, > > > > I have had the misfortune of being given a large amount of data in an > > XLS file. My goal, in the end is to get this all out to CSV files for > > processing and inclusion into a database. > > > > The problem is that part of the information is contained in hyperlinks > > in the spreadsheet. So I have a field like: > > > > "Website" > > > > and it points at: > > > > "www.websitename.com" > > > > I need to have the latter in my output when I export, yet cannot find a > > way to do it. > > > > The closest I have come so far is exporting it as xhtml, and then I > > would need to run something on it to parse the html. Yeech > > > > Hopefully there is a cleaner way, > > > > Thanks much for any help > > > > Ironically, I was able to get it through macro's on Excel. For fun I > imported it into OpenOffice and it basically forced me to kill > openoffice to get it to stop. Basically everyline that called the > function generated a popup that it would not work. > > Ah well, if anyone has any other ideas for this, that would be great. > > Thanks anyway
Any chance you could post a link to a demo file that illustrates the problem. That way we could actually see what you see and, perhaps, offer some way of handling the data. It would also be nice to know what your settings are in Tools > Options > Load & Save > VBA Saving as CSV does lose the hyperlink but the warning does come up so I am not too surprized. -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/
smime.p7s
Description: S/MIME cryptographic signature
