Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
My solution.
Matched with the expected data except for the file name.
Spoiler
Workflow
I assumed that Error, Warning, FieldConversionError appears separately one for each row.
I admit that this solution is vulnerable to the change of log format,
but we cannot foresee how the format will change in the future version anyway.
Formula Tools
[WorkflowName] = GetWord([Field_1], 2)
[StartTime] =
DateTimeParse(
REGEX_Replace([Field_1],".*([a-zA-Z]{3}\s+\d{1,2}\s\d{2}:\d{2}:\d{2}\s\d{4})", "$1"),
"%b %d %H:%M:%S %Y")
[Duration] = GetWord([Field_1], 2)
[Warning] = Substring([Field_1],25,Length([Field_1]))
[Error] = Substring([Field_1],23,Length([Field_1]))
[ConversionError] = Substring([Field_1],38,Length([Field_1]))
[Seconds] =
ToNumber(Left([Duration], 2)) * 60 * 60 +
ToNumber(Substring([Duration],3,2)) * 60 +
ToNumber(Substring([Duration],6,2)) +
ToNumber(Right([Duration], 3)) / 1000
I assumed that Error, Warning, FieldConversionError appears separately one for each row.
I admit that this solution is vulnerable to the change of log format,
but we cannot foresee how the format will change in the future version anyway.
Formula Tools
[WorkflowName] = GetWord([Field_1], 2)
[StartTime] =
DateTimeParse(
REGEX_Replace([Field_1],".*([a-zA-Z]{3}\s+\d{1,2}\s\d{2}:\d{2}:\d{2}\s\d{4})", "$1"),
"%b %d %H:%M:%S %Y")
[Duration] = GetWord([Field_1], 2)
[Warning] = Substring([Field_1],25,Length([Field_1]))
[Error] = Substring([Field_1],23,Length([Field_1]))
[ConversionError] = Substring([Field_1],38,Length([Field_1]))
[Seconds] =
ToNumber(Left([Duration], 2)) * 60 * 60 +
ToNumber(Substring([Duration],3,2)) * 60 +
ToNumber(Substring([Duration],6,2)) +
ToNumber(Right([Duration], 3)) / 1000
Great opportunity to investigate various tools, work on RegEx code, data modeling, and some advanced tools preparing for renewing Core Certification. A Challenge where no two solutions will be alike, certainly none like mine. The FileName and WorkFlow values do not match the Task 1 solution so something is up with that.
Fifteen tools used in this solution.
I had fun with this one, I'm sure there are less brute-force ways to do it but I was able to keep it short and sweet!
