I am trying to find the pattern using oracle sql developer. Include numbers that are "x0000"," 0000",".0000"
AND REGEXP_INSTR(string=>FTP.TEXT, pattern=>'[x]\d\d\d\d\s', match_parameter=>'i')
Use
where REGEXP_LIKE(str,'[x.[:space:]]\d{4}','i')
The [x.[:space:]]\d{4}
expression matches x
, .
or any whitespace, then any four digit characters.