Main page: Help searching Wikipedia
How can I get my question answered?
- Select the section of the desk that best fits the general topic of your question (see the navigation column to the right).
- Post your question to only one section, providing a short header that gives the topic of your question.
- Type '~~~~' (that is, four tilde characters) at the end – this signs and dates your contribution so we know who wrote what and when.
- Don't post personal contact information – it will be removed. Any answers will be provided here.
- Please be as specific as possible, and include all relevant context – the usefulness of answers may depend on the context.
- Note:
- We don't answer (and may remove) questions that require medical diagnosis or legal advice.
- We don't answer requests for opinions, predictions or debate.
- We don't do your homework for you, though we'll help you past the stuck point.
- We don't conduct original research or provide a free source of ideas, but we'll help you find information you need.
How do I answer a question?
Main page: Wikipedia:Reference desk/Guidelines
- The best answers address the question directly, and back up facts with wikilinks and links to sources. Do not edit others' comments and do not give any medical or legal advice.
June 14
Sending an email from Gmail to Yahoo
Why don't Yahoo-recipients see the sender's Gmail profile picture, even though Gmail recipients do see it? Can the sender/recipient do something, for the recipient to see it? 147.236.152.145 (talk) 08:55, 14 June 2022 (UTC)
- From Google's documentation: "Your name and profile picture can be viewed by other people who use Google services where your main Google Account profile is shown, including when you communicate or share content." Yahoo is not a Google service. 12.116.29.106 (talk) 11:49, 14 June 2022 (UTC)
- The picture is not included in the email sent by Gmail to Yahoo! Mail (or any other email services), and Google has not given Yahoo! Mail access to its database of Google account profiles. --Lambiam 12:04, 14 June 2022 (UTC)
Split/Explode calculations in SQL
In programming, it is common to split or explode a complex value into multiple values, perform an operation on those values, and recombine them into the original complex format. For example, if I have the value "8,12,4", I can double each number with some pseudocode like: newval=implode(',',explode(',',oldval)*2);. I explode/split the old value by commas, multiply the resulting numbers by 2, and implode/concatenate the updated values with commas. I want to know what search term could be used to find practices like this in SQL. Using the example above, I might have a field with a value like "8,12,4" and I want it to become "16,24,8". I'm not looking to solve this one specific problem. I'm looking for search terms that would lead to examples and explanations of splitting or exploding a varchar into parts, performing an operation on those parts, and then recombining those parts. 12.116.29.106 (talk) 16:19, 14 June 2022 (UTC)
- I searched for "SQL vector multiplication" and found a page where somebody is doing matrix multiplication in SQL. I don't know enough about SQL to be certain that this is useful to you, but anyway the term "vector" (for "complex value") is worth trying. (Come to think of it, wasn't this kind of mathematics, on objects containing multiple values, a significant motivation for the development of relation databases in the first place?) ... I get the impression that you have the specific problem of treating multiple values as one, and packing and unpacking them, which that link probably doesn't address. So I tried "split varchar string", and here's a couple of Stack Overflow questions which may be relevant: [1] [2] - they mention SUBSTR, among other functions. Card Zero (talk) 16:52, 14 June 2022 (UTC)
- I do not know if that term applies within the SQL ecosystem, but across the Python/Matlab/etc. scientific calculation world, that is called "vectorized code" or "array programming". Here’s an exam sheet with easy-to-understand examples. TigraanClick here for my talk page ("private" contact) 17:09, 14 June 2022 (UTC)
- What with the unpacking and packing, this is essentially unfold–map–fold, which is also related to the MapReduce paradigm. Like Tigraan, I don't know if such terminology has gained any currency in the SQL world. --Lambiam 19:11, 14 June 2022 (UTC)
That kind of thing is usually not done in SQL, which traditionally puts one value per cell. Lately there have been some extensions to put JSON or arrays into SQL, but that is pretty nonstandard and something of an antipattern. But it slightly resembles some programming patterns like map-reduce. 2601:648:8202:350:0:0:0:90B2 (talk) 06:55, 16 June 2022 (UTC)
June 16
Questions about use of Whatsapp
I have two questions. 1) How can I transfer whatsapp chat history data to new phone without uploading to Google drive. I tried sending the file of today's date in Whatsapp>Databases from old phone to new phone using Xender and placed it in same location but this method isn't working for some reason. How to do? 2) I want a specific tool for whatsapp. When someone sends me series of messages. I want to selectively mark some of them as read. Something like Mark as done So that next time I read my chat history I know which things are still left. One simplest way of doing this is to use reactions. I can simply use 👍🏻(thumbs up) reaction to do this. But by doing this the sender gets notified which I don't want as it feels weird, if I react to someone's 2 month old message. Is there some tool I can use. -- 2409:4043:209C:B221:3990:F39E:91CC:C03E (talk) 06:29, 16 June 2022 (UTC)
June 17
Word normal.dot styles blow away
I have asked about this problem before and have gotten some advice that I have tried, and that has not solved the problem. I was also advised as to a web site to go to for possibly more knowledgeable help. The problem is that, if Word ends without exiting cleanly, I lose the normal.dotm template, which Word, on restarting, creates from almost nothing. This happens if I lose power, if Word crashes, if Windows crashes, or for any other reason I start Word up anew. I have tried uninstalling and reinstalling Word, and this does not improve the situation. I am running Office 365, or whatever Microsoft calls it, and I should have the latest version, because I have uninstalled and reinstalled. I am running Windows 10 with a Dell Inspiron 3668 with four CPUs that is not eligible for Windows 11.
So if I restart Word, all of my styles are lost. I have them saved in a document and can reload them, but that is a nuisance.
First, does anyone have a proposed explanation and proposed solution, other than reinstalling Office? Second, is there a web site where I might be able to get an answer? Robert McClenon (talk) 14:27, 17 June 2022 (UTC)
- Proposed solution: use LibreOffice! ;-) Martin of Sheffield (talk) 14:59, 17 June 2022 (UTC)
- Well there are several Help forums for Micro$oft Word. And this is one of the most common gripes. I am not aware of a solution apart from reloading them as you are doing. If you find you often lose power you might want to consider investing in an Uninterruptible power supply. The one under my desk has saved my bacon several times. If Word or Windows keeps crashing it might be time for a new computer.--Shantavira|feed me 08:48, 19 June 2022 (UTC)