Skip to content

Instantly share code, notes, and snippets.

@vancassa
Created November 8, 2018 13:54
Show Gist options
  • Select an option

  • Save vancassa/524bd77c9ca6628abb670febcd080f02 to your computer and use it in GitHub Desktop.

Select an option

Save vancassa/524bd77c9ca6628abb670febcd080f02 to your computer and use it in GitHub Desktop.
We can make this file beautiful and searchable if this error is corrected: It looks like row 4 should actually have 1 column, instead of 12 in line 3.
"Vanessa"
"Wed 7 Nov 2018, 9:30:55 am"
"-------"
"Date","Booking Code","Pick Up","Intermediate Drop Off","Drop Off","Ride Distance (km)","Booking Type","Vehicle Plate","Tag","Trip Code / Trip Description","Currency","Fare"
"Tue 2 Oct 2018, 9:27:31 am","ADR-13440769-5-044","My office address","","Customer 1 address","12.61","JustGrab","SLD8503A","Work","- / -","SGD","13"
"Tue 2 Oct 2018, 5:44:21 pm","ADR-13440769-5-045","Customer 1 address","","My office address Rd","14.33","JustGrab","SJS6028M","Work","- / -","SGD","21"
"Tue 9 Oct 2018, 4:42:21 pm","ADR-13440769-5-046","Customer 5 address","","My office address Rd","9","JustGrab","SMA9121R","Work","- / -","SGD","13"
"Mon 15 Oct 2018, 12:59:42 pm","ADR-13440769-5-047","My office address","","MAX Atria Singapore Expo Hall 1","29.78","JustGrab","SJL1277E","Work","- / -","SGD","24"
"Tue 16 Oct 2018, 1:53:07 pm","ADR-13440769-5-048","My office address","","Customer 2 address","23.91","JustGrab","SLP866S","Work","- / -","SGD","20"
"Tue 16 Oct 2018, 6:54:57 pm","ADR-13440769-5-049","Customer 4 address","","Faber Peak Singapore","18.72","JustGrab","SLH4200D","Work","- / -","SGD","16"
"Wed 17 Oct 2018, 9:01:56 am","ADR-13440769-5-050","My office address","","MAX Atria Singapore Expo Hall 1","30.2","JustGrab","SLD2238E","Work","- / -","SGD","26"
"Wed 17 Oct 2018, 6:28:39 pm","ADR-13440769-5-052","MAX Atria Singapore Expo Hall 1","","My office address","29.31","JustGrab","SJP6566S","Work","- / -","SGD","30"
"Thu 18 Oct 2018, 5:51:58 pm","ADR-13440769-5-053","Customer 2 address","","My office address","24.16","JustGrab","SLH2062Z","Work","- / -","SGD","20"
"Fri 19 Oct 2018, 1:25:36 pm","ADR-13440769-5-054","My office address","","Customer 3 address","30.54","JustGrab","SLV3004L","Work","- / -","SGD","24"
"Mon 22 Oct 2018, 6:06:37 pm","ADR-13440769-5-059","Customer 3 address","","My office address","30.79","JustGrab","SLT4654P","Work","- / -","SGD","25"
"Tue 23 Oct 2018, 10:30:33 am","ADR-13440769-5-060","My office address","","Customer 2 address","23.49","JustGrab","SLZ5634J","Work","- / -","SGD","19"
"Tue 23 Oct 2018, 5:59:40 pm","ADR-13440769-5-061","Customer 2 address","","My office address","24.18","JustGrab","SHB1347M","Work","- / -","SGD","20"
"Wed 24 Oct 2018, 12:24:46 pm","ADR-13440769-5-062","Lobby The Strategy","","Customer 2 address","23.6","JustGrab","SLZ3976K","Work","- / -","SGD","20"
"Wed 24 Oct 2018, 5:20:26 pm","ADR-13440769-5-063","Customer 2 address","","My office address","24.19","JustGrab","","Work","- / -","SGD","20"
"-------"
"Total"
"SGD","311"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment