Pull data from Filename

[davidl923]

I need to take a date out of the filename to add to the HL7 output.
Filename example: MRMC_Epic_Demo_2024-2-29.txt
Not sure how to do this in the Transformer to use to strip away the "MRMC_Epic_Demo_" and ".txt"

[Hueli]

I think the question would be better placed in the “nextgenhealthcare / connect” repostitory.

I assume that the SourceConnector is a FileReader. In this case, the name of the file is in the SourceMap under 'originalFilename'. The date could then be extracted into a variable 'dateFileName'.

var originalFilename = sourceMap.get('originalFilename') + '';
var dateFileName = originalFilename.replace(/^.*?(\d{4}-\d{1,2}-\d{1,2})$\.txt/i,“$1”);

The regular expression works as long as the file name ends with a date in the format (yyyy-m[m]-d[d]) and the extension .txt (case insesitive).

There are certainly more elegant methods, but this one works.

Is this the solution to the problem?