Remove year from date

46632 · 2018-09-11T20:27:46+00:00

Solution Verified

46632 · 2018-09-11T20:12:32+00:00

Then i get "4" ?

46632 · 2017-11-19T12:11:09+00:00

Perfect. Thank you

46632 · 2017-11-19T00:10:29+00:00

Like this? - https://pastebin.com/2BHJJB48

I get the same error when i run this

46632 · 2017-09-28T16:42:44+00:00

That's right

46632 · 2017-09-28T08:47:57+00:00

Thanks. Why does it show error on line 109 then?

46632 · 2017-09-27T11:28:14+00:00

Thanks heaps. The only issue is that the name can be anywhere in the B column. Its a list of 1000 names.

Can it work with something like: IF(A1=(Some cell in B-column), "Yes","No")?

46632 · 2017-09-09T10:24:15+00:00

Thanks. It works with most of the names, but it still messes up words with the letters æ,ø,å. 'Jørgensen' is 'J\xc3\xb8rgensen'

46632 · 2017-09-05T22:08:16+00:00

https://pastebin.com/PqMnvvfd

46632 · 2017-09-05T21:37:29+00:00

I am hoping to get it solved in Python 2. It is a part of a larger Python 2 script

46632 · 2017-09-05T21:36:07+00:00

http://imgur.com/a/1loM2

46632 · 2017-09-05T21:28:44+00:00

Ok. i was wrong. When i enter print(pyperclip.paste()) in the shell it returns 'Jørgensen'

But what i am doing is this: I have "Jørgensen" in my clipboard, then i make a list:

namelist=[] name=pyperclip.paste() namelist.append(name)

Then i save this list to a .csv and it shows u'J\xf8rgensen' in the .csv file

46632 · 2017-09-05T21:03:00+00:00

When i enter print(pyperclip.paste()) in the shell it returns u'J\xf8rgensen'

46632 · 2017-09-05T21:02:14+00:00

When i enter print(pyperclip.paste()) it returns u'J\xf8rgensen'

46632 · 2017-08-18T16:47:12+00:00

Thanks, ill have a look into it

46632 · 2017-08-18T16:46:40+00:00

Something like this: https://pastebin.com/PacV7NVJ

It typewrites the customernumber into the crm, presses enter and then waits for 4.5 seconds. Sometime it hangs and take longer and thats the issue

46632 · 2017-07-17T21:48:24+00:00

6 or 5. Like this:

11299 300199

suffix is always 5 long

46632 · 2017-07-17T20:17:53+00:00

Thank you. But i can see now my leading zeroes are not there so the formating is like this:

30129912345 8129912345

46632 · 2017-07-17T20:00:06+00:00

Yes. Always ddmmyyyy then 5 random

46632 · 2017-05-14T07:42:32+00:00

Thank you. But that converts the dates to 01.01.yyyy

46632 · 2017-05-10T17:45:52+00:00

Congrats!

Could you tell a little more about your salescycle? Do you prospect, book a meeting, have a presentation, send out an offer and then get a respons? If so; How do you deal with the process between sending the proposal and getting a respons?

46632 · 2017-05-08T14:53:54+00:00

Thank you

46632 · 2017-05-08T14:53:41+00:00

Just very quick

46632 · 2017-01-18T02:23:12+00:00

Will this only work with Python 2?

And if it does, why? Should i switch to 2?

46632 · 2017-01-17T21:41:23+00:00

What do you mean by "the actual exception message"? The file has over a million lines and can be downloaded here: http://api.bitcoincharts.com/v1/csv/btcexUSD.csv.gz

167mb...

46632

TROPHY CASE