Jump to content


Welcome to Autoshite

Welcome to Autoshite, like most online communities you must register to view or post in our community, but don't worry this is a simple free process that requires minimal information for you to signup. Be apart of Autoshite by signing in or creating an account.
  • Start new topics and reply to others
  • Subscribe to topics and forums to get automatic updates
  • Get your own profile and make new friends
  • Customize your experience here
Guest Message by DevFuse
 

Photo

What makes you grin? Antidote to grumpy thread


  • Please log in to reply
48924 replies to this topic

#46921 ONLINE   Exiled_Tat_Gatherer

Exiled_Tat_Gatherer

    Fly in the ointment

  • Full Members
  • 792 posts
  • 21 thanks
  • Country : Country Flag

Posted 16 May 2018 - 10:36 AM

Import it into Excel...... set delimiter and bosh.

On a 'couldn't get the phone out fast enough' moment. A gen-yew-whine Bugatti Veyron just trundled past. Surprisingly quieter than I'd have thought....... but great to see it being used on a normal road by some guy who obviously is winning at something. Kids at lights were going mental so he blapped it a bit...... my bits fizzed
  • eddyramrod, purplebargeken, Tickman and 2 others like this

#46922 ONLINE   SiC

SiC

    Rank: Isuzu Florian

  • Full Members
  • 8,438 posts
  • 82 thanks
  • LocationBristol
  • Country : Country Flag

Posted 16 May 2018 - 12:35 PM

I have a massive file to copy and paste into another. It’s a list of about a quarter of a million phone numbers!

The file isn’t on excel so I can’t just select and copy the column, it’s on notepad for some reason (some people think it is cutting edge, Ho hum) so I need to sit here holding shift and page up. For a long time.

Got bored with that so in true autoshite fashion I came up with a cheap engineering fix. One bolt on the shift key, another on the page up key, and a phone resting on each to maintain the pressure. I can now sit and watch The Protectors instead!


Ctrl+Shift+Home?
Oldies: 1972 Austin 1100 2dr - Project Rust bucket, 1974 MGB GT - A stereotypical classic car.
Moderns: 2008 Audi TT - Utterly boring but very compentent, 2010 Aldi A4 - Owned to placate the wife on my crap buying.

#46923 OFFLINE   Parky

Parky

    I don't watch much Television

  • Full Members
  • 5,542 posts
  • 67 thanks
  • LocationBut I hear Breaking Bad is very good
  • Country : Country Flag

Posted 16 May 2018 - 01:02 PM

Tried all that, problem is the file is too big so am having to extract 10% at a time onto excel.

Painful. Nearly done though

#46924 OFFLINE   beko1987

beko1987

    Reliable Renault

  • Full Members
  • 14,078 posts
  • 45 thanks
  • LocationThame, Oxon
  • Country : Country Flag

Posted 16 May 2018 - 01:58 PM

Notepad++ might play a bit nicer with it?


  • Stanky and SiC like this
2001 Gooner2 Ph1 1.9Dci Expression (His)
2008 orl Vauxhalls r Shit Zafira 1.8 SRI 140 (Hers)

#46925 ONLINE   loserone

loserone

    Leaf blower

  • Full Members
  • 2,218 posts
  • 31 thanks
  • Locationbehind the tree
  • Country : Country Flag

Posted 16 May 2018 - 03:12 PM

Rename it .csv and open directly in excel, then save as a spreadsheet?
  • beko1987 likes this

405 with no head, Leaf, 206 GTI with a knackered axle, Legacy H6 Spec B.  Half a.. something. It's japanese and silver, but I don't remember it.
Moaty's cat's back, Zak.


#46926 OFFLINE   Bobthebeard

Bobthebeard

    Bobthebeard

  • Full Members
  • 4,691 posts
  • 8 thanks
  • LocationDoing a U turn where possible.
  • Country : Country Flag

Posted 16 May 2018 - 03:39 PM

Using the 1993 Rhonda 416 as a daily since starting my new job last week.
Hard to actually put into words, but using the car properly as a daily work car rather than just as a 'hobby car' is liberating and refreshing. Light, agile and eager as a puppy. It has everything it needs and nothing it doesn't!
Great visibility due to the large areas of glass, easy to drive and park, large boot for tools etc, key opens doors and locks them again without plips and battery worries, incredibly easy to drive due to aforementioned lightness and lack of the physical size and bulk of modern cars.
Am left wondering if progress has been made at all in the overall useability of cars since the 1990's.
Safety? Possibly, but anything else is a "maybe" IMHO.
Even actually winding down the windows manually isn't actually that difficult.

I know what I am trying to say...
  • STUNO, privatewire, eddyramrod and 5 others like this
Nervously prodding at rust since 1978

1979 Triumph Dolomite 1850 HL Auto
1991 Oldsmobile Cutlass Supreme 3.1 V6
2001 Rover 75 2.5 KV6 Connoisseur
2001 Saab 9-3 2.0t Auto Convertible
2002 Saab 9-5 2.3t Auto Estate
2003 Mazda MX-5

#46927 ONLINE   Cavcraft

Cavcraft

    Rank: Glasses, bottles, bottles filter tips. John Player Special

  • Staff
  • 39,503 posts
  • 161 thanks
  • LocationAudi wanker
  • Country : Country Flag

Posted 16 May 2018 - 03:42 PM

Shouldn't really laugh as it must be shit to happen, but I did LOL a bit at this earlier on the way to my lad's house...

 

 

 32644690_1829144854048129_10597764586641


  • wuvvum, Lacquer Peel, mrbenn and 4 others like this
"As for actually admitting to liking Corsas on a public forum: you're a bollock-brained, biscuit-eating, faux-northern, bastardy, bollocky, wank-brain"

#46928 OFFLINE   anonymous user

anonymous user

    Rank: Renault 16

  • Full Members
  • 4,692 posts
  • 7 thanks
  • LocationAbject Poverty
  • Country : Country Flag

Posted 16 May 2018 - 03:52 PM

A former colleague was once overtaken,in his Volvo Amazon, by his powerboat on its trailer, before it did similar on Cowbridge Road in Cardiff. The hitch part of the trailer had taken too many dunkings in salt water and rusted through
  • Lacquer Peel likes this

#46929 ONLINE   Saabnut

Saabnut

    Rank: Austin Maxi

  • Full Members
  • 424 posts
  • 22 thanks
  • LocationAberdeenshire
  • Country : Country Flag

Posted 16 May 2018 - 04:27 PM

Not a good day for the boat owner, that looks like the original Ski Nautique USA built trailer which are not legal on UK roads. Part of that is they usually have a 2inch hitch rather than 50mm which could explain why it came off....


  • Cavcraft, D Spares & Tyres and SiC like this

#46930 ONLINE   Hooli

Hooli

  • Full Members
  • 11,210 posts
  • 129 thanks
  • LocationNr Doncaster
  • Country : Country Flag

Posted 16 May 2018 - 04:30 PM

Shouldn't really laugh as it must be shit to happen, but I did LOL a bit at this earlier on the way to my lad's house...

 

 

 https://scontent-lht6-1.xx.fbcdn.net/v/t...

 

something something hedgefund something


  • DeeJay, mrbenn and Cavcraft like this

#46931 OFFLINE   PhilA

PhilA

    Rank: Citroen Ami

  • Full Members
  • 1,909 posts
  • 12 thanks
  • LocationLarose, Louisiana
  • Country : Country Flag

Posted 16 May 2018 - 05:24 PM

Not a good day for the boat owner, that looks like the original Ski Nautique USA built trailer which are not legal on UK roads. Part of that is they usually have a 2inch hitch rather than 50mm which could explain why it came off....

What's the other part of the reason for them being illegal to use in the UK? I'm curious.

Phil
I'm a Byte Wizard. I've been told so.
131372.png

#46932 ONLINE   somewhatfoolish

somewhatfoolish

    Deputy Vice-Pomfrite of the Titicacan Legation

  • Full Members
  • 1,616 posts
  • 23 thanks
  • LocationArgyll&Buteshire
  • Country : Country Flag

Posted 16 May 2018 - 05:30 PM

Septic trailers sometimes have electric brakes which are verboten in the UK for reasons beyond logic, possibly also the requirement for auto-reverse brakes. If you swap the hitch to a 50mm one it will work, be safe and 99% of trafpol will ignore you if you behave and your towcar isn't a moving violation.


  • Saabnut likes this

post-9424-0-06631200-1530529320.jpg


#46933 OFFLINE   Tayne

Tayne

    Rank: Talbot Tagora

  • Full Members
  • 12,528 posts
  • 125 thanks
  • LocationThe Granite City of Aberdeen
  • Country : Country Flag

Posted 16 May 2018 - 05:59 PM

I have a massive file to copy and paste into another. It’s a list of about a quarter of a million phone numbers!
The file isn’t on excel so I can’t just select and copy the column, it’s on notepad for some reason (some people think it is cutting edge, Ho hum) so I need to sit here holding shift and page up. For a long time.
Got bored with that so in true autoshite fashion I came up with a cheap engineering fix. One bolt on the shift key, another on the page up key, and a phone resting on each to maintain the pressure. I can now sit and watch The Protectors instead!



A Quarter of a million phone numbers!

Are you involved in some sort of junk marketing scam to defraud pensioners with fake double glazing?
  • beko1987 and somewhatfoolish like this

It always amuses me that e46s vie with the PT Cruiser as the car that's too shit for Autoshite, 

 

 


#46934 ONLINE   Kiltox

Kiltox

    Rank: Lancia Gamma

  • Full Members
  • 7,226 posts
  • 56 thanks

Posted 16 May 2018 - 06:00 PM

A Quarter of a million phone numbers!

Are you involved in some sort of theshadow/Cavcraft marketing scam to defraud pensioners by buying their Vauxhalls for £2.50?


  • DeeJay, beko1987, somewhatfoolish and 1 other like this
2017 17 Dacia Duster 1.6 Access
2016 65 Citroen Relay 2.2 L2H1
2007 07 Fiat Panda 100HP
2002 02 Porsche Boxster S

#46935 OFFLINE   Supernaut

Supernaut

    **LAYER 8 ERROR**

  • Full Members
  • 5,678 posts
  • 13 thanks
  • LocationScreaming into the abyss.
  • Country : Country Flag

Posted 16 May 2018 - 06:03 PM

A Quarter of a million phone numbers!

Are you involved in some sort of junk marketing scam to defraud pensioners with fake double glazing?


No, he tries to sell them new bathrooms.








*hears a BMW 330 roar into his street, followed by footsteps up the garden path, promptly gets punched*
  • HarmonicCheeseburger likes this

#46936 ONLINE   Mr A Lawrence

Mr A Lawrence

    Rank: BL Wedge

  • Full Members
  • 981 posts
  • 6 thanks
  • LocationNearly there
  • Country : Country Flag

Posted 16 May 2018 - 06:05 PM

Had my mondeo on eBay for the last 5 days.

 

One guy contacted me to view and said he was very keen but then baulked as he couldn't insure it for his lad so no go.

 

Last night a woman came to view, brought her brother mechanic to check it over and took it round the block. 

 

Had it up for £1250.

 

Haggling went like this...

 

Her, I like it, would you take a grand for it?

 

Me, no, I can't take that big a hit on it. (Nearly said £1100)

 

Her, OK  £1250 it is. 

 

Ebay has redeemed it's self!!


  • myglaren, purplebargeken, dome and 3 others like this
**the artist formerly known as Andy the tyre man**

#46937 OFFLINE   PhilA

PhilA

    Rank: Citroen Ami

  • Full Members
  • 1,909 posts
  • 12 thanks
  • LocationLarose, Louisiana
  • Country : Country Flag

Posted 16 May 2018 - 06:07 PM

Septic trailers sometimes have electric brakes which are verboten in the UK for reasons beyond logic, possibly also the requirement for auto-reverse brakes. If you swap the hitch to a 50mm one it will work, be safe and 99% of trafpol will ignore you if you behave and your towcar isn't a moving violation.


How quaint.

Phil
I'm a Byte Wizard. I've been told so.
131372.png

#46938 OFFLINE   Tayne

Tayne

    Rank: Talbot Tagora

  • Full Members
  • 12,528 posts
  • 125 thanks
  • LocationThe Granite City of Aberdeen
  • Country : Country Flag

Posted 16 May 2018 - 06:18 PM

No, he tries to sell them new bathrooms.*hears a BMW 330 roar into his street, followed by footsteps up the garden path, promptly gets punched*



A. You can’t hear your own doorbell, you wouldn’t hear my car.
B. Seventy percent of custom by recommendation.
  • somewhatfoolish, Kiltox, Tickman and 1 other like this

It always amuses me that e46s vie with the PT Cruiser as the car that's too shit for Autoshite, 

 

 


#46939 OFFLINE   andy18s

andy18s

    Rank: Renault 16

  • Full Members
  • 3,363 posts
  • 10 thanks
  • Country : Country Flag

Posted 16 May 2018 - 06:23 PM

I have a massive file to copy and paste into another. It’s a list of about a quarter of a million phone numbers!


Is it the AS members list of signed up autobots?
Soobaaarooo Legacy for the awd fun
XT600z Tenere for the off road fun
Happy trails....

#46940 OFFLINE   anonymous user

anonymous user

    Rank: Renault 16

  • Full Members
  • 4,692 posts
  • 7 thanks
  • LocationAbject Poverty
  • Country : Country Flag

Posted 16 May 2018 - 06:32 PM

I have a massive file to copy and paste into another. It’s a list of about a quarter of a million phone numbers!

The file isn’t on excel so I can’t just select and copy the column, it’s on notepad for some reason (some people think it is cutting edge, Ho hum) so I need to sit here holding shift and page up. For a long time.

Got bored with that so in true autoshite fashion I came up with a cheap engineering fix. One bolt on the shift key, another on the page up key, and a phone resting on each to maintain the pressure. I can now sit and watch The Protectors instead!

Why did you not use the nodding bird? It worked so well for Homer Simpson .

You aren't working at GCHQ by any chance, are you?
giphy.gif
  • Parky, somewhatfoolish and HarmonicCheeseburger like this

#46941 OFFLINE   richardmorris

richardmorris

    Rank: Lancia Gamma

  • Full Members
  • 6,392 posts
  • 21 thanks
  • LocationUK
  • Country : Country Flag

Posted 16 May 2018 - 07:56 PM

I may be in this month’s practical classics.

Attached Images

  • 00A0D847-7DE0-469B-BAD7-1E22E1E4C522.jpeg

  • myglaren, The Moog, cort1977 and 3 others like this
  • Mercedes E320 coupé
  • Fiat X1/9
  • Citroën 2CV6

#46942 ONLINE   SiC

SiC

    Rank: Isuzu Florian

  • Full Members
  • 8,438 posts
  • 82 thanks
  • LocationBristol
  • Country : Country Flag

Posted 16 May 2018 - 07:59 PM

That is some JPEG artificating in that picture! It's like being back on the internet in 2001, while on freeserve dialup.
  • LightBulbFun likes this
Oldies: 1972 Austin 1100 2dr - Project Rust bucket, 1974 MGB GT - A stereotypical classic car.
Moderns: 2008 Audi TT - Utterly boring but very compentent, 2010 Aldi A4 - Owned to placate the wife on my crap buying.

#46943 OFFLINE   Tayne

Tayne

    Rank: Talbot Tagora

  • Full Members
  • 12,528 posts
  • 125 thanks
  • LocationThe Granite City of Aberdeen
  • Country : Country Flag

Posted 16 May 2018 - 08:15 PM

Dollywobbler is looking a bit rough these days...

AFA13570-A255-4C53-9992-0122C4DBACAE.jpeg
  • wuvvum, blakey79, myglaren and 10 others like this

It always amuses me that e46s vie with the PT Cruiser as the car that's too shit for Autoshite, 

 

 


#46944 OFFLINE   richardmorris

richardmorris

    Rank: Lancia Gamma

  • Full Members
  • 6,392 posts
  • 21 thanks
  • LocationUK
  • Country : Country Flag

Posted 16 May 2018 - 08:26 PM

Dollywobbler is looking a bit rough these days...
attachicon.gifAFA13570-A255-4C53-9992-0122C4DBACAE.jpeg

That’s my friend Ragnar! A lovely chap ( these days).

Attached Images

  • A4EE017B-9424-4106-8463-5C0799567DD5.jpeg

  • Mercedes E320 coupé
  • Fiat X1/9
  • Citroën 2CV6

#46945 OFFLINE   wuvvum

wuvvum

    Rank: Talbot Tagora

  • Full Members
  • 12,071 posts
  • 29 thanks

Posted 16 May 2018 - 09:38 PM

On a 'couldn't get the phone out fast enough' moment. A gen-yew-whine Bugatti Veyron just trundled past. Surprisingly quieter than I'd have thought....... but great to see it being used on a normal road by some guy who obviously is winning at something. Kids at lights were going mental so he blapped it a bit...... my bits fizzed

Only time I've ever seen a Veyron on the road was about 9 years ago in a particularly wealthy part of Surrey.  It was waiting at a set of lights on a NSL dual carriageway.  Behind it was a late '80s Porsche 91, and behind that was me in a 1983 Renault 5 TL.

 

Lights went green, all three of us nailed it, and I was honestly closer to staying with the 911 in my 1108cc Renault than he was to keeping up with the Bugatti.  Extraordinary machine.


  • cobblers, catsinthewelder, RobT and 1 other like this

#46946 OFFLINE   richardmorris

richardmorris

    Rank: Lancia Gamma

  • Full Members
  • 6,392 posts
  • 21 thanks
  • LocationUK
  • Country : Country Flag

Posted 16 May 2018 - 09:45 PM

And from p eye today...

Attached Images

  • 86DEC2C4-3FF2-48EC-AA00-2155628366CC.jpeg

  • wuvvum, STUNO, RobT and 10 others like this
  • Mercedes E320 coupé
  • Fiat X1/9
  • Citroën 2CV6

#46947 ONLINE   Hooli

Hooli

  • Full Members
  • 11,210 posts
  • 129 thanks
  • LocationNr Doncaster
  • Country : Country Flag

Posted 16 May 2018 - 10:12 PM

Indian House.jpg


  • wuvvum, Parky, beko1987 and 7 others like this

#46948 OFFLINE   anonymous user

anonymous user

    Rank: Renault 16

  • Full Members
  • 4,692 posts
  • 7 thanks
  • LocationAbject Poverty
  • Country : Country Flag

Posted 16 May 2018 - 10:29 PM

So I did, she's called Broadband Internet Connection
  • face likes this

#46949 OFFLINE   Parky

Parky

    I don't watch much Television

  • Full Members
  • 5,542 posts
  • 67 thanks
  • LocationBut I hear Breaking Bad is very good
  • Country : Country Flag

Posted 17 May 2018 - 06:56 AM

A Quarter of a million phone numbers!
Are you involved in some sort of junk marketing scam to defraud pensioners with fake double glazing?

Nope, this is the GDPR in full effect. I have a list of 1400 financial advisers to contact but have to make sure none of them are registered with the corporate telephone preference service before I call.

Of course the format we use for our numbers is different to the preference service file so an auto dedupe won’t work. FFS! I am altering our files to match theirs for future automatic checking (the pref service list changes every month)

It’s not difficult, just sooooo much data on screen. And it’s not a quarter of a million, it’s over two million as I found more files yesterday afternoon. Excel doesn’t seem to be able to cope with that many lines of code so i have had to spread the file over four worksheets. It is very slow and likes falling over!

#46950 OFFLINE   wuvvum

wuvvum

    Rank: Talbot Tagora

  • Full Members
  • 12,071 posts
  • 29 thanks

Posted 17 May 2018 - 07:28 AM

That’s my friend Ragnar! A lovely chap ( these days).

"These days"?  Why, did he use to rape, pillage and drink apple brandy from the skulls of his enemies?


  • purplebargeken, richardmorris and AlabamaShrimp like this




3 user(s) are reading this topic

2 members, 1 guests, 0 anonymous users


    Saabnut, stonedagain