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 SkipVought 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. leonracsis

    LOOKUP function

    I have cases where the value to lookup in a reference table does not exist and the map just doesn't process the whole record. EMP_REC: EMPLOYEE EMP_CODE 100 A 200 B 300 C EMP_CODE_REC: EMP_CODE DEPT A DEPT 1 B DEPT 2 LOOKUP...
  2. leonracsis

    Import Text File to a create Type Tree

    Searched the documentation and this forum but couldn't find what format should a text file be in so I can import and create a type tree with it? I'd imagine it will be something like field name, type, etc. Thanks in advance!
  3. leonracsis

    Creating a Sequence Number in Rule

    Excellent! Thanks, Man.
  4. leonracsis

    Creating a Sequence Number in Rule

    I need to autonumber the output lines in a Mercator Map. Does anybody know how to handle this best? Thanks!
  5. leonracsis

    Help! Remove Quotation Marks in CSV

    Thanks for the quick reply. I did try using the Substitute function before but not sure what release character to use for the double-quote and how to represent a null substitute: =SUBSTITUTE(CompanyName Field:Customers,""","") This is giving me a parameter expected...
  6. leonracsis

    Help! Remove Quotation Marks in CSV

    Hi! I'm a new Mercator user and I'm using a comma-delimited file with quotation marks for each field in the input file: "ALFKI","Alfreds Futterkiste","Maria Anders" But when I get the field values, the quotation marks become part of the output field. I need to...

Part and Inventory Search

Back
Top