Grand Prix Racing Online Forum > Bug forum > The most annoying white space in GPRO Dodaj ten wątek do ignorowanych Dodaj ten wątek do obserwowanych
Strona [1] 
Autor Wątek: The most annoying white space in GPRO 6 odpowiedzi
Chris Shaw
(Grupa Amateur - 36)



Postów: 901
  Kraj: Anglia 
Certyfikowany: 
Postaw plusa za ten post. (1)   Postaw minusa za ten post. (1)
Stary post #1 Opublikowane Wrz 5 2021, 13:29:24 Cytuj 
The weather reported in the first lap of the race report has a hidden space after the string, eg

"Rain" -> "Rain "

eg 2 Making it less obvious so you see how annoying this is...

Weather
Cloudy
Cloudy
Cloudy

This has literally taken me hours to debug why my data collector fails, can this be fixed so no one else has this pain? :)
Montes Dimemola
(Grupa Pro - 22)



Postów: 242
  Kraj: Rumunia 
Certyfikowany: 
Postaw plusa za ten post. (1)   Postaw minusa za ten post. (1)
Stary post #2 Opublikowane Wrz 5 2021, 14:17:02 Cytuj 
=TRIM
Luke Frost
(Grupa Pro - 20)



Postów: 11111
  Kraj: Australia 
Certyfikowany: 
Postaw plusa za ten post. (0)   Postaw minusa za ten post. (0)
Stary post #3 Opublikowane Wrz 5 2021, 14:56:28 Cytuj 
Quote ( Chris Shaw @ September 5th 2021,13:29:24 )

my data collector


You seem to be in a klas of your own there. ;)


Quote ( Chris Shaw @ September 5th 2021,13:29:24 )

eg 2 Making it less obvious so you see how annoying this is...

Weather
Cloudy
Cloudy
Cloudy


You can use find, mid, left, len (etc) to isolate these words within a string:
https://datatofish.com/excel-string-functions-left-right-mid...
Chris Shaw
(Grupa Amateur - 36)



Postów: 901
  Kraj: Anglia 
Certyfikowany: 
Postaw plusa za ten post. (0)   Postaw minusa za ten post. (0)
Stary post #4 Opublikowane Wrz 5 2021, 18:27:01 Cytuj 
I know trim, and clean, but that is no consolation after spending ages debugging. It' just a little messy having 1 cell with a random white space character when everything else is ok!
Jorrit Boer
(Grupa Amateur - 53)


Postów: 181
  Kraj: Holandia 
Certyfikowany: 
Postaw plusa za ten post. (0)   Postaw minusa za ten post. (0)
Stary post #5 Opublikowane Wrz 5 2021, 19:45:20 Cytuj 
Quote ( Chris Shaw @ September 5th 2021,18:27:01 )

I know trim, and clean, but that is no consolation after spending ages debugging. It' just a little messy having 1 cell with a random white space character when everything else is ok!


Glad to see your OCD is no longer an issue... :)
Miel Soeterbroek
(Grupa Elite)



Postów: 3107
  Kraj: Holandia 
Certyfikowany: 
Postaw plusa za ten post. (1)   Postaw minusa za ten post. (0)
Stary post #6 Opublikowane Wrz 5 2021, 20:10:56 Cytuj 
It's fairly common for browsers to ignore leading and trailing spaces in leaf html elements.
It's also fairly common to find inconsistencies in GPRO's html structure.

Adapt your big bad data collector accordingly ;)


Montes Dimemola
(Grupa Pro - 22)



Postów: 242
  Kraj: Rumunia 
Certyfikowany: 
Postaw plusa za ten post. (1)   Postaw minusa za ten post. (0)
Stary post #7 Opublikowane Wrz 5 2021, 21:54:54 Cytuj 
i.e. never trust 3rd party data input
Strona [1] 
Grand Prix Racing Online Forum > Bug forum > The most annoying white space in GPRO Dodaj ten wątek do ignorowanych Dodaj ten wątek do obserwowanych

Odpowiedz w tym wątku