Ali Imtiaz aimtiaz11

Using Arrays and Sorting (removing blank rows) to combine multiple worksheets into one.

=sort({'Feb24 - Data'!A2:G;'Mar24 - Data'!A2:G;'Apr24 - Data'!A2:G;'May24 - Data'!A2:G;'Jun24 - Data'!A2:G})

Source: This awesome video: https://www.youtube.com/watch?v=CVkyfGUSHeg&t=288s

Switching Java using update-alternatives

Registering new java version

For example registering GraalVM to update-alternatives.

sudo update-alternatives --install /usr/bin/java java /usr/lib/jvm/graalvm-jdk-21.0.4+8.1/bin/java 1
sudo update-alternatives --install /usr/bin/javac javac /usr/lib/jvm/graalvm-jdk-21.0.4+8.1/bin/javac 1

Decoding a JWT Payload with your Shell (bash, zsh...)

Add this to your .profile, .bashrc, .zshrc...

decode_base64_url() {
  local len=$((${#1} % 4))
  local result="$1"
  if [ $len -eq 2 ]; then result="$1"'=='
  elif [ $len -eq 3 ]; then result="$1"'=' 
 fi

	package com.company.controller;

	import com.company.model.SuccessResponseModel;
	import io.jsonwebtoken.Jwts;
	import io.jsonwebtoken.security.Keys;
	import org.springframework.http.ResponseEntity;
	import org.springframework.web.bind.annotation.GetMapping;
	import org.springframework.web.bind.annotation.RequestMapping;
	import org.springframework.web.bind.annotation.RestController;
	import reactor.core.publisher.Mono;

	# Define the input and output file paths
	# UPDATE this accordingly
	input_file_path = 'raw-statement-data.txt'
	output_file_path = 'csv-statement-data.csv'




	def parse_transaction_line(line):
	# Split the line into components - UPDATE this based on your line setup

	#!/bin/bash

	# Define a list of hostnames
	HOSTS=(
	"google.com:443"
	"amazon.com:443"

	)

	# Iterate through the list of hostnames

	set tabstop=2
	set autoindent
	set nu
	syntax on
	set ignorecase

	### DO A DRY RUN AND VERIFY BY COMMENTING OUT LINE 29 BEFORE UNCOMMENTING AND DOING PROPER RUN
	### LINE TO COMMENT FOR DRY RUN: --> Rename-Item -Path $item.FullName -NewName $newName
	###
	## LICENSE MIT


	# Define the root directory where you want to rename occurrences of the word

	# IMPORTANT: CAREFULLY SET THIS. Otherwise it can have unintended consequences!!!
	$rootDirectory = "C:\Users\123\git-repos\my-git-project"

	/**
	* Usage: groovy compare-list.groovy first.txt second.txt
	**/

	def sourceList = []

	new File( args[0] ).eachLine { line ->
	sourceList << line.trim()
	}