Hi EconomiCurtis,
You are partly correct. Those examples are not column names but the Column values. I want my codes to return values under column "Site" which contain "def" for example it should match value "abcdef", "defgh", "bcdefg" but NOT "abc", "bcdfg", "deghij" or "efghi".
This is a sample of values in column "Site" (ignore the line number):
39 OfficeVPC-PublicIP(EXTERNAL)-VCP6-DCInfra
40 OfficeVPC-PublicIP(EXTERNAL)-OfficeInfra
44 Location1-PublicIP(EXTERNAL)-RDP
45 Location1-PublicIP(EXTERNAL)-VCP2-1st
46 Location1-PublicIP(EXTERNAL)-VCP2-2nd
47 Location1-PublicIP(EXTERNAL)-Gate
48 Location1-PublicIP(EXTERNAL)-Office
49 VASNOC-PublicIP(EXTERNAL)
50 VASSOC-PublicIP(EXTERNAL)
51 Location1-PublicIP(EXTERNAL)-VCP2
52 VSMServer-PublicIP(EXTERNAL)-VCP6
53 Location1-PrivateIP(EXTERNAL)-Africa
54 DEVOPS-PublicIP(EXTERNAL)-VCP6
55 VASNOC-PublicIP(EXTERNAL)-ByDomain
56 CPT-PublicIP(EXTERNAL)-VCP6
57 IXXSEM-PublicIP(EXTERNAL)-VCP6
58 Webmail-PublicIP(EXTERNAL)-VCP6&Moscow
59 Service-PublicIP(EXTERNAL)
60 Location1-PublicIP(EXTERNAL)-VCP6
61 Location1-PublicIP(EXTERNAL)-Bangkok-NewIPRange
62 DataCenter-PublicIP(EXTERNAL)-CCTV
63 Location1-PublicIP(EXTERNAL)-VCP10
64 Webmail-PublicIP(EXTERNAL)-VCP6&PD
65 IXD-PublicIP(EXTERNAL)-TVCP6
So if I want values which contain VCP2 only, it should return me these values only:
Location1-PublicIP(EXTERNAL)-VCP2-1st
Location1-PublicIP(EXTERNAL)-VCP2-2nd
Location1-PublicIP(EXTERNAL)-VCP2
Code below will not give me anything.
VAPublicIP %>% filter(Site == "VCP2") %>% ggplot() +
geom_point(mapping = aes(x = Host, y = `Plugin ID`, color = Risk))
How do I fix this?
Thanks