How to remove duplicates and inc table records using postgres sql regex

I have created scenario in fiddle where I have to remove duplicate records and keep only 1 record example : for spotted table mfg_lz.icc_axbi_kanban_job there are 2 records so need to remove duplicate and keep only 1.

select field1
  ,unnest(
      regexp_matches(
         replace(
            replace(
               concat('''' 
                      ||replace(
                           replace(
                              ltrim(rtrim(field2))
                             ,'"'
                             ,''
                           )
                          ,''''
                          ,''
                        )
                      ||''''
               )
              ,'"'
              ,''
            )
           ,E'\n'
           ,'')
        --,'(?:UPDATE|INTO|FROM|JOIN|USING|TABLE)(?:\s+ONLY)*\s+([[:alpha:]._]+[[:word:]]*|"[^"]+")'
        ,'(?:FROM)(?:\s+ONLY)*\s+([[:alpha:]._]+[[:word:]]*|"[^"]+")','gi'
      )
   ) AS spotted_table
  ,field2
from table1;

Also I don't need records where spotted table is having inc schema suffix like mfg_lz_inc.icc_axbi_kanban_job.

So ideally I am expecting only 1 row in output with spotted table mfg_lz.icc_axbi_kanban_job. However currently I am getting 4 rows. What should I write in regex to achieve that output?

1. There's btrim() if you want to use both rtrim() and ltrim().
2. If you need multiple replace(), you can use a single translate().
3. You called concat() with a single argument, that you constructed by concatenating with ||. You only need one of these: separate arguments passed to concat() with commas, or remove concat() entirely and concatenate with only || instead.
4. [:word:] and [:alpha:] character classes are available in PostgreSQL 14 onwards. Assuming you're on 9.5 (highest version tag you used), you can swap those out for a \w, downgrading your regex a bit (it now allows identifiers to start with a digit, which is not allowed).
5. You're currently catching only the schema in qualified names. You can expand the expression to tolerate dots in unquoted identifiers, or just an optional one in the middle of two quoted identifiers.
6. You can use distinct on(spotted_table)...order by spotted_table to get just one row for each distinct table. Or, if you plan to aggregate, you can add it in the aggregate function: string_agg(distinct spotted_table,',').

Demo at db<>fiddle:

with cte as (
    select field1,field2
          ,translate(''''||
              translate( btrim(field2)
                        , '"''', '' )
              ||''''
             , E'\n"', '' ) as edited_field2 
  from table1)
,cte2 as (
    select *,t.spotted_table as spotted_target,s.spotted_table as spotted_source
    from cte
    left join regexp_matches(
         edited_field2
        ,'(?:UPDATE|INTO)(?:\s+ONLY)?\s+([[:alpha:]_]+[\.\w]*|"[^"]+"(?:\."[^"]+")?)'
        ,'gi'
      ) with ordinality as target_matches(hits,n1) on true
  left join unnest(target_matches.hits) with ordinality as t(spotted_table,n2) on true
  left join   regexp_matches(
         edited_field2
        ,'(?:FROM|JOIN|USING|TABLE)(?:\s+ONLY)?\s+([[:alpha:]_]+[\.\w]*|"[^"]+"(?:\."[^"]+")?)'
        ,'gi'
      ) with ordinality as source_matches(hits,n1) on true
  left join unnest(source_matches.hits) with ordinality as s(spotted_table,n2) on true)
select field1
      ,string_agg(distinct spotted_target,',') as spotted_targets
      ,string_agg(distinct spotted_source,',') as spotted_sources
      ,edited_field2
from cte2
where coalesce(split_part(spotted_target,'.',1) !~* '_inc"?$',true)
  and coalesce(split_part(spotted_source,'.',1) !~* '_inc"?$',true)
group by field1,edited_field2;

7. Consider the pre-built SQL parser tools recommended previously instead of the regular expressions.
8. All versions you tagged are no longer supported. Consider an update.