Friday 30 March 2018

Extract Text Before/After Space Or Comma Only In Excel | Specific Text in exel

Extract Text Before Space With Formula In Excel

You can quickly extract the text before space from the list only by using formula.
Select a blank cell, and type this formula 
=LEFT(A1,(FIND(" ",A1,1)-1))
 (A1 is the first cell of the list you want to extract text) , and press Enter button.

Extract Text After Space With Formula In Excel

use this formula =MID(A1,FIND(" ",A1)+1,256).


Wednesday 28 March 2018

Clean HTML tags from string PYTHON | Remove html using Regex PYTHON

Use This method to remove html tags from string , working on python 3+.
It removes everything between <>


## -- Remove all html tags
  def cleanhtml(raw_html):
  cleanr = re.compile('<.*?>')
  cleantext = re.sub(cleanr, '', raw_html)
  return cleantext

Thursday 22 March 2018

Find string between two sub-strings Python |

This can be done by following way based on requirements :

  • index
  • rindex

(it's equivalent of regex (.*) and (.*?) groups)

s = "123123STRINGabcabc"

using index :

def find_between( s, first, last ):
    try:
        start = s.index( first ) + len( first )
        end = s.index( last, start )
        return s[start:end]
    except ValueError:
        return ""
using rindex: 

def find_between_r( s, first, last ):
    try:
        start = s.rindex( first ) + len( first )
        end = s.rindex( last, start )
        return s[start:end]
    except ValueError:
        return ""

print find_between( s, "123", "abc" )
>> 123STRING


print find_between_r( s, "123", "abc" )
>> STRINGabc


Tuesday 20 March 2018

Multiple Choice Questions On Operating System | MCQ computer Science


1) Round robin scheduling is essentially the preemptive version of ________. 
1 FIFO 
2 Shortest job first 
3 Shortest remaining 
4 Longest time first 
Right Ans ) 1 

2) A page fault occurs 
1 when the page is not in the memory 
2 when the page is in the memory 
3 when the process enters the blocked state 
4 when the process is in the ready state 
Right Ans ) 1

3) Which of the following will determine your choice of systems software for your computer ? 
1 Is the applications software you want to use compatible with it ? 
2 Is it expensive ? 
3 Is it compatible with your hardware ? 
4 Both 1 and 3 
Right Ans ) 4 

4) Let S and Q be two semaphores initialized to 1, where P0 and P1 processes the following statements wait(S);wait(Q); ---; signal(S);signal(Q) and wait(Q); wait(S);---;signal(Q);signal(S); respectively. The above situation depicts a _________ . 
1 Semaphore 
2 Deadlock 
3 Signal 
4 Interrupt 
Right Ans ) 2 

5) What is a shell ? 
1 It is a hardware component 
2 It is a command interpreter 
3 It is a part in compiler 
4 It is a tool in CPU scheduling 
Right Ans ) 2 

6) Routine is not loaded until it is called. All routines are kept on disk in a relocatable load format. The main program is loaded into memory & is executed. This type of loading is called _________ 
1 Static loading 
2 Dynamic loading 
3 Dynamic linking 
4 Overlays 
Right Ans ) 3 

7) In the blocked state 
1 the processes waiting for I/O are found 
2 the process which is running is found 
3 the processes waiting for the processor are found 
4 none of the above 
Right Ans ) 1 

8) What is the memory from 1K - 640K called ? 
1 Extended Memory 
2 Normal Memory 
3 Low Memory 
4 Conventional Memory 
Right Ans ) 4 

9) Virtual memory is __________. 
1 An extremely large main memory 
2 An extremely large secondary memory 
3 An illusion of extremely large main memory 
4 A type of memory used in super computers. 
Right Ans ) 3 

10) The process related to process control, file management, device management, information about system and communication that is requested by any higher level language can be performed by __________. 
1 Editors 
2 Compilers 
3 System Call 
4 Caching 
Right Ans ) 3 

11) If the Disk head is located initially at 32, find the number of disk moves required with FCFS if the disk queue of I/O blocks requests are 98,37,14,124,65,67. 
1 310 
2 324 
3 315 
4 321 
Right Ans ) 4 

12) Multiprogramming systems ________. 
1 Are easier to develop than single programming systems 
2 Execute each job faster 
3 Execute more jobs in the same time 
4 Are used only on large main frame computers 
Right Ans ) 3 

13) Which is not the state of the process ? 
1 Blocked 
2 Running 
3 Ready 
4 Privileged 
Right Ans ) 4 

14) The solution to Critical Section Problem is : Mutual Exclusion, Progress and Bounded Waiting. 
1 The statement is false 
2 The statement is true. 
3 The statement is contradictory. 
4 None of the above 
Right Ans ) 2 

15) The problem of thrashing is effected scientifically by ________. 
1 Program structure 
2 Program size 
3 Primary storage size 
4 None of the above 
Right Ans ) 1 

16) The state of a process after it encounters an I/O instruction is __________. 
1 Ready 
2 Blocked/Waiting 
3 Idle 
4 Running 
Right Ans ) 2 

17) The number of processes completed per unit time is known as __________. 
1 Output 
2 Throughput 
3 Efficiency 
4 Capacity 
Right Ans ) 2 

18) _________ is the situation in which a process is waiting on another process,which is also waiting on another process ... which is waiting on the first process. None of the processes involved in this circular wait are making progress. 
1 Deadlock 
2 Starvation 
3 Dormant 
4 None of the above 
Right Ans ) 1 

19) Which of the following file name extension suggests that the file is Backup copy of another file ? 
1 TXT 
2 COM 
3 BAS 
4 BAK 
Right Ans ) 4 

20) Which technique was introduced because a single job could not keep both the CPU and the I/O devices busy? 
1 Time-sharing 
2 SPOOLing 
3 Preemptive scheduling 
4 Multiprogramming 
Right Ans ) 4 

21) A critical region 
1 is a piece of code which only one process executes at a time 
2 is a region prone to deadlock 
3 is a piece of code which only a finite number of processes execute 
4 is found only in Windows NT operation system 
Right Ans ) 1 

22) The mechanism that bring a page into memory only when it is needed is called _____________ 
1 Segmentation 
2 Fragmentation 
3 Demand Paging 
4 Page Replacement 
Right Ans ) 3 

23) PCB = 
1 Program Control Block 
2 Process Control Block 
3 Process Communication Block 
4 None of the above 
Right Ans ) 2 

24) FIFO scheduling is ________. 
1 Preemptive Scheduling 
2 Non Preemptive Scheduling 
3 Deadline Scheduling 
4 Fair share scheduling 
Right Ans ) 2 

25) Switching the CPU to another Process requires to save state of the old process and loading new process state is called as __________. 
1 Process Blocking 
2 Context Switch 
3 Time Sharing 
4 None of the above 
Right Ans ) 2 

26) Which directory implementation is used in most Operating System? 
1 Single level directory structure 
2 Two level directory structure 
3 Tree directory structure 
4 Acyclic directory structure 
Right Ans ) 3 

27) The Banker¿s algorithm is used 
1 to prevent deadlock in operating systems 
2 to detect deadlock in operating systems 
3 to rectify a deadlocked state 
4 none of the above 
Right Ans ) 1 

28) A thread 
1 is a lightweight process where the context switching is low 
2 is a lightweight process where the context swithching is high 
3 is used to speed up paging 
4 none of the above 
Right Ans ) 1 

29) ______ is a high level abstraction over Semaphore. 
1 Shared memory 
2 Message passing 
3 Monitor 
4 Mutual exclusion 
Right Ans ) 3 

30) A tree sturctured file directory system 
1 allows easy storage and retrieval of file names 
2 is a much debated unecessary feature 
3 is not essential when we have millions of files 
4 none of the above 
Right Ans ) 1

Friday 16 March 2018

Select script type in jsoup | JSoup to parse script tag

You can parse script tag using doc.select method.

See below Example to select:

doc.select("script[type=application/ld+json]")
doc.select("script[type=text/javascript")

This will select the desired script tag with text inside for use.