palash kulshreshtha palashkulsh
🍓
palashkulsh
/ xml attributes to elements
Created
October 1, 2020 20:38
convert xml attributes to elements
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| http://xsltfiddle.liberty-development.net/jyH9rLX |
palashkulsh
/ find and rename folders and sub folders
Created
November 28, 2020 09:46
rename folders and subfolders using find and rename
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| find . -maxdepth 2 -type d -exec rename 's/\/([1-9]\.)/\/0$1/g' {}/ \; | |
| # it prepends zero in folder names |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ffmpeg -i input.mkv -filter_complex "[0:v]setpts=<1/x>*PTS[v];[0:a]atempo=<x>[a]" -map "[v]" -map "[a]" output.mkv | |
| eg. | |
| ffmpeg -i input.mkv -filter_complex "[0:v]setpts=1/2*PTS[v];[0:a]atempo=2[a]" -map "[v]" -map "[a]" output.mkv | |
palashkulsh
/ gist:a2b8cf33bd5629bb432aa08df2164bf7
Created
February 4, 2022 11:19
jira manipulation
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| jira jql epictask -j 1 | jq '.[] | "\(.key),\(.fields.summary),\(.fields.created),\(.fields.updated)"' |
palashkulsh
/ jq without cross product
Created
May 9, 2022 15:30
extracting from jq without creating cross product
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| https://stackoverflow.com/questions/69973010/how-do-i-avoid-creating-a-cross-product-when-extracting-multiple-sub-elements-fr | |
| cat /tmp/jira.txt | jq '.[] | {key} + (.changelog.histories[] | {created} + (.items[] | {field,fromString,toString})) | select (.field=="status")' |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [{pincode:1,value:1},{pincode:2,value:2}] | |
| to | |
| {1:{pincode:1,value:1},2:{pincode:2,value:2}} | |
| jq '.| map({(.pincode|tostring): .}) | add' IN.json > pincode_wise.json |
palashkulsh
/ org2png
Last active
September 4, 2022 20:26
org file to plantuml mindmap or work break down structure wbs diagram creator
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| #identify is part of imagemagick suite | |
| echo "@startmindmap" > /tmp/.org2file.uml | |
| cat $1 >> /tmp/.org2file.uml | |
| echo "@endmindmap" >> /tmp/.org2file.uml | |
| #if -DPLANTUML_LIMIT_SIZE=18192 is not provided then image gets cropped off | |
| java -jar /home/palashkulshreshtha/bin/plantuml.jar -DPLANTUML_LIMIT_SIZE=18192 -o /tmp/ /tmp/.org2file.uml |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| aws ec2 describe-snapshots --filters Name=tag:Techteam,Values=mall-cart | jq '.Snapshots[] | "\(.SnapshotId),\(.VolumeId),\(.StartTime),\(.VolumeSize),\(.Tags[] | select(.Key=="Hostname") | .Value),\(.Description)"' |
palashkulsh
/ excel option generator
Created
November 20, 2022 14:27
generate excel worksheet with merged cell for each option
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import xlsxwriter | |
| from functools import reduce | |
| # Create an new Excel file and add a worksheet. | |
| workbook = xlsxwriter.Workbook('merge1.xlsx') | |
| worksheet = workbook.add_worksheet() | |
| # Create a format to use in the merged range. | |
| merge_format = workbook.add_format({ |
palashkulsh
/ gist:2d4321bc1d82211b2c9e9e065d974c74
Created
January 30, 2023 15:18
excel complex formula
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| If you want to find last value of the column | |
| K1 is start of upper header, U6 is end of current row | |
| we want to find header of last non empty column in a row (for K to U columns) | |
| =ifna(index(filter($K$1:U6,not(ISBLANK(K6:U6))),1,counta(K6:U6)),"TBD") | |
| This selects subset of non empty cells from K1 to U6 (from first row to current row) | |
| FILTER AREA | |
| =filter($K$1:U6,not(ISBLANK(K6:U6))) |