Technical Forum to Ask, Learn, & Collaborate

Use this array formula: =LEFT(A1,MIN(IFERROR(FIND({"KB","MB","GB","TB"},A1),1E+99))-1)/INDEX({1048576,1024,1,0.0009765625},MATCH(RIGHT(A1,2),{"KB","MB","GB","TB"},0)) & "GB" Being an ...READ MORE

Oct 31, 2022 in Others by narikkadan
• 63,600 points • 2,685 views

0 votes

1 answer

How can I store the data of an open excel workbook in a collection using BluePrism?

To do what you want is like ...READ MORE

Nov 24, 2022 in Others by narikkadan
• 63,600 points • 1,647 views

0 votes

1 answer

Excel how to fill all selected blank cells with text

Do the following to place the same ...READ MORE

Dec 16, 2022 in Others by narikkadan
• 63,600 points • 695 views

0 votes

0 answers

Fetch data from database in php through AJAX,

The index.php I created a connection with the ...READ MORE

Jun 16, 2022 in PHP by narikkadan
• 63,600 points • 8,638 views

0 votes

1 answer

HLOOKUP in Excel Formula

If you want to switch up the ...READ MORE

Dec 17, 2022 in Others by narikkadan
• 63,600 points • 646 views

0 votes

1 answer

How to remove or delete comments in excel worksheet?

Get a range, then clear comments: Worksheets("MySheet").Activate ActiveSheet.UsedRange.ClearComments I ...READ MORE

Dec 11, 2022 in Others by narikkadan
• 63,600 points • 898 views

0 votes

0 answers

Connecting to AWS EC2 instance from Docker SDK for python

I have created a free tier EC2 ...READ MORE

Dec 13, 2022 in AWS by Ashwini
• 5,430 points • 826 views

0 votes

0 answers

CDK :How to use/import s3 defined in one stack to another stack ( In different file)?

a little bit new to typescript and ...READ MORE

Dec 13, 2022 in AWS by Ashwini
• 5,430 points • 827 views

0 votes

0 answers

Github Action - How can I trigger a workflow when argocd deployment is finished?

I work for a company that makes ...READ MORE

Dec 30, 2022 in Other DevOps Questions by Damonlang
• 1,230 points
edited Mar 4 • 91 views

0 votes

0 answers

Convert a number into a Roman numeral in JavaScript

What is the best way to convert integers to roman numerals? function romanNumeralGenerator (int) { } Consider the following sample inputs and outputs: 1 = "I" 5 = ...READ MORE

Dec 8, 2022 in Java by Nicholas
• 7,760 points • 1,039 views

0 votes

0 answers

discord.ext.commands.errors.ExtensionFailed: Extension 'cogs.unban' raised an error: IndentationError: expected an indented block (unban.py, line 11)

import discord from discord.ext import commands from discord import ...READ MORE

Dec 31, 2022 in Python by anonymous
• 100 points
edited Mar 4 • 53 views

0 votes

0 answers

Android : Check whether the phone is dual SIM

After extensive investigation on discussion boards, I now understand that a dual SIM phone's IMSI or SIM serial numbers cannot be found (except for contacting the manufacturer). My original query has been amended to: Can we even tell the phone has two SIMs? I think someone with some intellect could find it. I can think of a few ways, including: tracing the logs for the IMEI number and dialling a USSD code (I tested this in India with *139#). It succeeded.) This will provide me with the SIM's IMEI number from which I called the USSD code. (The phone is assumed to adhere to Android standards and have two IMEI numbers.) preserving the SIM's IMSI and/or serial number. ...READ MORE