Nehtdx

I would like to extract a list of distinct words from a set of lines. Is there a way of doing this ?

Say for example I have lines that look like this:

[
[(isPhysicallySettledFxFwd, NO,"Y"),(isPhysicallySettledFxFwd,isPhysicallySettledFxSwap,"N")],
[(isPhysicallySettledFxSwap,NO,"Y"),(isPhysicallySettledFxSwap, isPhysicallySettledCommodity,"Y")],
[(isPhysicallySettledCommodity,NO,"Y"),(isPhysicallySettledCommodity,YES,"Y")]
]

Then i would get a list of distinct words, looking this:

isPhysicallySettledFxFwd
isPhysicallySettledFxSwap
isPhysicallySettledCommodity
NO
YES
Y
N
(
)
"
[
]
,

I am not sure how to even start, apart from copying the lines to Excel and doing lots of manipulations...

You can do something like this:

:let a=[]
:%s/w+/=add(a, submatch(0))/gn
:new
:put =uniq(sort(a))

This will first declare a list a to work with. Then we run a :%s command, to capture all word-characters (w+) and act on all matches (g flag of the :s command), but won't actually replace (n flag). We use a sub-replace-expression(=) in the replacement part, to store the captured submatch in list a.

And finally, we create a new window, and put the unique and sorted (uniq) content of list a into it.

You can get a lot more sophisticated, like only capturing certain words, or counting the numbers, but this shows how flexible the :s command is.

Maybe this:

:%s/W/rr/g
:sort u
:g/^s*$/d

The first puts a line break before and after each non-word character.

The second command sorts the entire file with the option "unique", so all duplicate lines are removed.

The third command deletes all lines that are empty or only contain whitespaces.