Challenge #447: Analysis of Survey Results Delivered in a Consolidated Format

[ed_hayter]

Spoiler

Great challenge - enjoyed the edge case of people starting their response with a '-'. I do think the challenge should emphasize more that incomplete surveys should be removed. Probably just emboldening that statement in the big blurb but thats nitpicking I thought this was a really fun weekly challenge

[Hub119]

Solution attached.

[nSpire]

Spoiler

 

[Qiu]

@AkimasaKajitani Congratulations!

This is a really nice one to me so my vote to this one for the October Takeover. 😁

Spoiler

[Yogesh1795]

Easy one, use "`" sign for parsing for the 3rd one.
Check my solution as I only used basic regex to do this challenge.

[Yoshiro_Fujimori]

My solution.

Spoiler

I first tried to split answers (in multiple rows) with one RegEx tool, but it did not work. (not sure why)
So I used RegEx in Formula Tool to add a delimiter to use in Text To Columns Tool instead.

Workflow


Task1 Formula
Minutes = Round(DateTimeDiff([Date Submitted],[Time Started],"second") / 60, 0.1)

Task2 Formula-1
Question_And_Answer = REGEX_Replace([Question_and_Answer], "\nQ_", "|Q_")

Task2 Formula-2
Question_No = REGEX_Replace([Question_and_Answer], "\n.*", "")
Answer = REGEX_Replace([Question_and_Answer], "^Q_\d+\n", "")
Answer = IF IsEmpty([Answer]) THEN Null() ELSE [Answer] ENDIF

[danboll_life]

Spoiler

 

[gawa]

@AkimasaKajitani  Congrats!

Spoiler

[TurboToad]

Fun parsing challenge!

Spoiler

[Caramel8]

Spoiler

Third part was difficult given the delimiters