Hello Jeff, I am assuming that you are saving your Excel file as a tab-separated spreadsheet before you do the import using the "Import Tab-delimited Spreadsheet File" wizard.
The way to prevent leading spaces to get stripped has two steps: 1-) Place double-quote characters at the beginning and end of the cells in the tab-delimited file. An example would be like this: " this is a cell with leading spaces" You could either do a regex replacement in a text editor to put double-quotes (even a SPIN query and SPARQLMotion would work) or put a comma character into the cell in Excel which forces the cell in the tab-delimited file to be saved with double-quotes (you would again need to remove the comma though after the save). 2-) In the second page of "Import Tab-delimited Spreadsheet File" wizard, "Specify Spreadsheet Properties", select "Import special characters found in quoted resources (example: "Hansel & Gretel") ". If the above steps are too infeasible to perform, then I would either alternatively suggest dragging and dropping the Excel file in TopBraid Composer into Imports View of the target ontology, which uses Semantic Tables to generate triples, or importing it with "Import Excel File into Spreadsheet Ontology" wizard. However, in either of these alternative ways, additional processing is needed to map the generated triples into the desired triples in the target ontology using SPINMap or any SPIN rules. Gokhan On Wed, Jun 6, 2012 at 11:07 PM, Schmitz, Jeffrey A < [email protected]> wrote: > Hello,**** > > I’m importing an Excel file into an existing model (selecting the > Import to the current ontology box in the wizard) and during the process, > leading spaces that exist in my Excel cells are getting stripped when the > values are populated in my model. Is there a way to import so that the > leading spaces don’t get stripped? **** > > ** ** > > Thanks,**** > > Jeff**** > > -- > You received this message because you are subscribed to the Google > Group "TopBraid Suite Users", the topics of which include Enterprise > Vocabulary Network (EVN), TopBraid Composer, > TopBraid Live, TopBraid Ensemble, SPARQLMotion and SPIN. > To post to this group, send email to > [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/topbraid-users?hl=en > -- You received this message because you are subscribed to the Google Group "TopBraid Suite Users", the topics of which include Enterprise Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid Ensemble, SPARQLMotion and SPIN. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/topbraid-users?hl=en
