Jump to content
  • 0

Substitute


pmassin

Question

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

Link to comment

4 answers to this question

Recommended Posts

  • 0

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

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...