text – Can Zoom be used to transcribe external audio (i.e. other than meetings recorded with Zoom?)

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.

Formula to Reference an Outside Sheet If Specific Text In Cell Range Is Present It Will Compare Text in Two Ranges and Populate Text

I need a formula to reference an external workbook for to query a cell range for a certain entry to exist, and if that specific text is present, it will cross reference the a cell from a certain column in the same row and check if it is present in a column of the source sheet – if it does, it can populate with “Present”, and if it does not, populates with “Needs Added”.

In these example workbooks, I would like “Example Spreadsheet” Column B to house this formula. The Formulas will reference “Example Spreadsheet 2” cell range $A$2:$A for “Larry’s”, where “Larry’s” is present, it will compare cell range $D$2:$D in “Example Spreadsheet 2” to $C$2:$C in “Example Spreadsheet”. If present in both, it will populate with “Present” and if the store number is missing from $D$2:$D, it will populate with “Needs Added”.

The Links to the Example Spreadsheets are:

How do I combine multiple html files onto one text document so that I can search by keyphrase?

Just for reference, the html files are all scattered and in different folders. I’m also a Mac user, so everything’s being done in Finder. Thanks in advance!

sharepoint online – Wrap text on title and hyperlink columns

I’m trying to import a list from Sharepoint On-Premise to Sharepoint Online. In the old list, the text was wrapped for both the title and the hyperlink column which gave the list an organized and clean look. After the import to Sharepoint Online, the title and hyperlink column are no longer wrapped and it doesn’t seem like I’m able to change it in the column settings. I was trying to use the JSON formatting to fix it but I wasn’t able to get it to work. Is there any way to do this?

Pictures below to show the difference:
enter image description here

enter image description here

javascript – Setear value de un input radio a un input text vacio

Quiero pasar el value de un input radio seleccionado en un modal, a un input text vacio que tengo en un formulario.

Radio del modal:

        <div class="img-user-profile">
            @foreach($files as $image)
                <label class="checkeable">
                    <input type="radio" id="image-profile-radio" name="image-profile" value="{{'images/user-profile/'.$image->getRelativePathname()}}"/>
                    <img src="{{asset('images/user-profile/'.$image->getRelativePathname()) }}">

 <button id="confirm-image-profile" class="btn btn-primary btn-block joinOnlineEventButton">
 Confirm selection

Lo quiero guardar en este campo del formulario del cual se abre el modal.

                <div class="hide">
                    <input type="text" class="input-image-random" name="input-image-random" id="input-image-random" value="">


He probado con estas dos funciones, pero no logro que se quede guardado en el value del input text:

$("#confirm-image-profile").click(function() {
    $("#confirm-image-profile").click(function() {

$("#confirm-image-profile").click(function() {
    let imageProfile = $("input(name='image-profile'):checked").val();
    let imagenProfileForm = imageProfile;
    console.log(imagenProfileForm + ' a')


¿Alguien me puede ayudar a guardar ese valor ahí?

Grammar for ${ a^i b^j: j < 2i text{ and } j ne i } $

For the following language, write grammar independent of the text.

$${a^i b^j: j < 2i text{ and } j ne i } $$

I want a hint to start solving this problem. Where should I start?

microsoft excel – Write variating numbers after specific text

I have a standardized text with different information. I would like Excel to automatically extract that information. The text can be:

Bietet (schriftlich): KP 10.700.000 EUR / Maklerhonorar nicht geklärt

I would like Excel to extract the “schriftlich”, “10.700.000” and “nicht geklärt”
It would always stand like this, and the data I want extracted can vary.

Is it possible?

interaction design – How do I let users know the field can be edited without putting it in text?

I am designing something like a wallet where users can withdraw from it. I’d like to give users the option to withdraw any amount, however, I do not know how to let my users know in a really obvious way that the amount can be edited. Currently, I’m deciding to put a text saying ‘click here for desired amount’ and connecting it via an arrow to the bottom $300.70 for users to know.

Please share with me your thoughts and opinions. Greatly appreciated!
If you do not understand where I am coming from, do leave a comment as well! Thank you :]

enter image description here

encryption – Passwords stored as obfuscated text, not encrypted

First thing I’d do is consider whether the system needs “reversibly encrypted” passwords at all (usually yes if it’s sending them on to some other service rather than just verifying them when a user logs in, sometimes yes if this is required by some important customer but they should have an option to properly hash them as well). Second, since you say “a simple mapping” I assume this isn’t actually using any modern cryptographic cipher primitives (AES, *fish, SALSA20, etc.), so that’s definitely a security bug you can file.

Look up a security contact (email address, etc.). There should be one somewhere on the site. If you can’t find one, try emailing security@company.domain, or just contact their support line and ask for a security contact.

Note that any form of reversible encryption, no matter how up-to-date its ciphers or strong its keys, suffers from a key storage problem: the program needs access to the key, which means anybody who can access the program itself can almost certainly decrypt the data. However, there are still improvements to be made from using real encryption:

  • Real encryption, even with a hardcoded key, will prevent anybody who doesn’t know the key from reversing the encryption if they get access to the DB. It sounds like they currently don’t even meet this – very low – bar.
  • Done correctly, the key should be unique per instance of the app. Getting access to somebody else’s DB shouldn’t reveal anything, even if you know the encryption key used by your own copy/instance of the software.
  • The key should be stored in a location as hard to access as possible. Ideally, it would be stored somewhere not actually extractable (like an HSM), with the app having the ability to request encryption and decryption of arbitrary strings but no other software allowed to access the HSM. At the very least the key needs to be separate from the DB, such that even an attacker with total, unfettered DB access can’t get the key without finding a new vulnerability in some other part of the system.

It sounds like you’re already well aware of why they should be using a slow password hashing function, rather than reversible encryption of any sort. Even if they need encryption for some passwords/API keys (stuff used to access external services, not to authenticate local users), they should use encryption for those secrets only, and use secure password hashing algorithms for user passwords.

If the vendor won’t budge – says that it’s not a security bug, or that they don’t care, or just refuses to respond – give them some time and then (IMO) it’s time to escalate. If possible for you, try to convince your company to threaten to cancel the contract; that’s often the simplest leverage. If you can’t, I would tend to move up to name and shame. Companies are usually way more likely to respond to things when it’s likely to impact their bottom line, and bad publicity can do that. Sites like https://plaintextoffenders.com/, or just reaching out publicly on social media (especially to, or at least mentioning, well-known security figures), can help get the word out.

Obviously that last part isn’t risk-free. There’s probably something in the terms of use about not “reverse engineering” the software, and although I think this level of “cryptanalysis” doesn’t count at all, I am not a lawyer. If you had to bypass any attempted safeguards to keep you out of the DB – entering a username/password of admin/admin might count, though copying a DB connection string out of a plain-text config file on a system you control does not – then that increases the risk they’d think it worthwhile to involve lawyers. A smart company wouldn’t do this – siccing the law on somebody who is trying to responsibly report a security issue is a good way to get the entire security community mad at you, and some of us hold grudges and make product recommendations at big companies (and others are hacktivists) – but a smart company wouldn’t let things get nearly that far to begin with. Before you take any steps beyond just reporting the issue to the vendor, especially if you have any notion of involving your company’s name, you might want to talk to the legal department. However, I am not a lawyer, and this is NOT legal advice.

newbie: Code to show/hide a STATIC TEXT object in Visual C++ MFC app

I ran into a newbie problem with my first VC++ MFC app (actually, I ran into many problems, but RTFM and DuckDuckGo helped to solve them without crying here for help. Except this one!). Bear in mind that I am playing with this as a tutorial for myself, kind of a learn by example project, and I have a few years of Win GUI app programming experience in Deplhi/Lazarus, and now I am attempting to transition into VC++, simply for my own curiosity. While I am also good with C language programming, I have significantly less experience with C++. So the new programming environment and the less-known language together pose as my obstacle.

Here is what I did:
In a recently installed Visual Studio 2019 Community with only the Windows App development in C++ components selected, started a new project, chose C++ MFC App (Build apps with complex user interfaces that run on Windows.). Set application type to Dialog based, turn off all User Interface Features so only Thick frame is checked (unchecked System-menu, unchecked About-box), turn off all Advanced Features so only Common Control Manifest is checked (unck Printing and print preview, unck Activex controls, unck Support Restart Manager), clicked FINISH.
This prepared me an app with a single small main window, OK and Cancel buttons in its lower-right corner, and a STATIC TEXT item in the middle-center reading something like “TODO: add your own items here”. Project name is TutMFC01p.

My goal was to hide that STATIC TEXT when I click one of the buttons, and make it visible again when I click the same button again.
It took me some time to realize that I should not fiddle with the OK and Cancel buttons to add them this functionality, and clicking either of these two buttons also quits my app (hence, no chance to click again). So I placed a new button on the dialog and worked with that instead. Clicking my button while my app was running did absolutely nothing – which was exactly what I wanted.
Double-clicking my button in the Dialog Editor dropped me into Source Editor with a new function autogenerated at the bottom of TutMFC01pDlg.cpp.

void CTutMFC01pDlg::OnBnClickedButton1()
  // TODO: Add your control notification handler code here

Allrighty, so this is where I will add the code of what the button is supposed to do.
It also injected an ON_BN_CLICKED line to the MESSAGE MAP, which now looks like this.

    ON_BN_CLICKED(IDC_BUTTON1, &CTutMFC01pDlg::OnBnClickedButton1)

Allrighty again. So this is the way to tell the system that clicking my button should run the code given in CTutMFC01pDlg::OnBnClickedButton1().
The way I first tried to complete my goal was to alternate the STATIC TEXT object between the TRUE and FALSE value of the VISIBILE property upon the click of my button. A Delphi/Lazarus way of doing it is a single line of code like mainform.mystatictext.visible := not mainform.mystatictext.visible but I was not able to find a way to directly reference the property of an object and change its value with a simple assignment operation. What I found instead is that the way to hide objects is using the ShowWindow() method. I also run into difficulties trying to point this (or any other) method to the STATIC TEXT object, because apparently it has an ID of IDC_STATIC, which, apparently, cannot be referred to, as all static objects have this same ID. To simplify the task ahead, instead of hiding the STATIC TEXT I settled for hiding the button itself, and ended up with this code:

void CTutMFC01pDlg::OnBnClickedButton1()
  // TODO: Add your control notification handler code here
  CWnd* pMyButtonObj = GetDlgItem(IDC_BUTTON1);

This compiles and works very well. Obviously, once the button is pressed and disappears from the window, there is nothing to press again in order to unhide what was hidden. So I tried to move on from this already working code and modify it to act on the STATIC TEXT instead of the button itself. Logic suggested (my logic, anyways) that in order to gain the ability to refer to the ID of the STATIC TEXT, I need to assign a different ID to the STATIC TEXT. Something I can refer to. Something other than the not referrable IDC_STATIC. So I selected the STATIC TEXT object on the Dialog Editor, and in its Property palette I changed the value of the ID property from IDC_STATIC to IDC_STATIC1. This strangely has also changed the NAME property of the object to IDC_STATIC11. Earlier the NAME was IDC_STATIC1. Then in the code of OnBnClickedButton1() I replaced IDC_BUTTON1 with IDC_STATIC1, but that fails to compile complaining that there is no such object. Same happens when tried with IDC_STATIC11.
A little experimenting revealed another phenomena I am unable to explain (or understand). Similarly to how I changed the ID of STATIC TEXT, with my button selected in the Property Editor, I changed its ID from IDC_BUTTON1 to IDC_HideBtn. This also changed its NAME property.
Saved All, rebuilt project, and clicking my button still made it disappear, exactly as it was working before. HOWEVER, the source code of OnBnClickedButton1() and the MESSAGE MAP did not get updated to refer to the new ID, IDC_HideBtn, they still refer to IDC_BUTTON1, same as before.

void CTutMFC01pDlg::OnBnClickedButton1()
    //TODO: Add your control notification handler code here
    CWnd* pMyButtonObj = GetDlgItem(IDC_BUTTON1);

But at this point, IDC_BUTTON1 should be a non-existing ID. Compile should fail. Yet it compiles fine, and it works fine.


  1. Why does the code compile and work with IDC_BUTTON1 in the source while the ID of the button is now IDC_HideBtn?
  2. What can I do to be able to address the STATIC TEXT item as the argument to GetDlgItem() the same way as I could do with IDC_BUTTON1?
  3. If STATIC TEXT items are not supposed to be programmatically changed then what other kind of item could I use instead? In Delphi/Lazarus there is a LABEL object similar to STATIC TEXT, but designed to get different Caption or other values many times while the program runs. In the toolbox of the Dialog Editor I see nothing like that, only STATIC TEXT. Or should I use an Input field instead, to display text in the dialog window?
  4. Is there a way to implement the button click method in the way I initially tried to do the Delphi/Lazarus way? Changing the target object to visible from hidden, and to hidden from visible. Preferrably as a one-liner.
  5. Is there NO WAY to directly refer to the property of an object and change its value with an assignment operation? Or only I did not find it how?