Welcome, Guest. Please Login
Tinderbox
  News:
IMPORTANT MESSAGE! This forum has now been replaced by a new forum at http://forum.eastgate.com and no further posting or member registration is allowed. The forum is still accessible via read-only access for reference purposes. If you wish to discuss content here, please use the new forum. N.B. - posting in the new forum requires a fresh registration in the new forum (sorry - member data can't be ported).
  HomeHelpSearchLogin  
 
Pages: 1
Send Topic Print
Tab-delimited text import and line breaks (Read 4760 times)
troubledworkflow
Full Member
*
Offline



Posts: 19

Tab-delimited text import and line breaks
Jun 10th, 2014, 12:11pm
 
Hi,
I'm having some trouble with the new version and line breaks in imports. When the text below is pasted in Tinderbox, the text after line break is not recognized as part of $Text. If there are more rows/notes, these don't get imported at all. The import works in Tinderbox 5, so I guess something has changed? Any solution?

Name      Text
Name      "Note text before line break.

Note text after line break."
Back to top
 
 
  IP Logged
Mark Anderson
YaBB Administrator
*
Offline

User - not staff!

Posts: 5689
Southsea, UK
Re: Tab-delimited text import and line breaks
Reply #1 - Jun 10th, 2014, 12:25pm
 
Imports from what? It not totally clear, but it sounds like line breaks inside CSV or tab-delimited tabular data. As raw text, your example works for me, like so:



Could you clarify your context? We may each only use one or two input methods but in aggregate there are many options.  Smiley
Back to top
 
« Last Edit: Jun 10th, 2014, 12:26pm by Mark Anderson »  

--
Mark Anderson
TB user and Wiki Gardener
aTbRef v6
(TB consulting - email me)
WWW shoantel   IP Logged
troubledworkflow
Full Member
*
Offline



Posts: 19

Re: Tab-delimited text import and line breaks
Reply #2 - Jun 10th, 2014, 1:11pm
 
Yes, it is line breaks inside tab-delimited tabular data. Copying from my post strips the tabs it seems. To see the behavior, replace the spaces between Name and Text with tabs.
Back to top
 
 
  IP Logged
Mark Anderson
YaBB Administrator
*
Offline

User - not staff!

Posts: 5689
Southsea, UK
Re: Tab-delimited text import and line breaks
Reply #3 - Jun 10th, 2014, 1:37pm
 
OK, tried that and it works here:



Text used (copied/pasted from TextEdit):

Name\TabText\LineBreak
Name\Tab"Note text before line break.\LineBreak
\LineBreak

Note text after line break."
Back to top
 
 

--
Mark Anderson
TB user and Wiki Gardener
aTbRef v6
(TB consulting - email me)
WWW shoantel   IP Logged
troubledworkflow
Full Member
*
Offline



Posts: 19

Re: Tab-delimited text import and line breaks
Reply #4 - Jun 10th, 2014, 1:50pm
 
But that screenshot doesn't show the imported spreadsheet? I want to import each row to individual notes with attributes specified by the first line. When I paste, the note is imported in a container "imported spreadsheet".

This: http://www.acrobatfaq.com/atbref5/index/ImportExportFormatting/SpreadsheetTab-De...
Back to top
 
 
  IP Logged
Mark Anderson
YaBB Administrator
*
Offline

User - not staff!

Posts: 5689
Southsea, UK
Re: Tab-delimited text import and line breaks
Reply #5 - Jun 10th, 2014, 2:42pm
 
Thanks, this is why context matters. Which of these are you trying to do:
  • Drop a tab-delim file onto a main view.
  • Paste tab-delim data from anywhere(?) into a main view.
I'm trying to check your scenario as described but it keeps being subtly redefined!  Smiley
Back to top
 
 

--
Mark Anderson
TB user and Wiki Gardener
aTbRef v6
(TB consulting - email me)
WWW shoantel   IP Logged
troubledworkflow
Full Member
*
Offline



Posts: 19

Re: Tab-delimited text import and line breaks
Reply #6 - Jun 10th, 2014, 2:46pm
 
Sorry. I'm using a slightly modified version of the script in link below to paste data from DEVONthink. It worked perfectly in Tinderbox 5.

http://www.eastgate.com/Tinderbox/forum//YaBB.pl?num=1346268662/21#21
Back to top
 
 
  IP Logged
Mark Anderson
YaBB Administrator
*
Offline

User - not staff!

Posts: 5689
Southsea, UK
Re: Tab-delimited text import and line breaks
Reply #7 - Jun 10th, 2014, 2:51pm
 
OK, I added you're specimen info to Excel 2011:



I then selected/copied the 4 cells with data and blind pasted that data into a v6 left pane:



Lastly, I exported the file as a tab-delimited text file which I than drag/dropped onto v6:



Could you paste a URL to a (failing) example text file of data so i can try it here. Given the above tests I suspect there are other characters - possible non-priting/invisible in your source text that may be creating issues.
Back to top
 
 

--
Mark Anderson
TB user and Wiki Gardener
aTbRef v6
(TB consulting - email me)
WWW shoantel   IP Logged
troubledworkflow
Full Member
*
Offline



Posts: 19

Re: Tab-delimited text import and line breaks
Reply #8 - Jun 10th, 2014, 3:06pm
 
Strange...
https://dl.dropboxusercontent.com/u/1287177/import.txt
This text imported from devonthink using the script above imports to one note withText "More text." and an other note with name "Extra more text.".
Back to top
 
« Last Edit: Jun 10th, 2014, 3:10pm by troubledworkflow »  
  IP Logged
Mark Anderson
YaBB Administrator
*
Offline

User - not staff!

Posts: 5689
Southsea, UK
Re: Tab-delimited text import and line breaks
Reply #9 - Jun 10th, 2014, 3:34pm
 
OK, I now see where the issue is occurring. I've passed in a report. I believe the v6 behaviour is not correct - it should work as in v5.
Back to top
 
 

--
Mark Anderson
TB user and Wiki Gardener
aTbRef v6
(TB consulting - email me)
WWW shoantel   IP Logged
troubledworkflow
Full Member
*
Offline



Posts: 19

Re: Tab-delimited text import and line breaks
Reply #10 - Jun 10th, 2014, 3:49pm
 
Good to know. thanks.
Back to top
 
 
  IP Logged
Pages: 1
Send Topic Print