• EN
Question

FilenameExtractor does not use value

  • 1 May 2024
  • 1 reply
  • 20 views
mccunee
Rank
Badge +1

I am trying to use the FilenameExtractor to get the rootname of the source file to match the new filename in a different source directory with a different format i.e. my pipeline is essentially

MyFileName.xlsx → MyFileName.json

Currently if I use the source filename input paramter the behavior is like:

MyFileName.xlsx → MyFileName.xlsx.json , which I don’t want.

I tried using the FileNameExtractor where _rootname gets set as a user paramet but then the output is like:

MyFileName.xlsx → _rootname.json 

The value of the user parameter does not actually extract the rootname and save its value as the user parameter dynamically. Can anyone help?

edit:

Scripted Python (safe.com)

I used a scripted parameter at the start of the workspace but still curious as to why the filename extractor did not perform as expected?

1 reply

hkingsbury
Rank
Userlevel 5
Badge +29

I might not be quite understanding the problem here, but there are two pretty straight forward ways to pull the source filename and then suffix and prefix it.

  1. Pull the parameter being used by the reader then extracting the rootname and updating it
  2. Exposing the fme_basename attribute on the reader and then updating that

 

 

Check out the Abley FME Firesides on Youtube: https://www.youtube.com/@ableyltd

Reply


Community Stats

28,869
Posts
109,984
Replies
36,672
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.