Remove date from the filename and save to onedrive

[Anonymous]

Hey Team,

Im collecting all email attachments and storing it in onedrive.  I tried multiple substring functions wasnt able to parse it out.

The Filename of the attachment is filename-2021-02-05.csv

Would we be able to remove the date and just have filename.csv ?

Any help would be appreciated.

[Paulie78]

Try this:

concat(substring(outputs('filename'),0, indexOf(outputs('filename'), '-')), '.csv')

You will need to replace outputs('filename') with whatever dynamic content contains your filename.

[Anonymous]

@Paulie78 Thanks for the response

It has multiple - in between. Filename-category-2021-01-04.csv

[Paulie78]

Does the year (2021) always match the current year of now?

[Anonymous]

It should. Even if we can remove last 15 chars and append .csv I think it will work

[Paulie78 · Accepted solution]

Try this instead:

concat(substring(outputs('filename'),0, indexOf(outputs('filename'), concat('-',formatDateTime(utcNow(), 'yyyy')))), '.csv')

This takes everything up to -2021 (or whatever the current year is) and then adds .csv on to the end.

[Paulie78 · Accepted solution]

Your 15 characters method also works well:

concat(substring(outputs('filename'),0, sub(length(outputs('filename')), 15)), '.csv')