Help with macros and Java

**Grumpy John** · 27th December 2016, 02:21 PM

Hey WoodPixel, I need a bit more help please.
Although I could probably do this in OpenOffice Writer, Notepad++ is so fast that I would prefer to use it.

All the place names are a mixture of all caps and first letter only caps, but they are separated from the rest of the text by a comma. Is it possible to change them to all first letter only caps. It will be made harder because the state is also before the comma and I would like it to remain all caps.

Aberbaldie Nature Reserve NSW,Reserve,,-31.07000,151.42000
ABERBALDIE NSW,Homestead,,-31.10000,151.44000
Aberbaldie NSW,Parish,,-31.13000,151.41000
Abercorn Creek NSW,Stream,,-30.27000,152.52000
Abercorn NSW,Parish,,-33.99000,149.91000
Abercorn NSW,Trig,,-29.06000,149.71000
ABERCORN QLD,Locality,,-25.14000,151.14000
ABERCORN QLD,Urban,,-25.13000,151.12000
ABERCORN QLD,Parish,,-17.60000,144.06000
ABERCORN QLD,Rail,,-25.13000,151.13000
Abercorne Creek WA,Stream,,-15.61000,128.37000
Abercrombie Caves NSW,Locality,,-33.89000,149.35000
Abercrombie Caves NSW,Cave,,-33.90000,149.35000
Abercrombie Channel NSW,Channel,,-34.71000,143.86000
Abercrombie Channel NSW,Channel,,-34.71000,143.86000
Abercrombie Creek NSW,Stream,,-29.81000,152.46000
Abercrombie Creek NSW,Stream,,-34.68000,144.60000
Abercrombie Creek NSW,Stream,,-34.74000,144.60000
Abercrombie Farm SA,Homestead,,-37.77000,140.82000
ABERCROMBIE FARM SA,Homestead,,-37.77000,140.82000
Abercrombie NSW,Parish,,-36.03000,149.25000
Abercrombie NSW,Parish,,-34.64000,144.68000
Abercrombie NSW,Parish,,-33.91000,149.25000

Also as you can see there are duplicated place names ans coordinates. Is it possible to search for duplicate occurrences without typing in the text string, and delete all but one?

Thanks again for putting me on to this editor, this job would be impossible without it.

**woodPixel** · 27th December 2016, 02:46 PM

Why yes!

Install the TextFX plugin. (Plugins --> Plugin Manager --> Show Plugin Manager). Select TextFX from the list, install and restart Notepad++.

Highlight everything (CTRL-A) then Edit --> Convert Case To -->Proper Case (or one of the options you prefer).

It will fry ACT, NSW, etc, but just do a Find/Replace for " nsw" to " NSW".... one for each state.

**woodPixel** · 27th December 2016, 02:55 PM

1 - Mark all the text (CTRL+A). ...

2 - Click TextFX --> Click TextFX Tools --> Click Sort lines case insensitive (at column)

3 - Duplicates and blank lines have been removed and the data has been sorted alphabetically.

Ensure these two options are selected. You may need to run it twice .... sometimes it just sorts it, but the second time removes dupes.

dupes.jpg

**woodPixel** · 27th December 2016, 03:09 PM

Here is a video showing it on my desktop using the sample you provided: https://drive.google.com/file/d/0B4_...ew?usp=sharing

Its a file.

Should play OK with Windows Media player or VLC Media Player (my recommendation).

In it I show:

-- copy paste from the sample
-- Highlighting everything
-- Doing the sort thing and showing that the duplicate has been deleted (a line disappears)
-- then doing the Proper Casing thing.

I show that NSW is changed to Nsw which is but a trivial headache to fix

**Grumpy John** · 27th December 2016, 03:12 PM

Thanks mate, I'll have a crack at it now.
I'm up to save #18

.

**Grumpy John** · 27th December 2016, 03:18 PM

Originally Posted by woodPixel

Why yes!

Install the TextFX plugin. (Plugins --> Plugin Manager --> Show Plugin Manager). Select TextFX from the list, install and restart Notepad++.

Highlight everything (CTRL-A) then Edit --> Convert Case To -->Proper Case (or one of the options you prefer).

It will fry ACT, NSW, etc, but just do a Find/Replace for " nsw" to " NSW".... one for each state.

I only have Plugins--> Converter or
Plugins--> MIME.

Running latest version v7.2.2

**woodPixel** · 27th December 2016, 03:20 PM

I also recorded a video showing how to sort everything properly: https://drive.google.com/open?id=0B4...GNqSFlHc0p6WEU

No doubt this will help when using the GPS!

**woodPixel** · 27th December 2016, 03:25 PM

Originally Posted by Grumpy John

I only have Plugins--> Converter or
Plugins--> MIME.

Running latest version v7.2.2

Here is a vid showing where to find it and how its installed and showing mine installed: https://drive.google.com/open?id=0B4...zJXUVprS0lza0U

**Grumpy John** · 27th December 2016, 03:27 PM

What I see on my screen

notepad.jpg

**woodPixel** · 27th December 2016, 03:29 PM

OOOPSS! Forgot to tell you that the plugin Manager is itself a plugin

Plugin Manager for Notepad++

Down the bottom is the instruction on how to install it. Very simple!

**Grumpy John** · 27th December 2016, 03:32 PM

Do I need unicode, or ansi, or both?

**woodPixel** · 27th December 2016, 03:33 PM

ANSI unless you are working with non-English characters.

**Grumpy John** · 27th December 2016, 03:46 PM

Help!!!!!!

Oops.jpg

**woodPixel** · 27th December 2016, 03:56 PM

Try the latest version 1.4.3.0 -- https://github.com/bruderstein/nppPl...nager/releases

**Grumpy John** · 27th December 2016, 05:54 PM

I was running the 64 bit version, Plugin Manager is not available for 64 bit version

.
Have installed 32 bit version and all is good.

Thread: Help with macros and Java

Thread Tools

Search Thread

CaMel Casing and FIXinG wobblY Words....

Duplicates

a video!

Similar Threads

Micro-Macros

New Macros

Posting Permissions