I am trying to set the IFS to ‘:’, but it seems to not work. Here is my code, FILE="/etc/passwd" while IFS=’:’ read -r line; do set $line echo $1 done < $FILE When I run my code, it seems to give me the entire line. I have used the set command to assign positional… Read More How to use Internal Field Separator correctly?
If A4 ="contact" and B4 = "" return "XXX" but if A4 = "contact" and B4 isn’t blank return "Video/Audio" in c4 https://docs.google.com/spreadsheets/d/1OH2i45NyRBThFBMQJ_lYbMtpmYAAzOm0FRp5a1DBOm4/edit?usp=sharing >Solution : use: =INDEX(IF((A4:A="contact")*(B4:B=""), "XXX", IF((A4:A="contact")*(B4:B<>""), "Video/Audio", )))
Hoping someone could please help me with the below, I am using the SUMIFS formula in my VBA code and it works for values except for when i am trying to find blanks. Example source dataset: Date (column G in original sheet) Customer (column O in original sheet) TransactionValue (column E in original sheet) 2021-02-26… Read More SUMIFS not matching blank values
I need to read in a line from a file in c++ but need to save two strings as one. For example, if the the files line had someones name like Bernie Sanders, I would want to save the entire name into a string variable instead of just the first name. >Solution : I assume… Read More I am using the ifstream function in c++ and I need to save two words as one string instead of splitting them
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 an collection with given fields: class InternalConditionModel { public string ProductId { get; set; } public double Value { get; set; } public DateTime DateFrom { get; set; } public DateTime DateThru { get; set; } public bool IsSSoldOnlyOnDisplay { get; set; } } And have to filter it based on given conditions:… Read More Complicated Linq filtering without nesting countless if/foreach
I have a file called data.txt. when I read the file, the content looks like the below. $ cat data.txt name: linuxVol id: 6 type: Linux dir excludes: .snapshot* ~snapshot* .zfs .isilon .ifsvar .lustre inode: 915720 free_space: 35.6TiB (auto) total_capacity: 95.0TiB (auto) number_of_files: 5,789,643 number_of_dirs: 520,710 mounts: https://server1.example.com:30002: /mnt/tube How can I extract keywords Linux… Read More How do I extract two different keywords from two different lines in a file in bash shell?
There is a txt file that contains the following data: the name of a city a temperature in the city, measured in celsius for example London 3 Washington 11 Budapest 3 London 5 Budapest 30 Washington 11 London 15 Budapest 7 How can I calculate each city’s average temperature. Can I somehow sort it and… Read More sorting by strings in c++
I was trying to do a "multiple filter" in TS, So… If i send nothing -> it returns all products normally; But if i send some params -> it returns products filtered by the params. (I used colors just for the example) async load(params: params): LoadProducts.Result => { const products = []; if (params) {… Read More TypeScript – How can i deal with multiple IFs
So I know I can use a single IFS in a read statement, but is it possible to use two. For instance if I have the text variable = 5 + 1; print variable; And I have the code to assign every word split to an array, but I also want to split at the… Read More How to use two `IFS` in Bash