Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. asandy1234

    Scientific format conversion

    My suggestion is since it is a text field try using substr function to manipulate For example Buyer_order=(put(substr(buyer_order_no,1,4),8.)*100000000000000);
  2. asandy1234

    How to delete specific rows from an external file?

    There are lot of options 1) Treat it as a text file use some shell script to parse the string ( If you need one I have a sample) 2) Save it in the database as CLOB and use xquery to get the results. 3) Use SAS XML Mapper to create the schema and import it into SAS. Hope this helps.
  3. asandy1234

    Parse text data to extract sub-string

    We have a XML saved as CLOB datatype in a DB2 table. In the XML text we need to extract the substring between nodes <text> and </text>. Since the number of occurence of this is not contant(multiple occurence), we have difficulty using SUBSTR function. Any guidance is appreciated. Thanks,

Part and Inventory Search

Back
Top