core.noscript.text
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
It is easy on. I just use a text-to-column tool to convert text into column, formula tools to remove extra quotation and parse the string into text and then I use the select statement for renaming and selection of particular column.
Hello,
Here is my solution, I parsed the text for , and ", and used the datetime tool.
Thanks
Shyam
I also used an exactly similar approach. Can you suggest a way to reduce the number of tool used for the problem?
Here it is
Challenge #2
my solution
This is my first challenge.
Many thanks.
Thanks for the practice