Forum

Generate a custom c...
 
Notifications
Clear all

Generate a custom column with content from the filename

2 Posts
2 Users
0 Reactions
93 Views
(@lulu)
Posts: 1
New Member
Topic starter
 

Hi all,

it would be very nice of you if you could help me with the following question.

How do i add a custom column called "calendar week". A section from the file name of the source file has to be written into this new column for each line. The excerpt refers to the 33rd and 33rd position in the file name. (Because the calendar week is only in the file name)

Could you please tell me how to do it with Excel Power Query.

Thx and regards Lulu

 
Posted : 11/05/2023 11:21 am
Riny van Eekelen
(@riny)
Posts: 1185
Member Moderator
 

Would be easier to help if you could upload a file with some data that resembles your real data.

 
Posted : 11/05/2023 11:26 am
Share: