I have a 16 character field, where b=one space, for example: A100bb3733312229 I have to disregard the last 4 positions -- in this example 2229 and the first 3 positions (A10). Then, starting in position 4 for a length of 9, I have to zero fill any blank spaces. In this example, the result should be: 000373331 The number of leading blanks can change--could be 1,2, or 3. My result has to be a nine digit character field. I am writing a Unix script that calls another file: sqlplus USERNAME/PASSWORD$DB <<!EOFSQL @filepath_name/sql/format.sql The format.sql contains the sql that selects and formats this field. Any suggestions on how to code for this? Nothing that I have tried so far seems to work. Thank you for your help.
-- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
