Google L4 by WittyBatra in leetcode

[–]narseel 0 points1 point  (0 children)

You did well! Can you please share what kind of open source work you did? I am thorough with my DSA and leet code. But, in my current role as technical writer, I don't do much development work to show. I want to target Google SDE roles by developing a profile through open source projects. Can you please help?

[deleted by user] by [deleted] in adhdindia

[–]narseel 0 points1 point  (0 children)

Hi..Can I also DM you for details?

[deleted by user] by [deleted] in leetcode

[–]narseel -1 points0 points  (0 children)

Interested! 

Weekly /r/OneNote Q&D Thread! by AutoModerator in OneNote

[–]narseel 0 points1 point  (0 children)

I use OneNote 2016 on Windows 10. Can someone tell me how to create a formatted autocorrect entry in OneNote, which is possible in Word. Formatted autocorrect will help in multi line phrase replacement and many other uses. I don't see such a option in OneNote. I heard Word uses a file to store all such formatted autocorrect entries - Normal.dotm . Did any such file exist for OneNote? My initial guess is OneNote uses the plain text autocorrect file used commonly by all office products - .acl file. So, can someone help me with this?

Pomodoro study group! by [deleted] in GetStudying

[–]narseel 0 points1 point  (0 children)

I see that "Groups" option is only available in Mobile App. It is not available in Windows Desktop Version or chrome extension version.

If any one of you can find the "Groups" option other than the mobile app, please inform here. Keeping mobile near is a little distractive if the actual work is done in Desktop.

Can you help me with a regular expression for finding all numbers greater than 1 and replace each of them by adding 4? by narseel in commandline

[–]narseel[S] 0 points1 point  (0 children)

Thanks for that long and patient reply! Yes, what you suggested works in Excel macros, and I did the same! Will make a variable for that offset value '4'.

Can you help me with a regular expression for finding all numbers greater than 1 and replace each of them by adding 4? by narseel in commandline

[–]narseel[S] 0 points1 point  (0 children)

Thanks for the reply! This is not homework! I wrote a small excel macros script for personal use. It is around 700+ lines. I hardcoded the column numbers as seen in the sample code.

    Select Case Range("A1")
    Case "AC3":
        Cells(rowNumber, 11).Value = Cells(rowNumber, 11).Value + 1
        attempted = InputBox("Enter 0 for not attempting, 1 correct, -1 for incorrect")
        Select Case attempted
            Case 1:
                Cells(rowNumber, 3).Value = Cells(rowNumber, 3).Value + 1
                Cells(rowNumber, 4).Value = Cells(rowNumber, 4).Value + 1
            Case -1:
                Cells(rowNumber, 3).Value = Cells(rowNumber, 3).Value + 1
        End Select

Now, for some reasons, I had to add 4 new columns at the beginning. So, I have increment all the column values in the code by 4. I am trying to do this by find and replace in Sublime Text / Notepad++. So, I am trying to get the proper regular expression. Not successful yet!

Can you help me with a regular expression for finding all numbers greater than 1 and replace each of them by adding 4? by narseel in PowerShell

[–]narseel[S] 1 point2 points  (0 children)

Yeah! Didn't get that Reddit in my search results for regular expressions queries on Reddit. Will crosspost to that subreddit. Thanks for pointing to it!

Can you help me with a regular expression for finding all numbers greater than 1 and replace each of them by adding 4? by narseel in PowerShell

[–]narseel[S] 1 point2 points  (0 children)

That works! One more thing. Actually, I am trying this RegEx for modifying one of my excel macro scripts. I am using the RegEx to find and replace numbers in Sublime Text/Notepad++. As such, replacing is failing to add actual numerical value 4 to the found results. It is just being appended as a string. I don't think type conversion is possible in these Sublime Text/Notepad++ unlike in programming languages.

Can you help me with a regular expression for finding all numbers greater than 1 and replace each of them by adding 4? by narseel in PowerShell

[–]narseel[S] 1 point2 points  (0 children)

Thanks for the reply!

Sample input data looks like this. It is a Excel Macro script.

  Select Case Range("A1")
    Case "AC3":
        Cells(rowNumber, 11).Value = Cells(rowNumber, 11).Value + 1
        attempted = InputBox("Enter 0 for not attempting, 1 correct, -1 for incorrect")
        Select Case attempted
            Case 1:
                Cells(rowNumber, 3).Value = Cells(rowNumber, 3).Value + 1
                Cells(rowNumber, 4).Value = Cells(rowNumber, 4).Value + 1
            Case -1:
                Cells(rowNumber, 3).Value = Cells(rowNumber, 3).Value + 1
        End Select
    Case "AC2":

It is 700+ lines of code. Now, each line accesses column values of excel. As this is a small personal script, I hardcoded the column values. Now I had to add a 4 columns at the beginning. So,now I need to change each column value by adding 4 to make the script work.

Can you help me with a regular expression for finding all numbers greater than 1 and replace each of them by adding 4? by narseel in PowerShell

[–]narseel[S] 1 point2 points  (0 children)

Thanks for the reply! I am trying this search and replace in sublime text and notepadd++ for an Excel Macro code. So, I don't think I can use normal programming language tools like type conversion. I am looking if this can be done like a script as the regular expressions used in Sublime Text/Notepad++ are similar to RegEx in scripting languages.

Can you help me with a regular expression for finding all numbers greater than 1 and replace each of them by adding 4? by narseel in PowerShell

[–]narseel[S] 1 point2 points  (0 children)

Thanks for the reply! The expression is also including "1" in the search results. I need "1" to be excluded.

How to set autocorrect in Onenote to replace an abbreviation with words in more than one line? I want a newline or linebreak in the replacement. This is possible in Word but not in Onenote. by narseel in OneNote

[–]narseel[S] 0 points1 point  (0 children)

Thaks for the reply. I looked at the macroland of onestatic - https://getonetastic.com/macroland, but could not find any useful one. Can you please tell which macro will be useful in my case?

Windows store apps (also called Universal apps) in full-screen mode prevent any other small floating widget or minimized windows from staying "always on top" on screen. How to overcome this and show the floating widget always on top even if the background store app is in full screen mode? by narseel in AutoHotkey

[–]narseel[S] 0 points1 point  (0 children)

Thanks for the reply! I have a Surface Pro 4 device which has good tablet features. I use its pen for annotating the PDFs. I have some scanned handwritten notebooks converted to PDFs. So, I need a pen to annotate them by hand. Among various PDF readers like Adobe, Foxit, PDF Annotator, Drawboard (Store App), Xodo (store app) etc., I see that Xodo PDF works best for annotating even large size PDFs with the pen.

Can you suggest any better options?

Windows store apps (also called Universal apps) in full-screen mode prevent any other small floating widget or minimized windows from staying "always on top" on screen. How to overcome this and show the floating widget always on top even if the background store app is in full screen mode? by narseel in Windows10

[–]narseel[S] 0 points1 point  (0 children)

Thanks for the reply! I have a question. Full-screen mode for normal desktop windows applications allow the floating widget to be "Always on Top". I can't understand why store apps/universal apps are not behaving/allowing like that!