Team, need help again…
I am trying to run following script:
Invoke-Sqlcmd -Query “SELECT [CERTIFIED & UNASSESSED SKILL] FROM master where [CERTIFIED & UNASSESSED SKILL] LIKE ‘%Citrix%’” -ServerInstance dc2012\sqlexpress -Database final
Getting output something like:
Citrix Admin(L3),Citrix Virtualization - Implementation and Maintenance(L1),Communication(L2),English Language(L1),ITIL Documentation(L3),Networking and Infrastructure(L2),Projec…
Citrix Admin(L3),Communication(L2),English Language(L1),ITIL IMPLEMENTATION(L2),Six Sigma(L1),Windows Admin(L3)
Windows Admin(L3),Windows and Citrix Implementation(L3)
Blackberry(L2),Capability Maturity Model Integration - CMMI(L1),Citrix Admin(L3),Communication(L2),English Language(L1),ITIL IMPLEMENTATION(L2),Lean(L1),MS Exchange Admin(L1),MS …
Citrix Admin(L3),Communication(L2),Datacenter - Wintel Stack(L1),English Language(L1),ITIL IMPLEMENTATION(L2),Project Management(L1),Six Sigma(L1),Vmware Support(L2),Windows Admi…
Citrix Admin(L3),Vmware Support(L2),Windows Admin(L3),Wintel-Virtualization and Publishing Infra Consulting(L3)
Citrix Admin(L3),Communication(L2),Datacenter - Wintel Stack(L1),English Language(L1),ITIL IMPLEMENTATION(L2),Six Sigma(L1),Vmware Admin(L3),Windows Admin(L3),Windows and AD Admi…
Citrix Admin(L2),Communication(L2),English Language(L1),Vmware Admin(L1),Vmware Admin(L2),Windows Admin(L1),Windows Admin(L2),Windows and AD Admin(L1),Windows platform & Virtuali…
Citrix Admin(L3),Citrix Virtualization - Implementation and Maintenance(L3),Datacenter - Wintel Stack(L1),English Language(L1),Vmware Admin(L3),Vmware Support(L2),Windows Admin(L3)
Citrix Admin(L3),Communication(L2),English Language(L1),ITIL Ops(L2),Windows Admin(L2),Windows Admin(L3)
Now I have to print only those skills in the output which contains citrix instead of printing all the skills under [CERTIFIED & UNASSESSED SKILL]
Kindly Help