Categories
User Help Web Apps

Generating Google Spreadsheet Links from cell contents

You previously answered a part of my question, but I am looking to modify this behavior in multiple rows of column A so I don’t want to manually correct it. In A2 I have: /mylist/groceries/index.html In B2 I use concatenate =HYPERLINK(CONCATENATE("https//mylife.com",A2),A2) This creates the link I need, and returns the same text that is in […]

Categories
Mastering Development

How to convert a deeply nested json into pandas dataframe

I want to convert a deeply nested json with 500 plus records into a dataframe and then to a csv format with given headers. Some records of the sample json file are given below: JsonRecords = { ‘rec1’: { ‘words’:[ [‘A’, ‘B’, ‘C’, ‘.’], [‘D’, ‘E’, ‘F’,’.’]], ‘Ids’:[ [0, 1], [2, 3]], ‘unique’:[0, 0, 0, […]

Categories
Mastering Development System & Network

Multiple LDAP servers

I have two OpenLDAP servers: the server A with Linux VMs a1 and a2 connected to it (PAM LDAP) the server B with Linux VMs b1 and b2 connected to it (PAM LDAP) The servers have different users stored in their directories. Is it possible to configure the servers so that users stored in the […]

Categories
Mastering Development

Simple integer arithmetic in C language not working

MY goal is to input 3 numbers and output those numbers from greatest to lowest through integer arrays, I can’t seem to make it work. help this is my code ”’ #include<stdio.h> #include<string.h> int main(){ int a[3]; printf("Enter 3 numbers:"); for(int i=0; i<3;i++){ scanf("%d",&a[i]);} if(a[0]>a[1]&&a[1]>a[2]){ printf("%d\t%d\t%d",a[0],a[1],a[2]);} else if(a[0]>a[2]&&a[2]>a[1]){ printf("%d\t%d\t%d",a[0],a[2],a[1]);} else if(a[1]>a[0]&&a[0]>a[2]){ printf("%d\t%d\t%d",a[1],a[0],a[2]);} else if(a[1]>a[2]&&a[2]>a[0]){ printf("%d\t%d\t%d",a[1],a[2],a[0]);} […]

Categories
Mastering Development

How to use puts with multiple variable in one argument in Tcl?

I have a series of list like a1, a2, a3, a4, …. I want to print them in a loop, Thus both a and i are variables. How can I do that? This doesn’t work. for {set i 1}…. puts $a$i } Thanks in advance

Categories
CMS Drupal Mastering Development

Select in a first form / menu, the choices of other fields in other forms

I have three types of content, which represents categories. In each type of content, I have a first field which offers to select a subcategory (different subcategories depending on the type of content). To simplify the creation of a node for my users, I would like them to be able to select in a first […]

Categories
CMS Drupal Mastering Development

Select in a first form / menu, the choices of other fields in other forms

I have three types of content, which represents categories. In each type of content, I have a first field which offers to select a subcategory (different subcategories depending on the type of content). To simplify the creation of a node for my users, I would like them to be able to select in a first […]

Categories
CMS Drupal Mastering Development

Select in a first form / menu, the choices of other fields in other forms

I have three types of content, which represents categories. In each type of content, I have a first field which offers to select a subcategory (different subcategories depending on the type of content). To simplify the creation of a node for my users, I would like them to be able to select in a first […]

Categories
Mastering Development

Is there a succinct list of all perl stateful operators and modifiers?

Details for the stateful behaviour for operators such as match (ie. m//g), stat (ie. stat _) and range (ie. //..//) are in the documentation. However is there a ‘listing’ of all operators or functions that exhibit stateful behaviour? The ones that come to mind are: #ARGV/File/dir/glob: The current line/position is remembered say while <>; #Read […]

Categories
User Help Web Apps

Sum over a formula in google sheets

I have a google sheet and I need to add a lot of stuff like (ABS(A1)+A1)/A1+ (ABS(A2)+A2)/A2+…+ (ABS(A10)+A10)/A10 but I don’t want to write out the sum each time for each term A1,A2,A3,…, A10 Is there a way to write the sum more concise? like SUM( (|x| + x)/x : for x from A1 to […]