grep distinct values

Shell Programming and Scripting
1

this is a little more complex than that. I have a text file and I need to find all the distinct words that appear in a line after the word TABLESPACE

when I grep for just the word tablespace, I get:

how do i parse this a little better so i have a smaller file to read?

This is just an excerpt. its a rather big file even after the grep.

REM FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACEREM 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACEBUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ;TABLESPACE "SYSTEM" LOGGING ;REM FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACEREM GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE ;REM FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGINGBUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ;REM FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACEREM GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS ;BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ;BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ;REM FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGINGREM DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS ;BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ;REM FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACEREM FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ;GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ;BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ;REM DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE ;REM DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE ;REM GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESSREM LOB ("PARM_VALUE") STORE AS (TABLESPACE "SYSTEM" ENABLE STORAGE INBUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ;GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ;REM FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACEREM DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE ;REM FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACEREM FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ;

2

what you want from the data you provided? please mention o/p.

3

if i have this ina line:

TABLESPACE "SYSTEM"

I want "SYSTEM"

but what comes right after the TABLESPACE will change, but there should be a space and double quotes. I also want a distinct.

4 
 awk '{for(i=1; i< NF; i++) {if($i=="TABLESPACE") {j=i+1; print $i, $j} }}' filename | sort -u
5

thank you.

never would have gotten this part on my own.

{j=i+1; print $i, $j} }}

but it makes sense.