pmassin Posted April 23, 2014 Posted April 23, 2014 FMm'ers, Ik probeer uit de inhoud van een veld dat de inhoud van een directory en subdirectories weergeeft enkel de eigenlijke bestanden over te houden. De veldinhoud : volumes/WORK/Jobs/404375/in/BB 4501070441 MailingFactory.pdf volumes/WORK/Jobs/404375/in/SPLIT_2000BAH02_Output_20140422_125219.tar.gz volumes/WORK/Jobs/404375/in/Briefing.pdf volumes/WORK/Jobs/404375/in/PRD/ volumes/WORK/Jobs/404375/in/PRD/GEW0/ volumes/WORK/Jobs/404375/in/PRD/GEW0/affinium/ volumes/WORK/Jobs/404375/in/PRD/GEW0/affinium/Affinium/ volumes/WORK/Jobs/404375/in/PRD/GEW0/affinium/Affinium/Campaign/ volumes/WORK/Jobs/404375/in/PRD/GEW0/affinium/Affinium/Campaign/partitions/ volumes/WORK/Jobs/404375/in/PRD/GEW0/affinium/Affinium/Campaign/partitions/partition1/ volumes/WORK/Jobs/404375/in/PRD/GEW0/affinium/Affinium/Campaign/partitions/partition1/Project/ volumes/WORK/Jobs/404375/in/PRD/GEW0/affinium/Affinium/Campaign/partitions/partition1/Project/2000/ volumes/WORK/Jobs/404375/in/PRD/GEW0/affinium/Affinium/Campaign/partitions/partition1/Project/2000/2000BAH02/ volumes/WORK/Jobs/404375/in/PRD/GEW0/affinium/Affinium/Campaign/partitions/partition1/Project/2000/2000BAH02/Output/ volumes/WORK/Jobs/404375/in/PRD/GEW0/affinium/Affinium/Campaign/partitions/partition1/Project/2000/2000BAH02/Output/MAILS/ volumes/WORK/Jobs/404375/in/PRD/GEW0/affinium/Affinium/Campaign/partitions/partition1/Project/2000/2000BAH02/Output/MAILS/MAIL-20140401-Summary.XLS volumes/WORK/Jobs/404375/in/PRD/GEW0/affinium/Affinium/Campaign/partitions/partition1/Project/2000/2000BAH02/Output/MAILS/SPLIT_2000BAH02_Output_20140422_125219.log volumes/WORK/Jobs/404375/in/PRD/GEW0/affinium/Affinium/Campaign/partitions/partition1/Project/2000/2000BAH02/Output/MAILS/MAIL-20140401.XLS volumes/WORK/Jobs/404375/in/PRD/GEW0/affinium/Affinium/Campaign/partitions/partition1/Project/2000/2000BAH02/Output/MAILS/MAIL-20140401_F.XLS volumes/WORK/Jobs/404375/in/PRD/GEW0/affinium/Affinium/Campaign/partitions/partition1/Project/2000/2000BAH02/Output/MAILS/MAIL-20140401_N.XLS Wat ik graag over zou houden : BB 4501070441 MailingFactory.pdf SPLIT_2000BAH02_Output_20140422_125219.tar.gz Briefing.pdf MAIL-20140401-Summary.XLS SPLIT_2000BAH02_Output_20140422_125219.log MAIL-20140401.XLS MAIL-20140401_F.XLS MAIL-20140401_N.XLS Moet ik loopen en een variabele aanvullen? Eeuwige dank... Philippe Quote
0 rmw Posted April 23, 2014 Posted April 23, 2014 Als je een custom functie kunt maken (Pro Advanced) kan je deze gebruiken: FilesFromDirectorylist ( theList ) If ( ValueCount ( theList ) ; Let ( [ xItem = GetValue ( theList ; 1 ) ; xStart = Position ( xItem ; "/" ; 1 ; PatternCount ( xItem ; "/" ) ) ; xFile = Middle ( xItem ; xStart + 1 ; Length ( xItem ) - xStart ) ] ; xFile & If ( IsEmpty ( xFile ) ; "" ; "¶" ) & FilesFromDirectorylist ( RightValues ( theList ; ValueCount ( theList ) - 1 ) ) ) ; "" ) Anders moet je in een loop de stappen door die in het let-statement staan. HTH rmw Quote
0 bigbadwolf Posted April 28, 2014 Posted April 28, 2014 Ander alternatief is Troi File plug-in. Quote
0 yamas Posted May 9, 2014 Posted May 9, 2014 Een aangepaste versie zoals ik die bij Kevin Frank gevonden heb. http://filemakerhacks.com/2011/01/05/dude-that-code-is-sooooo-fm3/ Let ( [ _theList = Substitute ( _Value ; “/” ; “¶” ) ; _count = ValueCount ( _theList ) ] ; GetValue ( _theList ; _count ) ) Yamas Quote
Question
pmassin
FMm'ers,
Ik probeer uit de inhoud van een veld dat de inhoud van een directory en subdirectories weergeeft enkel de eigenlijke bestanden over te houden.
De veldinhoud :
volumes/WORK/Jobs/404375/in/BB 4501070441 MailingFactory.pdf
volumes/WORK/Jobs/404375/in/SPLIT_2000BAH02_Output_20140422_125219.tar.gz
volumes/WORK/Jobs/404375/in/Briefing.pdf
volumes/WORK/Jobs/404375/in/PRD/
volumes/WORK/Jobs/404375/in/PRD/GEW0/
volumes/WORK/Jobs/404375/in/PRD/GEW0/affinium/
volumes/WORK/Jobs/404375/in/PRD/GEW0/affinium/Affinium/
volumes/WORK/Jobs/404375/in/PRD/GEW0/affinium/Affinium/Campaign/
volumes/WORK/Jobs/404375/in/PRD/GEW0/affinium/Affinium/Campaign/partitions/
volumes/WORK/Jobs/404375/in/PRD/GEW0/affinium/Affinium/Campaign/partitions/partition1/
volumes/WORK/Jobs/404375/in/PRD/GEW0/affinium/Affinium/Campaign/partitions/partition1/Project/
volumes/WORK/Jobs/404375/in/PRD/GEW0/affinium/Affinium/Campaign/partitions/partition1/Project/2000/
volumes/WORK/Jobs/404375/in/PRD/GEW0/affinium/Affinium/Campaign/partitions/partition1/Project/2000/2000BAH02/
volumes/WORK/Jobs/404375/in/PRD/GEW0/affinium/Affinium/Campaign/partitions/partition1/Project/2000/2000BAH02/Output/
volumes/WORK/Jobs/404375/in/PRD/GEW0/affinium/Affinium/Campaign/partitions/partition1/Project/2000/2000BAH02/Output/MAILS/
volumes/WORK/Jobs/404375/in/PRD/GEW0/affinium/Affinium/Campaign/partitions/partition1/Project/2000/2000BAH02/Output/MAILS/MAIL-20140401-Summary.XLS
volumes/WORK/Jobs/404375/in/PRD/GEW0/affinium/Affinium/Campaign/partitions/partition1/Project/2000/2000BAH02/Output/MAILS/SPLIT_2000BAH02_Output_20140422_125219.log
volumes/WORK/Jobs/404375/in/PRD/GEW0/affinium/Affinium/Campaign/partitions/partition1/Project/2000/2000BAH02/Output/MAILS/MAIL-20140401.XLS
volumes/WORK/Jobs/404375/in/PRD/GEW0/affinium/Affinium/Campaign/partitions/partition1/Project/2000/2000BAH02/Output/MAILS/MAIL-20140401_F.XLS
volumes/WORK/Jobs/404375/in/PRD/GEW0/affinium/Affinium/Campaign/partitions/partition1/Project/2000/2000BAH02/Output/MAILS/MAIL-20140401_N.XLS
Wat ik graag over zou houden :
BB 4501070441 MailingFactory.pdf
SPLIT_2000BAH02_Output_20140422_125219.tar.gz
Briefing.pdf
MAIL-20140401-Summary.XLS
SPLIT_2000BAH02_Output_20140422_125219.log
MAIL-20140401.XLS
MAIL-20140401_F.XLS
MAIL-20140401_N.XLS
Moet ik loopen en een variabele aanvullen?
Eeuwige dank...
Philippe
4 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.