Search found 89 matches

by withoutFeathers
2019-09-08 15:40:31
Forum: Nisus Writer Pro
Topic: Import CSV file to table in Nisus?
Replies: 2
Views: 114

Re: Import CSV file to table in Nisus?

G'day, wF et al If you replace all the commas in your comma-separated text file with tabs, then select everything and Convert Text to Table, you will get a proper Table. This may not be the complete solution in every circumstance. For example, I started with a Numbers spreadsheet which had commas i...
by withoutFeathers
2019-09-08 11:22:43
Forum: Nisus Writer Pro
Topic: Import CSV file to table in Nisus?
Replies: 2
Views: 114

Import CSV file to table in Nisus?

Hi, I'm accumulating CSV files (as backups for meta-data for pieces of writing submitted to publishers). I'd like a way to get these into Nisus, converted into a Nisus Table. So far I can only get them to load in the bare text CSV form, and 'convert to Table' doesn't turn them into a proper table wi...
by withoutFeathers
2019-09-03 06:29:45
Forum: Nisus Writer Pro
Topic: Table Format for Sort by date?
Replies: 31
Views: 1965

Re: Table Format for Sort by date?

G'day, wF et al It sorts Tables for me, without any error messages. Are you using NWP 3.0.3? That command is definitely there in the Edit hierarchical menu. Cheers, Adrian Aha. I'm using 2.1.10 (because I didn't like how v. 3.0 loaded large documents). So we can put it down to that, I'll suppose. B...
by withoutFeathers
2019-09-02 18:50:42
Forum: Nisus Writer Pro
Topic: Table Format for Sort by date?
Replies: 31
Views: 1965

Re: Table Format for Sort by date?

You don't need to test them all if you don't want to....--snip--... You may just want to try the Sort by Date US macro. Hi Adrian, I'm a bit OCD, so I have to finish the parts that apply to me. :) So I tested four of your final posted bunch; here are the results: Method (& Results ): Since my dates...
by withoutFeathers
2019-09-02 13:41:52
Forum: Nisus Writer Pro
Topic: Table Format for Sort by date?
Replies: 31
Views: 1965

Re: Table Format for Sort by date?

phspaelti wrote:
2019-09-01 22:48:34

Here is an updated version with the ascending/descending feature added:
Sort Table Rows By Selected Date Column.nwm
I find this works as expected in both directions.
Thank you again.

wF
by withoutFeathers
2019-09-02 13:25:53
Forum: Nisus Writer Pro
Topic: Table Format for Sort by date?
Replies: 31
Views: 1965

Re: Table Format for Sort by date?

@Philip, Thanks for the ascend/descend and I'll test it. I understand your reluctance to address the blanks and the year-only, and I can deal with what's happening. I'm being sloppy leaving the blanks in there, and it doesn't really matter what day the software chooses if I only put the year anyway....
by withoutFeathers
2019-09-01 18:53:58
Forum: Nisus Writer Pro
Topic: Table Format for Sort by date?
Replies: 31
Views: 1965

Re: Table Format for Sort by date?

Here is my test report. It's complicated but was certainly worthwhile doing. Thank you Philip and Adrian for those macros. Here goes: I used the revised versions of three of the macros that you revised, and called them "Dr2" in my naming. I ended up with 6 distinct macros to test, which I prefixed 1...
by withoutFeathers
2019-08-31 16:11:12
Forum: Nisus Writer Pro
Topic: Table Format for Sort by date?
Replies: 31
Views: 1965

Re: Table Format for Sort by date?

Thank you both! I'm amazed and a little overwhelmed at the moment, by the amount of testing I'll need to do to see what works best (or, dare I say it, what works, since I've already found several small anomalies in testing them). But I'm going to forge ahead, and try to keep your macros straight by ...
by withoutFeathers
2019-08-30 18:37:13
Forum: Nisus Writer Pro
Topic: Table Format for Sort by date?
Replies: 31
Views: 1965

Re: Table Format for Sort by date?

Adrian's macro is nice, but will not work properly, if the date has the form "January 2 nd , 2019". Here's a different macro which may succeed in more cases, but has other drawbacks. Thank you both; I may work out a system that uses one or more of them. @phspaelti, yours even does a correct job on ...
by withoutFeathers
2019-08-30 15:10:26
Forum: Nisus Writer Pro
Topic: Table Format for Sort by date?
Replies: 31
Views: 1965

Re: Table Format for Sort by date?

3. Paste in a spreadsheet and change the format to something more friendly Nice. Though I no longer have a viable spreadsheet, but maybe I can rustle up something out there in the cloud that will do it as a service. :) Unless Apple supplies one in the macOS that I don't know about... ? Anybody know...
by withoutFeathers
2019-08-30 13:11:49
Forum: Nisus Writer Pro
Topic: Table Format for Sort by date?
Replies: 31
Views: 1965

Re: Table Format for Sort by date?

Or maybe we should just offer a list of sorting options like BBEdit does for paragraphs. They have a very nice "sort using pattern" option, for those comfortable using regular expressions. I can see that the coding for mixed written/number dates might be difficult, but I have to count myself as som...
by withoutFeathers
2019-08-29 11:18:30
Forum: Nisus Writer Pro
Topic: Table Format for Sort by date?
Replies: 31
Views: 1965

Re: Table Format for Sort by date?

OK, I can answer my question now. :D

Format [YYYY], [MM], [DD], in numbers, seems to work. I.e.
{2019, 02, 02} = February 2nd, 2019, and if all the others are in this format it sorts correctly in chronology.

wF
by withoutFeathers
2019-08-29 11:02:50
Forum: Nisus Writer Pro
Topic: Table Format for Sort by date?
Replies: 31
Views: 1965

Table Format for Sort by date?

Hi, I'm setting up a table that I'll want to sort the rows by date. So far I haven't figured out a date format that the sort function will recognize accurately to get them in order, though I'm still trying things. I'm using a Macro for table sorting that was supplied to me years ago by Nisus (for NW...
by withoutFeathers
2019-07-10 08:34:52
Forum: Nisus Writer Pro
Topic: Automatic numbers lost in sort Table
Replies: 11
Views: 2659

Re: Automatic numbers lost in sort Table

Can this macro be edited to produce numbers in a way that will sort in sequence in the table? Yes, just remove "Scene " & from the macro. Turn line numbers on, and you'll find the string on line 16 and 23. Remove scene.png Excellent. This works as you say, and solves my problem. And I see how I can...
by withoutFeathers
2019-07-09 10:41:14
Forum: Nisus Writer Pro
Topic: Automatic numbers lost in sort Table
Replies: 11
Views: 2659

Re: Automatic numbers lost in sort Table

Hi, You don't need to enter the numbers by hand; use a macro to do this automatically. Here is a macro that does this for you. If you add or delete rows, then just run the macro again and it will update all the numbers. Thanks and that's great but introduces a new problem: the sort of the Scene1 etc...