Solution
Input
Output
iVBORw0KGgoAAAANSUhEUgAAAXoAAAA0CAIAAAAL52RvAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAAEnEAABJxAfPceo4AAAASdEVYdFNvZnR3YXJlAEdyZWVuc2hvdF5VCAUAAA0cSURBVHhe7Z3fjhXHEYf9Bs4bxG+A38B+A/sN7DdI3sBccYcSKXBhCQkuLPliibGEfcNeJGKvFiFhNgoKijFai+BVEPJCIrAlS+TbU72V2uo/02dn5uyedX1qjU7XVPd0D1O/qZ4zZ3nrTRAEwUoIuQmCYEWE3ARBsCJORm7+8uQ/Nx7tp0qwDjx58uTu3bu7u7upHgTLs2q5efzi5/e/+PatP31DSaZgHQi5CcazUrm59+zVbz79m2jNsnLz40+/nN/eQ6oQrGQKVkjITTCelcrNJ9s/qNYsJTdWp1iIJWuwQkJugvGsh9y8/emOtgq5ORFCboLxrIfc2FYhNydCyE0wnpCboIuQm2A8ITdBFyE3wXhCboIuQm6C8YTcBF2E3ATjGZCbH3/65Y/fPPt48/v3v/jWvjJDeffzh9jZe+/Zq+Q9xMnKDeM8v733+9v/Yi5s+fzloxdpXzBEyE0wngG5+eCr72yo18o71x4QwIMv4C0lN3+49290gYKu2VZoHEphy6AAXX3w3GmlFuz0gKom1xLs/euT/0pJpsXvMES5RLySdQG71L/ds6JNrHbzWftJpgp2hDO9BhlyE4xnQG4+2tx18dkohG5qVmEpubGe7fLen/+Z2mQQh06tigWfhi5YzUUE8URi1CIluS6wdk5gstZBDdX/t9f+nqxH3zb63e0nyZrh5thzxGMQchOMZ0BuuOty0RPPhBxiYQsWGw9S2okGraxzslawnu3SkJtzn/8jd5bi7ERsapNhnZl1nii5AVh5GpRgsIPkFCXrIr9TO6V2blEi67bW2c3+/j6HAD4kU5PXr1+LPyRTnU43RQbDIVJ9wbKd7O3tuU7EwjbVSxR9BluBjNmdPSzWKNUexH9Cxj4qdgoyodzkSlErNkQt7nBUbQrDZxeotX5ybXLFJRQ3Hu3bve3fvqMO1tmJhT0JrFjzFIwTrg6U2hTGM6vcEAk3b968fPnyBQPVzc1NF+0Cxq2trStXriTXQ7Ds7OwkpwzxuXXrVqo3efjwofi7KYuR0aZ6k9u3b4u/7eSzzz7DwjbVSxR9Fj1duH//fqqXkCOyTfUF0lCNUu1BTsLFixcbMscucb5z504y1RkrN+5yn1BulKUOobgwJlNIO45iFYd4Ttaj5HJDWofEMJJ7z16xzVWANZE6t1c3NoVxWRLQv+6luCUVx2XMuhdtSjtmYD65IX7kei3Ctc5Fn1wXcH1jTLsXEJbWgugUwyPtvnBhMEeAS5cuiXNRbmDwVKCJOqoJ5aYd/NPKDc6Dox10sJxZubE6Yh+IOIhYdaMUO3dyQ1TbB7pFXN6U65Fihenqg+fJanAnzY7QHWVwVGOYSW64JS4u7AOIBxtIHIskAvvGxkYyHdUa9lp/UiR6kL3FmJRWMBgbVgFrcjPYiUS+MKHcAHpaTPpADqrKIkgrZ1QYmzgU/3E5q7K3mFXpiWoooOXMyo19rlRLbQSrJowwWQ3WgW57otrlVkUdAZu80HNNlYpLKndaiiOfkDnkhmtULtbGHRu7DS1dQLmUR8FfFAfPZDoEo0pVYyKalUiC4zwXrVM/jXVNo5ORciPd1lZzk8sNSJ+sbZ3G6Rw716dwNuXm2KP64KvvktVg5SZf79SwGlHsFmx60lhzuenIksr2T4rUSKAmYQ65kaCCznuj3ktrkSNo/Dg5ECOxwZbgSdYMiS7cZHhuygddLAbAttGJ5GVs806KUuIo+mABPQlFsZOBufMj/rWTpqer8Y8roul6kGOhOE6GGpxNuXHf6SRrBTuqopocT27s19uUohzYFKw9L7du+vDrx7bac05GMrncaJZeu1HnSGrTc303wlXvycVwlb1yCOmkKDfaSTGGZWo48CHvpDg2R9EHC/BBtAxymRYJcKMS5+JQoUdu1IcZiUX/+WppZpGzKTdkCrZJslaYSW7QF21FyddT9gusxtMlgd7sUx5bJNmZm8nlRu/SndcrES7+PfKkj4RSfYFaGrdliWSJzFwp4KCLRScy/mN0UpQSR9EHC/CBI4ry5gscmZpTlkW7UXIDGxsb+Fy/fl2qPbPI6ZIbrvUvH704v73HTVXeo9XiXqI7JXJjBYLixuyK/XJnQrkBq3ocKFkPsXt7JMOdBykrWEYJk8uNBAZ0rqQ0KmphYymGkFjkc3F1IHdsdkkMS0S5KR90cbQT9+RCU5taJz2BWvTBAvJZH1Fp/AtyVt28Fu3Gyg3zkiPipk002elkQG4ev/j5483v3SXeKKdTbvrLtHLjXsCx79S43Me9blPDLakoK/sPLeaTm1QfQi/xWthY1NkOWCzyWXMTGzByA9dFVq4UcNDFYSd6FNuJtNKXUPJOilLiKPpggVSpPMmSs+pOUe5mKZ6rIpIzMioZXs8/hKMlN+T/tZ8a1coccuMegswqN8XntceWG7ArIPsFmZ3Uue73ZZzy9ryyPBXzyU3nHVKjoucqL4aQWFLlMKR1aSZNSFikCuLgpnzQRdaJphg9nYiFbaqXKPpggVRZII+9QfuXs+pOkfjUzpuMGdxMi+g3g5oDLkVVbrjfOq0hKtALCndUrnst1odqal/ieHLjWrUPIViBYNg61MGS2h9ljNzYwdvfSdg+88c6NZiLtpJC/2nfzMwnN519snwQ/x65kddhwWqZWFLFhJms5mq64Ia3aPH/TnRU4iZNND+CWrdsU71E0QcLpMoh7vH53HKjJ3apJ8RKVW7sD3/aL5uoG6UWscKJyM34FGCM3LgXcGTR5IydD1/cedAy69t9yuRyoxduj3wI8qwkf6EmR277NsuAxdGOhKusnohqWZi48JaYd1M+6OJoJ/JgGGeJ28FO9KCpXkJaOR8skCqHoKfySEVOy9xys5RzTlVu7AXdfk3Oep5CuaEk63EZIzdgm8uZtN/TN163sdgXAl1p/Lh0QiaXG5A4aby94pDAHrzWuc9Lz7pQEqRtqiwgVsUo/u6hda4UsHD3nehE2Dr/vBNRBJqkegkR1qJqpIpBhRuRXUu5IaTtBd2O8H7PlcmNazLyu5uRcmMf08jPsuyaqPNZr21CsuleLGK+yW825pAbiQ2oRYJD1YE7eePBgaqSXUmBGFPlEH384bQJOuUGdCIuH4G8E11/2TWXRUPayZ8YU+UoOgtZW6233CRrBeu5lNwcbxHRIzdu/P0PR4qMlBumaV/ns+oz+LqN4MRFUiQ7KsrcS6o55EbTEKj9nphAskKggU1cOTUBOrx+/bo45B2KPVUOkTFA3lu/3CzbiRjxz88nEoOdvblyHRy4IjcgfQrrLTftCO/3PIZwgAu2nnTAfc2cv/OyFCPlBtxrh1p6Xrdxz+x1ANitis29pJpDbkCjC1iMoBEcQuCzLE9cGGvyAojL1tYWqwm22LWrPFUB2ZUqBsQCUsXQLzewVCdMR4fKFHZ2dhYz3t3c3BQje11qA7IrVTI4uva5ZnLjnhQ0sgP31LOtIPbGTul8bOG0r7OVi/AxCc54uXFT0CJPjtvYo6Mvtkkx65mJmeQGiCtZAhQhXPPAYxkiTzdysNcWKeKQKh0sJTc1ip1AY9ZMIZ8yyN5UKaFasGZyA/bO+c61B3lgIEn5G4DcY+XvB5NQ5BGeP+/EU3omH5EXl/NFgVM0iv5dZLb9rXArLt8ahxbGyw3kP0E41/G6jROU/BmNHRtJkJyWOZhPbgQyFFISgpNbNPHGB5ZR7cPRhBDa2NjAmS2fsaR9JXCDVOmAAeDvIn+SThSUkZGL7jBrPte0EnoOzRnIO5GGtZ4ZmzjUBmlZyjmnKjf5C6woiPwHBh9+/di++F8rxW+gaz/80TL4m+xiKS4l3NpNCp4yEflBhp1IbT0yidzkgxlMuNAOu4wqypNT1ZHLxgZzy03wa6AqN9zzB6WBgk9DC/J8obas0FIUqTwtyktyPUrtoUmtFNOfSeQmz7aKx7K4E1tLvpyQzbSkCrkJxlOVG+D6zl9jtYUMiJghkOzKS4t70KBwVy/6S6n9aZgbj/YbrRoLkzxNa5TigCeRG7D9DD6Bcs+50JS0o4T9Z5ppSRVyE4ynJTcC1z0SoJkOMU/YcAu1N2c+Ez/qw9VPkDcuevzpgW7pSjqkEFG1G7hQbMWBBr+rYiQMr6FWjLwxYAYmbdkOroAaMHI94uCYmalMUOaYrBU4b+pMaZ/G4xFyE4xnWG7OEsQhcY58SCGkWdzNkQvkcBTVGmQrWdeHkJtgPL8uuTlB7JpuMFs5hYTcBOMJuVkFLAPtd0yryaemJeQmGE/IzSpg4aZa896Ih80nSMhNMJ6Qm9m59+yVTW3aL16fWkJugvGE3MwIa6jz23tWa9Y0tYGQm2A8ITcTg6AgK+8e/YvxUt6u/8d1p5+Qm2A8ITcT4yRGC1ozx+swKyPkJhhPyM3EOJWR8tHm7vrmNULITTCekJuJ0fee2X6y/cPVB8/X8WvvnJcvXz59+jT/81FB0E/ITRAEKyLkJgiCFRFyEwTBSnjz5n+Bsg0wC+hiuAAAAABJRU5ErkJggg==
Weekly Challenge #4
He who sleeps on the floor will not fall off the bed.Robert Gronock16-APR-2005This is a valid record.
After all is said and done, more is said than doneAnonymous09-JAN-1856Oops! The RandomInt field is missing. This record should be rejected into a bad file.
I want to see you shoot the way you shoutTeddy Roosevelt Nov 16, 1900This record is valid but the date is in MMMbDD,bYYYY format.
get someone else to do it.15-APR-1944This record is valid but has a carriage return in the middle of the quote.
Why do they call it rush hour when nothing moves?Mork27-JUN-70This record is valid but has only a two-year date.
I'm taking the Ryanair approach to it: subcontracting everythingMichael O'Leary23-MAY-2011This record is valid and has a single quote in the two text fields.
I Xeroxed a mirror. Now I have an extra Xerox machine."Steven Wright30-JUN-06This record is valid but has a trailing double quote that should be part fo the text field.
Freidrich Engels01-AUG-08This record is missing the first field, the quote. This record should be rejected in a bad file.
'He's so old his social security number is two digits.'Brian Morgan Jan 5 2000This record is valid but the quote is surrounded by single quotes, the date is an unconventional format and the integer has a fractional part.
"I was the best man at the wedding.So why is she marrying him?"Jerry Seinfeld09-July-2001This record is valid but has a carriage return in the quote and the month is fully specified in the date.
"When my wife was asked, "Do you take this man for richer or poorer..." she answered, "For richer!""Anonymous21-May-07This record is valid.
"These are the continuing voyagesTo boldly split infinitives"Gene Roddenberry16-SEP-69This record is valid but contains the record separator within quotes.
"The best cure for insomnia is to get a lot of sleep.W.C.Fields4-SEP-00The quote field has a beginning but not a trailing double quote. This record could be rejected.
I don't even butter my bread; I consider that cooking.,Katherine Cebrian, 08-may-2003,This record uses commas instead of pipes as the field delimiter and can be rejected.
It matters not whether you win or lose; what mattes is whether I win or lose.Darrin Weinberg21-MAR-2005This is a valid record but the integer starts off with a zero, which shouldn't be confused for an octal number.
Smoking is one of the leading causes of statistics.Fletcher Knebel24-OCT-1989This record contains an invalid RandomInt.
I tried to think but nothing happened!"Curly"'11-AUG-1935'This is a valid record but the fields are sometimes contained in quotes.
C:\Users\JEAN-B~1\AppData\Local\Temp\Engine_5532_11de4fb3cc4e4cd7b046bc5887580f61_\Engine_1192_206c7ab38ec04a569dc1700d0248c7b5_.yxdb
Single
Profile
He who sleeps on the floor will not fall off the bed.Robert Gronock16-APR-2005This is a valid record.
2005-04-16
After all is said and done, more is said than doneAnonymous09-JAN-1856Oops! The RandomInt field is missing. This record should be rejected into a bad file.
1856-01-09
I want to see you shoot the way you shoutTeddy Roosevelt Nov 16, 1900This record is valid but the date is in MMMbDD,bYYYY format.
1900-11-16
get someone else to do it.15-APR-1944This record is valid but has a carriage return in the middle of the quote.
1944-04-15
Why do they call it rush hour when nothing moves?Mork27-JUN-70This record is valid but has only a two-year date.
1970-06-27
I'm taking the Ryanair approach to it: subcontracting everythingMichael O'Leary23-MAY-2011This record is valid and has a single quote in the two text fields.
2011-05-23
I Xeroxed a mirror. Now I have an extra Xerox machine."Steven Wright30-JUN-06This record is valid but has a trailing double quote that should be part fo the text field.
2006-06-30
Freidrich Engels01-AUG-08This record is missing the first field, the quote. This record should be rejected in a bad file.
2008-08-01
'He's so old his social security number is two digits.'Brian Morgan Jan 5 2000This record is valid but the quote is surrounded by single quotes, the date is an unconventional format and the integer has a fractional part.
2000-01-05
"I was the best man at the wedding.So why is she marrying him?"Jerry Seinfeld09-July-2001This record is valid but has a carriage return in the quote and the month is fully specified in the date.
2001-07-09
"When my wife was asked, "Do you take this man for richer or poorer..." she answered, "For richer!""Anonymous21-May-07This record is valid.
2007-05-21
"These are the continuing voyagesTo boldly split infinitives"Gene Roddenberry16-SEP-69This record is valid but contains the record separator within quotes.
1969-09-16
"The best cure for insomnia is to get a lot of sleep.W.C.Fields4-SEP-00The quote field has a beginning but not a trailing double quote. This record could be rejected.
2000-09-04
I don't even butter my bread; I consider that cooking.,Katherine Cebrian, 08-may-2003,This record uses commas instead of pipes as the field delimiter and can be rejected.
2003-05-08
It matters not whether you win or lose; what mattes is whether I win or lose.Darrin Weinberg21-MAR-2005This is a valid record but the integer starts off with a zero, which shouldn't be confused for an octal number.
2005-03-21
Smoking is one of the leading causes of statistics.Fletcher Knebel24-OCT-1989This record contains an invalid RandomInt.
1989-10-24
I tried to think but nothing happened!"Curly"'11-AUG-1935'This is a valid record but the fields are sometimes contained in quotes.
1935-08-11
C:\Users\JEAN-B~1\AppData\Local\Temp\Engine_5532_11de4fb3cc4e4cd7b046bc5887580f61_\Engine_1192_feb2ece5818446f1abd4d3cda5d9c942_.yxdb
Single
Profile
Field_1
ParseSimple
Date
Warn
Field_1_Matched
Extracts the date from the quotes.
January
JAN
01
February
FEB
02
March
MAR
03
April
APR
04
May
MAY
05
June
JUN
06
July
JUL
07
August
AUG
08
September
SEP
09
October
OCT
10
November
NOV
11
December
DEC
12
Table to replace months in letters to months in digits.
Date1
Month
Numeric Month
FindAny
Replace
Replaces the month whole written by the digit version.
Date1
3 letters Month
Numeric Month
FindAny
Replace
Replaces the month 3-letters written by the digit version.
Parses strings to DateTime.
REGEX_Match([Date1], '\d+-\d+-\d+')
Custom
=
True
fixed
2019-08-19 10:25:16
0
2019-08-19 10:25:16
2019-08-19 10:25:16
Gets the %d-%m-%Y format dates.
REGEX_Match([Date1], '\d+-\d+-\d+')
REGEX_Match([Date1], '\d+ \d+ \d+')
Custom
=
True
fixed
2019-08-19 10:26:01
0
2019-08-19 10:26:01
2019-08-19 10:26:01
Gets the %m %d %y format dates.
REGEX_Match([Date1], '\d+ \d+ \d+')
REGEX_Match([Date1], '\d+ \d+, \d+')
Custom
=
True
fixed
2019-08-19 10:26:04
0
2019-08-19 10:26:04
2019-08-19 10:26:04
Gets the %m %d, %y format dates.
REGEX_Match([Date1], '\d+ \d+, \d+')
Parses strings to DateTime.
RecordID
1
Int32
6
0
Adds a "Record ID" field to reorder after the future union.
Parses strings to DateTime.
Warning
All
ByName
Unions the results.
Removes unnecessary fields.
C:\Users\JEAN-B~1\AppData\Local\Temp\Engine_5532_11de4fb3cc4e4cd7b046bc5887580f61_\Engine_1192_2cd0c310e7f246878448cbec5251bb87_.yxdb
Single
Profile
.\challenge_4_output.yxdb
False
True
challenge_4_output.yxdb
Horizontal
challenge_4_workflow