Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
First thing you can extract the extension from the file name like this.
subfield(filename,'.',2) as Extension
and then you can create a new table which will have fields as Extension and Software used.
Now you can link this two table with extension field.
Hope this will help
Regards,
Kaushik Solanki
Hi,
First thing you can extract the extension from the file name like this.
subfield(filename,'.',2) as Extension
and then you can create a new table which will have fields as Extension and Software used.
Now you can link this two table with extension field.
Hope this will help
Regards,
Kaushik Solanki
Hi, Kaushik.
Thanks for your help. Very useful.
Regards,
Neil