User:Gifted9/autowikibrowser: Difference between revisions
→task: alphabetize tables: toot oriole
(→task: alphabetize tables: toot oriole) |
|||
Line 516:
[[Vehicles Collection]], [[Wallpaper Collection]], [[Bed Collection]], [[Border Buildings Collection]], [[Cottages Collection]]
there's neither a vanilla nor an easy way to auto-alphabetize tables, but this method makes me want to jump into a volcano the least. page needs to be fully fleshed out and formatted before this works - alphabetization is the last step
# in awb, pull up the page to alphabetize and apply these advanced find & replace rules, regex on
{| class="wikitable"
|-
! find !! replace
|-
| <syntaxhighlight lang="python">\|\[\[File:(.+).png\]\]<br>(.+)
\|(.+)
\|(Yes|No)
\|-</syntaxhighlight> || <syntaxhighlight lang="python">|[[File:$1.png]]<br>$2 ¶|$3 ¶|$4 ¶|-</syntaxhighlight>
|-
|<syntaxhighlight lang="python">\|-
!
!
!
\|-
\|}
===(.+)===
{\|class="greentable sortable" width="60%"
\|- align="left"
!Name
!Availability
!Tradeable
\|-</syntaxhighlight> || <syntaxhighlight lang="python">|- ¶! ¶! ¶! ¶|- ¶|} ¶===$1=== ¶{|class="greentable sortable" width="60%" ¶|- align="left" ¶!Name ¶!Availability ¶!Tradeable ¶|-</syntaxhighlight>
|}
# don't save. cut & paste entire plaintext, except for any categories, templates, or headers, at right panel to empty excel spreadsheet
# highlight each section that needs to be alphabetized, then alt-h, s, s to alphabetize, shift-alt-right to group, up, ctrl-x, right, ctrl-v to paste header in new column (or use an autohotkey script to do it). repeat until finished
# highlight column b, sort a to z, expand selection
# cut and paste all excel text back into destination wpg page, and save
# in awb, pull up the page and apply the following regular find & replace rule, regex on: find <code> ¶</code> replace <code> /n<code>
=new requests=
| |||