Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-17-2018, 10:56 PM
steve15 steve15 is offline Calculated field with filename Windows 10 Calculated field with filename Office 2016
Novice
Calculated field with filename
 
Join Date: Sep 2018
Posts: 2
steve15 is on a distinguished road
Default Calculated field with filename

Hi there,


I'm trying to add a field and get dynamic this field to split only a part of the filename :

{ RIGHT(GAUCHE(FILENAME;9);7) \* MERGEFORMAT }

Sadly it doesn't work ... somebody have an idea ?



Thanks a lot
Reply With Quote
  #2  
Old 09-18-2018, 12:41 AM
macropod's Avatar
macropod macropod is offline Calculated field with filename Windows 7 64bit Calculated field with filename Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Word doesn't include anything comparable to a RIGHT or LEFT function of the kind you're trying to implement. There is no practical way of achieving what you want with field coding unless the file name is numeric.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 09-18-2018, 12:43 AM
steve15 steve15 is offline Calculated field with filename Windows 10 Calculated field with filename Office 2016
Novice
Calculated field with filename
 
Join Date: Sep 2018
Posts: 2
steve15 is on a distinguished road
Default

Hi ... too bad ! Thank you for your reply. Never mind
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
filename field not displaying correct filename when that name starts with # plrsmith Word 1 07-06-2018 03:10 AM
Calculated field with filename Calculated field in PivotTable not doing as expected marketshare Excel 2 10-17-2013 02:05 AM
Calculated field with filename Can't figure out calculated field 56_kruiser Excel 2 12-02-2012 03:50 PM
Calculated field with filename Calculated Field is disabled MariaAdc Excel 1 03-01-2011 02:44 AM
Using calculated field - WHY IS IT SO COMPLICATED? Riorin Word 0 10-30-2009 12:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:21 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft