Forum Discussion
Date for all rows
Hello, I have a folder with multiple files, everyday there comes a new file in the folder. (it is a summary with all the production numbers each day). Each file contains the date of that day ...
My file name includes the date, but how do i parse it out and convert it to a date?
m_dekorte
Resident Rockstar
Resident RockstarHi Anonymous,
Does it have a fixed position in the file name?
And/or can you share a representative example of these file names?
It looks like this. The data is very messy, i have to clean it up. But this is for the example
It looks like this. The data is very messy, i have to clean it up. But this is for the example
I fixed it, thanks for the help!
- m_dekorte
Hi Anonymous
Give something like this a go
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCijKTylNLslMLS5JLMksBjKyU/MU8hITixRSK5JTcxSMDIyMdQ1MdQ1MdA3MdQ0MdI0M9SpyiiuUYnVI0W1KkW4zdN2xAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Name = _t]), AddDate = Table.AddColumn(Source, "Date", each [ v = Splitter.SplitTextByCharacterTransition( {"A".."z", " "}, {"0".."9"})([Name]){1}?, r = try Date.From( Text.Start(v, 10), "nl-NL") otherwise null ][r], type date ) in AddDatePs. If this helps solve your query please mark this post as Solution, thanks!