Challenge #20: List Parsing

[nSpire]

Spoiler

 

[Erin]

[Zongkai]

Good to check the browser before cleaning the data.

Was not aware that some phone numbers start with 1- 

[saurabhkunal12]

Hi, Can someone please explain me why was this logic applied.

trim([Field_1]) != "." and trim([Field_1]) != "RFI ."

Also for adding record ids how this formula has this been derived is because Company_Name was first field in Field_1

if [Field] == "Company_Name" then [Row-1:RecordNumber]+1 else [Row-1:RecordNumber] endif

[rapetter]

Done

[Bobbyt23]

That was a real horrible one!

[zmatipano]

Here is my solution :) 

Spoiler

 

[Tyro_abc]

Interesting!

Spoiler

[cmoussa]

[martinson]

Nice