This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 

File Operation snap question

heidi_andrew
Contributor

โ€Ž05-09-2023 07:37 AM

I want to do the file compare (DIFF) on two files but the name changes every day with a new date. On my File Reader snap, I have put the file names in like this
โ€œsmb://xxxxxx.com/us_data/Shared/MM365/Clients/Small Market/Reporting/Non-Standard_Reporting/xxxxxxx_CUSTOM_FILE/SNAP_PAREXEL/xxxxxxx_Custom_Report_โ€ + Date.now().toLocaleDateString({โ€œformatโ€:โ€œMM_dd_YYYYโ€}) +โ€œ.xlsxโ€

the excel parser is throwing an error on this function. I need to compare the files on a daily basis. The files are written out with todayโ€™s date. How can i set up a pipeline to read these files and compare them to yesterdayโ€™s results? The file name will change daily. Any ideas?

0 Kudos
1 REPLY 1

heidi_andrew
Contributor

โ€Ž05-25-2023 09:17 AM

i figured this outโ€ฆi had some spaces in one location in the date that did not match the file reader location.

0 Kudos