NQE example similar to using grep and awk

Hello @RonAvila 

You can capture the entire string into a list

interface {string}
   description {desc: (string*)}

Hi Ron,

I’m not sure if this is exactly what you’re looking for: But this will give you the output of:
Hostname ---- Interface ----- Description

I narrowed it down to just Cisco/IOS-XE with the “wheres” but you can adjust.

pattern = ```
interface {IntName:string} 
    description {desc: ((string)*)}
```;

foreach device in network.devices
	 where device.platform.vendor == Vendor.CISCO
	 let outputs = device.outputs
foreach command in outputs.commands
	where command.commandType == CommandType.CONFIG
	let parsed = parseConfigBlocks(OS.IOS_XE , command.response)
foreach match in blockMatches(parsed, pattern)



select {Hostname:device.name , Intf:match.data.IntName, Desc:match.data.desc}

interface {string}
   description {desc: (string*)}

You beat me!

Thanks all!

Now is it possible to parse through the strings by character? For example, if I wanted to extract site_a, site_b from each of the descriptions? I want to extract just one piece of the description for each interface. Can we iterate through strings?

@RonAvila String manipulation requires a little special handling, We will be improving this in future releases. But here is one example.


 

test = """
interface Ethernet1/1
 description “to site x interface gi0/0”;
!
interface Ethernet1/2
 description “to site y interface gi0/1”:
!
""";

trimLast(s) = prefix(s, length(s)-1);
trimFirstLast(s) =  max(foreach x in [0] let p = prefix(s, length(s)-2) select suffix(p, length(p)-1));

pattern = ```
interface {IntName:string} 
 description {s: (string*)}
```;

stringParse =  `to site {site: string} interface {int: string}`;


foreach x in [0]
let blocks = parseConfigBlocks(OS.UNKNOWN, test)
foreach match in blockMatches(blocks, pattern)
let newString = trimFirstLast(join(" ", match.data.s))
let site = patternMatch(newString, stringParse)
select {FromInterface: match.data.IntName, ToSite: site.site, ToInterface: site.int, }

Thanks @GaryB ! We will try this example!