Hi,
Everyday I will have a data feed which will have this kind of pattern.
product_list_20_20190213.csv
product_list_20_20190214.csv
product_list_20_20190215.csv
product_list_137_20190213.csv
product_list_137_20190214.csv
product_list_137_20190215.csv
and so on (there are actually like hundreds of numbers not only 20 and 137)
What I would like is to turn the
product_list_20 to Apple
product_list_137 to Samsung
And you can see the last 8 characters are the year month date.
it should be converted from 20190213 to 2019-02-13
So from the above sample the outcome should be like.
product_list_20_20190213.csv -> Apple_2019-02-13
product_list_20_20190214.csv -> Apple_2019-02-14
product_list_20_20190215.csv -> Apple_2019-02-15
product_list_137_20190213.csv -> Samsung_2019-02-13
product_list_137_20190214.csv -> Samsung_2019-02-14
product_list_137_20190215.csv -> Samsung_2019-02-15
It should be very simple to do but after 2 days I still can't figure out how to do this in a single click...