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 […]
Tag: A2
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, […]
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 […]
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]);} […]
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
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 […]
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 […]
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 […]
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 […]
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 […]