2 Replies Latest reply: May 3, 2012 9:04 AM by Neil Gulliver RSS

    How do I identify different types of Documents ?

    Neil Gulliver

      Hi,

      I have a field containing file names.

      I need to be able to create a field that identifies the suffix (i.e. .xlsx, .doc) and defines what software is being used (i.e. Excel, Word, etc).

       

      How do I do this ? (I think I can use an ApplyMap to cross reference the suffix with the software)

       

      Sample data:


      Highres.pdf
      CV.pdf
      Viewer.pdf
      Feb 11 Stats.xlsx
      March 11 Stats.xlsx
      0085_001 .pdf
      Microsoft Word - Wednesday's Deli  sandwich.doc
      Microsoft Word - 12th-16th.doc
      Microsoft Word - REHEATING  INSTRUCTIONS.doc
      Microsoft Word - The Friday Night  Takeaway 24th Feb.doc
      Microsoft Word - Monday- Friday Menu.doc
      C:\Users\sandwichorder.xps
      Hospitality Rota.xlsx
      Contacts
      Telephone Numbers

       

       

      Many thanks,

      Neil