Rename the csv file with the date from csv before uploading to dropbox

How To
,
1

image
image1384×315 42.8 KB

image

hi, I want to rename the csv file I got from gmail with the start date of the month that the first cell of the csv file shows. For example, A2 cell shows “Jun 30,2024”, I need to rename the file with “20240601”. I have no idea what to do in the “parse csv” or “text parser” to achieve this:( Really appreciate your help :blush:

2

Hi @Krabs_Siew

The Parse CSV module outputs all the rows one by one. You can connect it to a Text Aggregator module.

Here, enable the advanced settings and keep the separator as newline, then map each field again with comma separation. Between, you can apply the required function to format the value of the particular column.

Alternatively, you can go with “Create CSV (Advanced)” with same approach.

Regards,
Msquare Automation - Gold Partner of Make

Book a Free Consultation | Connect Live

Explore our YouTube Channel for valuable insights and updates!