Why does this work to create an array out of the newline separated elements: declare -a themes IFS=$'\n' themes=($(plutil -extract 'Window Settings' xml1 -o - - <<< "$terminal_settings&...

if I run while read -r -d: path; do ls $path; done <<< "${PATH}" I get the right output. But if I run while IFS=: read -r path; do ls $path; done <<< "${...

For bash, in order to store the Input Field Separator before using a changed one and for restoring it afterwards, I have found the following example on https://unix.stackexchange.com/a/264947: ${IFS+&...

If any H. E. Operator or Heavy Driver has a Valid or Expiring Soon Aramco License (Column F), Column H should display the value of Column F, otherwise display the value of G or E respectively. =ifs( ...

Just try "IFS" with "ARRAYFORULA" & "AND" function to convert units but getting an error message. Trying the following formula to convert some units. Image is ...

I am working on attendance in a google sheet where I maintain hourly attendance. I record attendance for 5 hours everyday. In column B9:B40 I have a list of names. In Row F3:3 I have the dates. From ...

I have some values in the cell AA1 as 'SONA'|'SONAKSHI'|'SUMON'|'SUMONA' But it gives result as SONA'|'SONAKSHI'|'SUMON'|'SUMONA' I have created a formula, =let(cell,indirect($CA$27&"1"...

Sample google-sheet. i am trying to make a formula by using match function but it does not work. Refer to the my sample data in above link, can u help me to make it works ? The formula i need is to ...

I'm using Dialog, in bash, to create a simple multiple choice question. My options all include spaces in the values. When the Dialog is constructed, it appears to be building the array with a space ...

I have a text in the cell A3 =SCHOOL I have built a formula in the cell B3 =IFS(A3= "SCHOOL", "ST. XAVIER", A3="COLLEGE", "OXFORD") But the problem is that, ...

I'm trying to read MySQL results via a loop. I have this working but I have a small issue. The code I'm using is while IFS=$'\t' read fieldA fieldB fieldC fieldD; do echo "$fieldA $fieldB $...

=IFS(AND(B15="",C24="",C25="",C28="",C29=""),"", AND(B15="",C24="",C25="",C28="",C29<>"&...

I have a table describing piecewise functions, with the gradients, intercepts, and the bounds detailed. I am trying to obtain an exact value for an arbitrary grade (which has decimals, if that adds to ...

Consider the following script: #!/bin/bash while true; do IFS=';' read -r echo "Read: $REPLY" done If I run this script and type in 1;2;3, I expect and desire to see the output: Read: ...

Despite my searches, I can't find what's wrong. Locally : RESULT="dir 1 dir 2" IFS=$'\n' for R in $RESULT ; do echo "$R" done is ok Remotely : RESULT="dir 1 dir 2" ...