$proc =get-counter -Counter "\Processor(_Total)\% Processor Time" -SampleInterval 2
$Cpu=($proc.readings -split ":")[-1]
$cpu

scp -r USERNAME@SERVER_NAME:PATH_IN_THE_SERVER: C:/Test

scp -r USERNAME@SERVER_NAME:PATH_IN_THE_SERVER: My IP Address\sharedpath

FileInputStream fstream = new FileInputStream("file1.txt");

        If name = name1 Then
                If activity <> activity1 Then GoTo 10
                    If subactivity <> subactivity1 Then
                            GoTo 10

Sub Macro3()
'
' Macro3 Macro
'
    Dim a As Integer
    Dim j As Integer
    Windows("ptimesheet.xlsm").Activate
    Dim B As String
    Dim TRACKERNAME

Sub Macro3()
'
' Macro3 Macro
'
    Dim i As Integer
    i = 1
    For i = 1 To 10
        If (Range("A" & i).Select = Range("B" &

select CHARINDEX(':',name) from oracle

Select
Case CHARINDEX(':',name)
When 0 --Type1
THEN name
ELSE
SubString(name,CHARINDEX(':',name)-1,LEN(name))
END
as column1

select 
Case CHARINDEX(':',columnname)
When 0
THEN'columnname'
ELSE
SubString('columnname',CHARINDEX(':','columnname')-1,LEN('columnname'))
END
as column1
from table1
where column1= 'xyz'