:strip_icc():strip_exif()/u/821329/crop6817c75ef2272_cropped.jpg?f=community)
"If you lose your left arm your right arm will be left."
"The difference between stupidity and genius is that genius has its limits." - Albert Einstein
"I don't need oxygen, I only need O2."
Heb ik geprobeerd, maar dat werkt niet, want dan kan je niets importeren in Outlook. 
"If you lose your left arm your right arm will be left."
"The difference between stupidity and genius is that genius has its limits." - Albert Einstein
"I don't need oxygen, I only need O2."
/u/246423/crop5979eb9e5c60f_cropped.png?f=community)
Come hear the moon is calling, The witching hour draws near, Hold fast the sacrifice, For now it's the time to die, All hell breaks loose, WITCHING HOUR!
"If you lose your left arm your right arm will be left."
"The difference between stupidity and genius is that genius has its limits." - Albert Einstein
"I don't need oxygen, I only need O2."
Come hear the moon is calling, The witching hour draws near, Hold fast the sacrifice, For now it's the time to die, All hell breaks loose, WITCHING HOUR!
"If you lose your left arm your right arm will be left."
"The difference between stupidity and genius is that genius has its limits." - Albert Einstein
"I don't need oxygen, I only need O2."
:strip_icc():strip_exif()/u/389840/crop5669d82cddd82.jpeg?f=community)
"If you lose your left arm your right arm will be left."
"The difference between stupidity and genius is that genius has its limits." - Albert Einstein
"I don't need oxygen, I only need O2."
Come hear the moon is calling, The witching hour draws near, Hold fast the sacrifice, For now it's the time to die, All hell breaks loose, WITCHING HOUR!
"If you lose your left arm your right arm will be left."
"The difference between stupidity and genius is that genius has its limits." - Albert Einstein
"I don't need oxygen, I only need O2."
Come hear the moon is calling, The witching hour draws near, Hold fast the sacrifice, For now it's the time to die, All hell breaks loose, WITCHING HOUR!
"If you lose your left arm your right arm will be left."
"The difference between stupidity and genius is that genius has its limits." - Albert Einstein
"I don't need oxygen, I only need O2."
Come hear the moon is calling, The witching hour draws near, Hold fast the sacrifice, For now it's the time to die, All hell breaks loose, WITCHING HOUR!
"If you lose your left arm your right arm will be left."
"The difference between stupidity and genius is that genius has its limits." - Albert Einstein
"I don't need oxygen, I only need O2."
Exact wat @T_knoop zegt, zou er dus ongeveer zo uit moeten zien (CSV kan je ook met notepad bewerken):
Come hear the moon is calling, The witching hour draws near, Hold fast the sacrifice, For now it's the time to die, All hell breaks loose, WITCHING HOUR!
Name;Email
"xk@x.nl; x@x.nl; x@hotmail.com;
Zo heb ik het daar?
"xk@x.nl; x@x.nl; x@hotmail.com;
Zo heb ik het daar?
"If you lose your left arm your right arm will be left."
"The difference between stupidity and genius is that genius has its limits." - Albert Einstein
"I don't need oxygen, I only need O2."
/u/34186/crop62e07d174532d_cropped.png?f=community)
Met één aanhalingsteken ga je niet ver komen. Alle strings moeten omsloten zijn door quotes ("). Dus::
Name;Email
"xk@x.nl; x@x.nl; x@hotmail.com;
Zo heb ik het daar?
code:
1
| "xk@x.nl"; "x@x.nl"; "x@hotmail.com"; |
"Technological advancements don't feel fun anymore because of the motivations behind so many of them." Bron
Come hear the moon is calling, The witching hour draws near, Hold fast the sacrifice, For now it's the time to die, All hell breaks loose, WITCHING HOUR!
/u/950699/crop5b029e14204bd_cropped.png?f=community)
"If you lose your left arm your right arm will be left."
"The difference between stupidity and genius is that genius has its limits." - Albert Einstein
"I don't need oxygen, I only need O2."
Come hear the moon is calling, The witching hour draws near, Hold fast the sacrifice, For now it's the time to die, All hell breaks loose, WITCHING HOUR!
:strip_exif()/u/62088/sp_jh2.gif?f=community)
"If you lose your left arm your right arm will be left."
"The difference between stupidity and genius is that genius has its limits." - Albert Einstein
"I don't need oxygen, I only need O2."
/u/423290/crop60af527613c96_cropped.png?f=community)
/u/421081/crop5c9223701b2ad_cropped.png?f=community)
Ehm nee. Excel kan hier prima mee omgaan met opslaan naar csv.
Op dit moment heeft TS deels info in meerdere kolommen (rij 1) staan en deels in 1 kolom (rij 2). Persoonlijk zou ik het altijd netjes in meerdere kolommen opnemen. Maar inderdaad, alles zou in 1 cel kunnen.
Ik vraag me wel af of TS niet beter gewoon die emailadressen en namen had kunnen overtikken dan de vraag te stellen. Volgens mij was het intikken van de 75 stuks veel sneller
If you can see, look. If you can look, observe
"If you lose your left arm your right arm will be left."
"The difference between stupidity and genius is that genius has its limits." - Albert Einstein
"I don't need oxygen, I only need O2."
"If you lose your left arm your right arm will be left."
"The difference between stupidity and genius is that genius has its limits." - Albert Einstein
"I don't need oxygen, I only need O2."
:strip_exif()/u/263111/avatar.gif?f=community){kind=avatar}
Maar... je wilt het dus wél handmatig toevoegen in Excel blijkbaar, maar níet in Outlook?
Waarom in vredesnaam?
"If you lose your left arm your right arm will be left."
"The difference between stupidity and genius is that genius has its limits." - Albert Einstein
"I don't need oxygen, I only need O2."
:strip_exif()/u/8178/hitchhikersguidethemoviesmall.gif?f=community)
"If you lose your left arm your right arm will be left."
"The difference between stupidity and genius is that genius has its limits." - Albert Einstein
"I don't need oxygen, I only need O2."
"If you lose your left arm your right arm will be left."
"The difference between stupidity and genius is that genius has its limits." - Albert Einstein
"I don't need oxygen, I only need O2."
Tja, want jij tovert ongestructureerde tekst naar gestructureerd? (Met een leuk deep learning AI kant ‘t, maar ja, in de tijd dat we dit hier typen, had iedereen anders het al gefixt . )
Als het “ enigszins” gestructureerd is, kun je met een deftige editor (notepad++ bv) en handige search/replace/regex-en, het sneller doen, maar tja, dat is nu kennis
. )Als het “ enigszins” gestructureerd is, kun je met een deftige editor (notepad++ bv) en handige search/replace/regex-en, het sneller doen, maar tja, dat is nu kennis
[ Voor 31% gewijzigd door Tjark op 07-03-2018 17:01 ]
*insert signature here
/u/38159/DirkJan.png?f=community)
:strip_icc():strip_exif()/u/452253/crop6432e4afa5c59_cropped.jpg?f=community)
:strip_icc():strip_exif()/u/21673/crop65674aee06c6d_cropped.jpg?f=community)
:strip_icc():strip_exif()/u/101807/crop56f6f003d7bfa.jpeg?f=community)
FTFY
Van een nieuwe user zou ik zo'n opstelling nog wel door de vingers willen zien, maar deze TS moet beter weten. We gaan niet alles eruit trekken en een eigen inbreng is ook welkom. Zo heeft dit topic geen bestaansrecht.
De oever waar we niet zijn noemen wij de overkant / Die wordt dan deze kant zodra we daar zijn aangeland
Pagina: 1
Dit topic is gesloten.