Power Query - Create column based on source name

[fsuguy92]

Hey guys, I was wondering if it was possible to create a column based on the name of a source. For instance, I have sources called Arizona_Cardinals_report, Washington_Redskins_report, etc... I'd like it to look at the source name and call Arizona_Cardinals_report "Arizona Cardinals" and so on and so forth.

Currently I am importing the data from a csv and dropping it into an excel template that cleans the data for me. It is a HUGE file and takes forever, so I think Power Query might be a better way to do this efficiently.

Thanks!

 

[sandy666]

maybe try PQ with From Folder option then remove extension from the column and next add suffix _report