Capturing the Source File Name from a Macro Input

I would like to configure a macro to write the input file name into a field, capturing the file name from the macro input. I can't rely on the 'Output File Name as Field' option being used, since the file input is outside the scope of the macro. I was hoping there was some sort of function that would parse the source filename from a data stream, but have as yet been unable to find it.

Screen shot attached below, for general reference:

Thanks,

-Dan

Macros

Accepted answers

JordanB

Hi Dan,

Is the input file outside the macro changing? If so the input file should automatically update the macro input and change the file name field if you choose the 'Output File Name as Field' option. I have tested this and it seems to work for me.

Alternatively there is the field info tool within the developers tab which produces the source file you referenced below. You could then parse the file name using reg-ex or text to column tool from there.

Best,

Jordan Barker

Client Service Representative

All comments

JordanB

Hi Dan,

Best,

Jordan Barker

Client Service Representative

daniel_mmi

Thanks, Jordan. That did it.

Since I couldn't guarantee the user would have the file name included in advance, I used the Field Info tool as you suggested. From there, I just had to select transpose the Field Info results, then parse the file name from the path. In order to get it back into the output file, I populated the desired _FileName field with "path", then used the Find and Replace tool to replace the word "path" in the _FileName field with the actual file name, from the reference table.

AndyC

Posted in error!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703