line="USING (FILE '/TEST1/FILENAME'5000)"

echo $line | awk -F\' '{split($3, a, /)/);print a[1]}'
5000