Insert column data on Confluence-style table
Add ip addresses into new "IP" column based on the last digits from the "Server" column
Start file
||Host||Server||Windows Version||Aktualisiert|| |10.80.0.216|80-0-98 veeam Backup Suite_REPLICA|Windows Server 2012 (64-bit)|(x)| |10.80.0.217|80-0-98 veeam Backup Suite|Windows Server 2012 (64-bit)|(x)| |10.80.0.217|40-0-2-ldap.pci-dev.com|Windows Server 2012 (64-bit)| (x)| |10.80.0.216|vldp-178-visual-cron|Windows Server 2012 (64-bit)|(x) | |10.80.0.216|vvldp-150-visual-cron-|Windows Server 2012 (64-bit)|(x) | |10.80.0.216|vvldp-151-visual-cron-test|Windows Server 2012 (64-bit) |(x) | |10.80.0.216|vvldp-168-windows-rdp|Windows Server 2012 (64-bit) |(x) | |10.80.0.217|vvldp-181 VisualCron Automation|Windows Server 2016 (64-bit)|(x) | |10.80.0.216|vvldp-195-windows-rdp|Windows Server 2012 (64-bit)|(x) | |10.80.0.217|vvldp-250-dp-visual-cron|Windows Server 2012 (64-bit)|(x) |
End file
||Host||IP||Server||Windows Version||Aktualisiert|| |10.80.0.216|10.80.1.98|80-0-98 veeam Backup Suite_REPLICA|Windows Server 2012 (64-bit)|(x)| |10.80.0.217|10.80.1.98|80-0-98 veeam Backup Suite|Windows Server 2012 (64-bit)|(x)| |10.80.0.217|10.80.1.2|40-0-2-ldap.pci-dev.com|Windows Server 2012 (64-bit)| (x)| |10.80.0.216|10.80.1.178|vldp-178-visual-cron|Windows Server 2012 (64-bit)|(x) | |10.80.0.216|10.80.1.150|vvldp-150-visual-cron-|Windows Server 2012 (64-bit)|(x) | |10.80.0.216|10.80.1.151|vvldp-151-visual-cron-test|Windows Server 2012 (64-bit) |(x) | |10.80.0.216|10.80.1.168|vvldp-168-windows-rdp|Windows Server 2012 (64-bit) |(x) | |10.80.0.217|10.80.1.181|vvldp-181 VisualCron Automation|Windows Server 2016 (64-bit)|(x) | |10.80.0.216|10.80.1.195|vvldp-195-windows-rdp|Windows Server 2012 (64-bit)|(x) | |10.80.0.217|10.80.1.250|vvldp-250-dp-visual-cron|Windows Server 2012 (64-bit)|(x) |
View Diff
1,11c1,11 < ||Host||Server||Windows Version||Aktualisiert|| < |10.80.0.216|80-0-98 veeam Backup Suite_REPLICA|Windows Server 2012 (64-bit)|(x)| < |10.80.0.217|80-0-98 veeam Backup Suite|Windows Server 2012 (64-bit)|(x)| < |10.80.0.217|40-0-2-ldap.pci-dev.com|Windows Server 2012 (64-bit)| (x)| < |10.80.0.216|vldp-178-visual-cron|Windows Server 2012 (64-bit)|(x) | < |10.80.0.216|vvldp-150-visual-cron-|Windows Server 2012 (64-bit)|(x) | < |10.80.0.216|vvldp-151-visual-cron-test|Windows Server 2012 (64-bit) |(x) | < |10.80.0.216|vvldp-168-windows-rdp|Windows Server 2012 (64-bit) |(x) | < |10.80.0.217|vvldp-181 VisualCron Automation|Windows Server 2016 (64-bit)|(x) | < |10.80.0.216|vvldp-195-windows-rdp|Windows Server 2012 (64-bit)|(x) | < |10.80.0.217|vvldp-250-dp-visual-cron|Windows Server 2012 (64-bit)|(x) | --- > ||Host||IP||Server||Windows Version||Aktualisiert|| > |10.80.0.216|10.80.1.98|80-0-98 veeam Backup Suite_REPLICA|Windows Server 2012 (64-bit)|(x)| > |10.80.0.217|10.80.1.98|80-0-98 veeam Backup Suite|Windows Server 2012 (64-bit)|(x)| > |10.80.0.217|10.80.1.2|40-0-2-ldap.pci-dev.com|Windows Server 2012 (64-bit)| (x)| > |10.80.0.216|10.80.1.178|vldp-178-visual-cron|Windows Server 2012 (64-bit)|(x) | > |10.80.0.216|10.80.1.150|vvldp-150-visual-cron-|Windows Server 2012 (64-bit)|(x) | > |10.80.0.216|10.80.1.151|vvldp-151-visual-cron-test|Windows Server 2012 (64-bit) |(x) | > |10.80.0.216|10.80.1.168|vvldp-168-windows-rdp|Windows Server 2012 (64-bit) |(x) | > |10.80.0.217|10.80.1.181|vvldp-181 VisualCron Automation|Windows Server 2016 (64-bit)|(x) | > |10.80.0.216|10.80.1.195|vvldp-195-windows-rdp|Windows Server 2012 (64-bit)|(x) | > |10.80.0.217|10.80.1.250|vvldp-250-dp-visual-cron|Windows Server 2012 (64-bit)|(x) |
Solutions
The best way to learn is to practice. Below, you will find some of the solutions other golfers have entered. To unlock higher ranked solutions, submit your own entry which does as well or better than the solutions you can currently see - climb the ladder!
Check out these helpful resources to improve your Vim skills... Game on.
Unlock 106 remaining solutions by signing in and submitting your own entry
#107 Edouard Ewans / @edouardewans - Score: 601 - 06/29/23 @ 21:33
<Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Up><Up><Up><Up><Up><Up><Up><Up><Up><Up><Up><Up><Up><Up><Up><Up><Up><Up><Up><Up><Up><Up><Up><Up><Up><Up><Up><Up><Up><Up><Up><Up><Up><Up><Down><Down><Down><Down><Down><Right><Right><Up><Up><Right><Up><Up><Up><Up><Down><Right><Right><Up><Right><Right>i{<BS>|IP|<Down><Right><C-V><Esc>OC<Right><Right><C-Z>:u<Esc>:u<CR>:u<CR>i|<Down><Left><Right>|<Down><Down><Left><Up>|<Up><Down><Down><Left>|<Up><Down><Down><Left>|<Down><Left>|<Up><Down><Down><Left>|<Up><Down><Down><Left>|<Down><Left>|<Down><Left>|<Up><Up><Up><Up><Up><Up><Up><Up><Up><Up><Up><Left><Down><50-53>10.80.1.98<Esc>[201~<Down><Left><Left><Left><Left><Left><Left><Left><Left><Left><Left><50-53>10.80.1.98<Esc>[201~<Down><Left><Left><Left><Left><Left><Left><Left><Left><Left><Left><50-53>10.80.1.98<Esc>[201~<Down><Left><Left><Left><Left><Left><Left><Left><Left><Left><Left><50-53>10.80.1.98<Esc>[201~<Down><Down><Left><Left><Left><Left><Left><Left><Left><Up><Left><Left><Left><50-53>10.80.1.98<Esc>[201~<Down><Left><Left><Left><Left><Left><Left><Left><Left><Left><Left><50-53>10.80.1.98<Esc>[201~<Down><Left><Left><Left><Left><Left><Left><Left><Left><Left><Left><50-53>10.80.1.98<Esc>[201~<Down><Down><Left><Left><Left><Left><Left><Left><Left><Left><Left><Left><Up><50-53>10.80.1.98<Esc>[201~<Down><Left><Left><Left><Left><Left><Left><Left><Left><Left><Left><50-53>10.80.1.98<Esc>[201~<Down><Left><Left><Left><Left><Left><Left><Left><Left><Left><Left><50-53>10.80.1.98<Esc>[201~<Up><Up><Up><Up><Up><Up><Up><Up><Up><Down><Down><BS><BS>2<Down><Right><BS><BS>178<Down><Left><BS><BS>150<Down><Left><BS><BS>151<Down><Left><BS><BS>168<Down><Left><Left><Right><BS><BS>181<Down><Left><Left><Right><BS><BS>195<Down><Left><BS><BS>250:<BS><Esc>:wq<CR>
0 comments