| --- Log opened Thu Nov 28 00:00:26 2024 |
| 00:45 | | Vornicus [Vorn@Nightstar-8k6f0b.res.spectrum.com] has quit [Connection closed] |
| 03:16 | | Degi_ [Degi@Nightstar-k2k0um.pool.telefonica.de] has joined #code |
| 03:18 | | Degi [Degi@Nightstar-u70utq.pool.telefonica.de] has quit [Ping timeout: 121 seconds] |
| 03:18 | | Degi_ is now known as Degi |
| 07:51 | <@macdjord> | abudhabi: My first thought would be to export the data as, say, CSV, or some other plain-text format. Then use a text editor to check it, make sure e.g. that the 'blank' cells don't actually contain non-breaking spaces or something. Then reimport. |
| 08:12 | <@gnolam> | My first thought was similar: just copy the column to a text editor and then copy it back. |
| 08:21 | < abudhabi> | macdjord: Funny thing is, it was originally in CSV. |
| 08:24 | <@macdjord> | abudhabi: Yes, but did you check the CSV before importing it? Inspect for weird whitespace in the 'blank' columns? Check the decimal values weren't written in "double quotes", thus forcing them to be imported as text? My point is, CSV doesn't /fix/ these errors, it just makes them easier to see and to - with the help of a good find/replace regex - automatically fix. |
| 08:25 | < abudhabi> | I did not. |
| 12:20 | | Kizor [Kizor@Nightstar-nfsqa7.yok.fi] has quit [[NS] Quit: ] |
| 12:45 | | Kizor [Kizor@Nightstar-nfsqa7.yok.fi] has joined #code |
| 14:18 | | Kimo|autojoin [Kindamoody@Nightstar-qg5daj.tbcn.telia.com] has joined #code |
| 14:18 | | mode/#code [+o Kimo|autojoin] by ChanServ |
| 14:46 | | Kimo|autojoin is now known as Kindamoody |
| 14:54 | | Vornicus [Vorn@Nightstar-8k6f0b.res.spectrum.com] has joined #code |
| 14:54 | | mode/#code [+qo Vornicus Vornicus] by ChanServ |
| 16:24 | | Kindamoody [Kindamoody@Nightstar-qg5daj.tbcn.telia.com] has quit [Ping timeout: 121 seconds] |
| 16:28 | | Kizor [Kizor@Nightstar-nfsqa7.yok.fi] has quit [Ping timeout: 121 seconds] |
| 16:29 | | Vornicus [Vorn@Nightstar-8k6f0b.res.spectrum.com] has quit [Connection closed] |
| 16:29 | | Kizor [Kizor@Nightstar-nfsqa7.yok.fi] has joined #code |
| 17:28 | | Emmy [Emmy@Nightstar-qo29c7.fixed.kpn.net] has joined #code |
| 17:48 | | Kindamoody [Kindamoody@Nightstar-qg5daj.tbcn.telia.com] has joined #code |
| 17:48 | | mode/#code [+o Kindamoody] by ChanServ |
| 18:06 | | Kindamoody [Kindamoody@Nightstar-qg5daj.tbcn.telia.com] has quit [Ping timeout: 121 seconds] |
| 21:24 | | Netsplit over, joins: Reiver |
| 21:24 | | Netsplit Golgafrincham.Nightstar.Net <-> Deepthought.Nightstar.Net quits: NSGuest46897, @celticminstrel, Degi, @ErikMesoy, @[R], craftxbox, @PinkFreud, @JustBob |
| 21:24 | | Netsplit over, joins: craftxbox |
| 21:24 | | Netsplit over, joins: @PinkFreud, NSGuest46897 |
| 21:24 | | JustBob [justbob@ServerAdministrator.Nightstar.Net] has joined #code |
| 21:24 | | mode/#code [+o JustBob] by ChanServ |
| 21:25 | | Netsplit over, joins: ErikMesoy |
| 21:26 | | Netsplit over, joins: [R] |
| 21:26 | | mode/#code [+ao [R] [R]] by ChanServ |
| 21:28 | | celticminstrel [celticminst@Nightstar-0na0fn.cpe.pppoe.ca] has joined #code |
| 21:28 | | mode/#code [+o celticminstrel] by ChanServ |
| 21:30 | | Degi [Degi@Nightstar-k2k0um.pool.telefonica.de] has joined #code |
| 21:56 | | Vornicus [Vorn@Nightstar-8k6f0b.res.spectrum.com] has joined #code |
| 21:56 | | mode/#code [+qo Vornicus Vornicus] by ChanServ |
| 22:05 | | himi [sjjf@Nightstar-o4k.pal.170.103.IP] has quit [Ping timeout: 121 seconds] |
| 22:06 | | himi-cat [sjjf@Nightstar-o4k.pal.170.103.IP] has quit [Ping timeout: 121 seconds] |
| 22:28 | | Kindamoody [Kindamoody@Nightstar-qg5daj.tbcn.telia.com] has joined #code |
| 22:28 | | mode/#code [+o Kindamoody] by ChanServ |
| 22:32 | | Emmy [Emmy@Nightstar-qo29c7.fixed.kpn.net] has quit [Ping timeout: 121 seconds] |
| 22:45 | | Kindamoody [Kindamoody@Nightstar-qg5daj.tbcn.telia.com] has quit [Ping timeout: 121 seconds] |
| 23:18 | | himi [sjjf@Nightstar-1drtbs.anu.edu.au] has joined #code |
| 23:18 | | mode/#code [+o himi] by ChanServ |
| --- Log closed Fri Nov 29 00:00:28 2024 |