Skip to content

Instantly share code, notes, and snippets.

View sudiptamondal's full-sized avatar
🏠
Working from home

Sudipta Mondal sudiptamondal

🏠
Working from home
5 followers · 3 following
  • New Delhi, India
View GitHub Profile
@sudiptamondal
sudiptamondal / read_sql_fetch_cols.rb
Created February 25, 2020 12:09
Code snippet to fetch column names between select and from keyword to analyse.
def analyse file_path
file = File.open(file_path, "r")
counter = 0 # counter for having a 2D Array
writefile = false
array = Array.new
file.readlines.each do |line|
if line.start_with? "SELECT"
writefile = true;
array[counter] = Array.new
end
@sudiptamondal
sudiptamondal / GET_REQ_VIA_MACRO.vb
Created February 25, 2020 13:03
Code Snippet to send GET Request via function in Excel Macro
Private Sub FetchData()
Dim objRequest As Object, strUrl As String, blnAsync As Boolean, strResponse As String
Dim jsonObject As Object, item As Variant
Set objRequest = CreateObject("MSXML2.XMLHTTP")
strUrl = "<URL_GOES_HERE>"
blnAsync = True
With objRequest
.Open "GET", strUrl, blnAsync
@sudiptamondal
sudiptamondal / read_json_in_macrocode.vb
Created February 25, 2020 14:12
Code snippet to loop through JSON data
Dim jsonObject As Object, item As Variant
Set jsonObject = JsonConverter.ParseJson(strResponse)
For Each item In jsonObject
'do something with json object
Next item
@sudiptamondal
sudiptamondal / sample_data_for_edq_proc.csvalues
Last active February 27, 2020 13:22
sample_data_for_edq_proc.csvalues
+--------+--------------+------------+-----------------+
| Value | Convert From | Convert To | Converted Value |
+--------+--------------+------------+-----------------+
| 100.14 | INR | USD | |
| 290.19 | INR | GBP | |
| 310.05 | INR | EUR | |
| 110.67 | INR | CAD | |
| 200 | EUR | EUR | |
| 10 | EUR | GBP | |
| 3 | EUR | INR | |
@sudiptamondal
sudiptamondal / sample_data_for_edq_proc.json
Created February 27, 2020 13:32
sample_data_for_edq_proc.json
{"base":"EUR","rates":{"CAD":1.4469,"HKD":8.4742,"ISK":139.3,"PHP":55.538,"DKK":7.471,"HUF":339.28,"CZK":25.344,"AUD":1.6565,"RON":4.805,"SEK":10.5813,"IDR":15221.86,"INR":77.9195,"BRL":4.7741,"RUB":71.2368,"HRK":7.4605,"JPY":120.13,"THB":34.664,"CHF":1.0606,"SGD":1.5204,"PLN":4.3094,"BGN":1.9558,"TRY":6.6981,"CNY":7.6329,"NOK":10.2113,"NZD":1.7273,"ZAR":16.4555,"USD":1.0875,"MXN":20.806,"ILS":3.7429,"GBP":0.8415,"KRW":1322.29,"MYR":4.5952}}
@sudiptamondal
sudiptamondal / edq_script_proc.js
Created February 27, 2020 13:37
Script Processor in Javascript for currency conversion
addLibrary("http");
var output1;
var xmlHttp = new XMLHttpRequest();
xmlHttp.open("GET", "http://demo7684243.mockable.io/curr_rates", false);// Here goes your web service URL
xmlHttp.send();
var responseData = xmlHttp.responseText;
var dataJSON = JSON.parse(responseData);
var baseCurr = dataJSON["base"];
@sudiptamondal
sudiptamondal / fastled_arduino.ino
Last active February 28, 2020 06:52
fastled_arduino.ino
#include <FastLED.h>
int led = 13; // Usually the orangle led is set at pin 13.
#define LED_PIN 6 // data pin to be connected to WS2812B
#define NUM_LEDS 60
#define LED_TYPE WS2812B // make sure to choose the correct LED TYPE.
#define COLOR_ORDER GRB
#define BRIGHTNESS 200
@sudiptamondal
sudiptamondal / todo.html
Created February 28, 2020 13:01
A simple Todo Application
<!doctype html>
<html>
<head>
<title>Sample To-Do</title>
<style type="text/css">
section {margin: 0 auto;width: 100%;}
h3, h5, li {float: left;width:100%;}
ul {list-style: none;}
input[type=checkbox], p { float:left;margin: 0;}
</style>
@sudiptamondal
sudiptamondal / UpdateTPIWithEndDate.xml
Created March 11, 2020 05:57
Update Trading Partner Item with End Date
<soapenv:Envelope
xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:typ="http://xmlns.oracle.com/apps/scm/productModel/items/tradingPartnerItems/tradingPartnerItemServiceV2/types/"
xmlns:trad="http://xmlns.oracle.com/apps/scm/productModel/items/tradingPartnerItems/tradingPartnerItemServiceV2/" >
<soapenv:Header/>
<soapenv:Body>
<typ:updateTradingPartnerItem>
<typ:tradingPartnerItem>
<trad:TradingPartnerItemId>300000063693002</trad:TradingPartnerItemId>
<trad:EndDate>2019-09-21</trad:EndDate>
@sudiptamondal
sudiptamondal / BLOG_XML_02062020.xml
Created March 11, 2020 06:02
<!-- 1. --> <trad:EndDate>NULL</trad:EndDate>
<!-- 2. --> <trad:EndDate>nil</trad:EndDate>
<!-- 3. --> <trad:EndDate></trad:EndDate>