in ksh I have a input file that holds the following: $ cat input.txt A {111 222 111} B {333,444,333} C {555 666 555} $ When I Run the following command Im getting the following $ while read LINE > do > echo $LINE > done<input.txt A {111 222 111} B 333 444 333 C… Read More Reading line from file which holds braces and comma
I’ve an input file that consists of IP Address and subnet masks. As an example, 1.example.com,10.135.10.111,255.255.255.0,some comment 2.example.com,10.135.10.112,255.255.255.0,some comment 3.example.com,10.135.10.113,255.255.255.0,some comment 4.example.com,10.135.10.11,255.255.255.0, some comment 10.135.10.111 A 10.135.10.112 A 10.135.10.113 A 10.135.10.11 A I loop the IP address in my bash script and when using the perl or sed command all .11 gets changed. As an… Read More change of ip address using perl or sed
I have a row with 4 columns that are each 3 wide, which adds up to the 12 that are supposed the be in a row, but for some reason the last one is still going onto a new row. Any idea how to fix this? Here’s my code: <div class=”container text-center”> <h3>Welcome to “Ender’s… Read More Why is a column going into the next row when there are only 12 columns?
I have a data frame which is having multiple columns each column is having string values. I want to split column values by coma separator in the output data frame. Input and required output are as below Col1=c("a,b,c","9,a,5") Col2=c("c,b,e","4,r,t") Col3=c("e,f,g","y,z,d") Input=data.frame(Col1,Col2,Col3) Column1=c("a","9") Column2=c("b","a") Column3=c("c","5") Column4=c("c","4") Column5=c("b","r") Column6=c("e","t") Column7=c("e","y") Column8=c("f","z") Column9=c("g","d") Output=data.frame(Column1,Column2,Column3,Column4,Column5,Column6,Column7,Column8,Column9) If anyone know the… Read More applying str_split_fixed function simultaneously across multiple columns in r
Is there a way to sample X number of random rows and X non-random rows in a single sample? For example, I want to get 1,000 samples of 4 rows of iris. I want to randomly sample 3 rows of iris and the fourth row will be the same one in each sample (this is… Read More Sampling randomly and non-randomly in one sample
Hi have used the below code to remove the last row of data from a table. The code works ok in isolation but when run as part of a larger set of code it does not remove the last row. Any ideas on what is causing this and solution would be appreciated. Sub TrimJrnl() Dim… Read More Delete Last Row in Table vba
Sub Crons() Dim s1 As Worksheet, s2 As Worksheet Dim check1 As Boolean, check5 As Boolean, check10 As Boolean, flow As Boolean, speed As Boolean, motor_power As Boolean Set s1 = ThisWorkbook.Worksheets(1) Set s2 = ThisWorkbook.Worksheets(2) check1 = s2.CHECKBOXES("Check Box 1").Value = xlOn check5 = s2.CHECKBOXES("Check Box 5").Value = xlOn check10 = s2.CHECKBOXES("Check Box 10").Value… Read More How to perform multiple AND statement after THEN Statement
Should be a simple one, but cant figure it out. In Col A, if A3 = No, mouse cursor moves to F3, that fine, In Col A, if A4 = No, mouse cursor moves to F4 and so forth I can seem to figure out the correct code for or how to write the code… Read More Excel VBA, move mouse to different cell
I am trying to add the WooCommerce product class to the cart items on the cart page. I have products in a specific category with faster shipping (quickship) and want to highlight them on the cart page to make my customers aware of it before check out. I’ve tried to add the wc_product_cat_class( ”, $category… Read More Add a CSS class to WooCommerce cart items based on product category
i want to check if the passed argument in command line is the last day of month like below: ./check_date.sh 20210731 if 20210731 is the last day of month echo "last day of month" else echo "no the last day of month" mydate="$1" #i found this code in stackoverflow thread but do not now if… Read More check if shell argument is last day of month