How to align columns in Notepad++

http://tomaslind.net/2016/02/18/how-to-align-columns-in-notepad/

How to align columns in Notepad++

Here’s a short tip on how to align columns (separated by comma or other character) for text files in Notepad++ for increased readability.

When a delimited text file is opened in Notepad++ (or any other text editor), the content may look something like this:

Non aligned columns in Notepad++

Since the columns aren’t aligned, it is quite hard to read the data.

To make the columns aligned (e.g. like in Excel), the plugin TextFX can be used. In Notepad++, select Plugins -> Plugin Manager and check the plugin to install:

TextFX plugin download

Restart Notepad++ when prompted.

Copy the character that is used as a column delimiter (in the example above it is “;”) and select all rows. Next, select TextFX -> TextFX Edit -> Line up multiple lines by (Clipboard Character):

TextFX Line up multiple lines by

Now the result should be much more readable:

Aligned columns in Notepad++

And here is the text that I used in my example:

1 2 3

PK;Name;InvoiceNumber;InvoiceDate;ReferenceNumber;DueDate;Amount 12688564;Tomas Lind;123456;2016-02-17;111;2016-03-17;1000 101;Mr X;88;2016-02-07;0;2016-03-17;100

MS Excel 2016: How to Change Column Headings from Numbers to Letters

https://www.techonthenet.com/excel/questions/column_letters2016.php#:~:text=When%20the%20Excel%20Options%20window,2%2C%203%2C%204).

Question: In Microsoft Excel 2016, my Excel spreadsheet has numbers for both rows and columns. How do I change the column headings back to letters such as A, B, C, D?

Answer: Traditionally, column headings are represented by letters such as A, B, C, D. If your spreadsheet shows the columns as numbers, you can change the headings back to letters with a few easy steps.

In the example below, the column headings are numbered 1, 2, 3, 4 instead of the traditional A, B, C, D values that you normally see in Excel. When the column headings are numeric values, R1C1 reference style is being displayed in the spreadsheet.

To change the column headings to letters, select the File tab in the toolbar at the top of the screen and then click on Options at the bottom of the menu.

When the Excel Options window appears, click on the Formulas option on the left. Then uncheck the option called "R1C1 reference style" and click on the OK button.

Now when you return to your spreadsheet, the column headings should be letters (A, B, C, D) instead of numbers (1, 2, 3, 4).

How can I view a "pipe delimited" Excel file in a more readable format?

https://helpdesk.iconstituent.com/hc/en-us/articles/202964054-How-can-I-view-a-pipe-delimited-Excel-file-in-a-more-readable-format-


When you export contact data and survey data from the Gateway eNewsletter and Website systems, the files will be delivered in a "pipe delimited" format. This means that the various columns are separated by a pipe character: |

You can parse the Excel file into a more readable format by following the instructions below.

• Highlight column A by clicking on the column header.
• Go to the "Data" tab at the top of the Excel document.
• Click the "Text to Columns" button.

• Select the "Delimited" option and press "Next."

• Uncheck every checkbox except for the "Other" option. In the textbox, type in the pipe character: |
• This character can be found by holding the Shift key on your keyboard and pressing the \ key.
• Click the "Finish" button.

• On the "Do you want to replace the contents of the destination cells" window, press "OK."

If you'd like to change your download preferences so that your files will already display correctly in Excel, see our article How do I manage and download lists?

Can't execute jar- file: “no main manifest attribute”

https://stackoverflow.com/questions/9689793/cant-execute-jar-file-no-main-manifest-attribute

That is because Java cannot find the Main attribute in the MANIFEST.MF file. The Main attribute is necessary to tell java which class it should use as the application's entry point. Inside the jar file, the MANIFEST.MF file is located in META-INF folder. Wondering how you could look at what's inside a jar file? Open the jar file with WinRAR.

The main attribute inside the MANIFEST.MF looks like this:

Main-Class: <packagename>.<classname>

You get this "no main manifest attribute" error when this line is missing from the MANIFEST.MF file.

It's really a huge mess to specify this attribute inside the MANIFEST.MF file.

Update: I just found a really neat way to specify the Application's entry point in eclipse. When you say Export,

Select Jar and next 

[ give it a name in the next window ] and next

and next again

and you'll see " Select the class of the application entry point".

Just pick a class and Eclipse will automatically build a cool MANIFEST.MF for you.

Solution for "Black Screen" Display Capture even after performing the steps on OBS forum

https://obsproject.com/forum/threads/solution-for-black-screen-display-capture-even-after-performing-the-steps-on-obs-forum.112109/

Solution for "Black Screen" Display Capture even after performing the steps on OBS forum

I have an Intel Integrated graphics card and an NVIDIA GeForce GTX1050Ti in my Laptop and Somehow OBS didn't want to use Intel even if I set the option in NVIDIA settings panel. So, after a bit of searching on the Internet, I found this blog. And then I changed the settings of Windows to force OBS to use the integrated graphics instead of NVIDIA. And It worked out perfectly!

Here are the steps to perform the solution:
1. Open Windows settings
2. Go to system > display
3. scroll all the way to the bottom
4. open the "Graphics settings"
5. click on browse
6. select the OBS executable file (Default location: C:\Program Files\obs-studio\bin\64bit\obs64.exe)
7. after adding it, click on its name, click on options
8. select Power Saving under which your integrated card's name will be
9. save it and restart OBS