Drop all characters after string is detected in field

[#1]

Hi,

After a lot of trial, error and searching the forums i cannot seem to come with a conclusion to my issue. If anyone can help that would be greatly appreciated.

I'm trying to drop all characters (numeric or non-numeric) after a word in a field is detected:

I want to be able to drop EVERYTHING after "router" is found in the field resource and keep everything before it

eg.

field name:

• resource

field values:

• CA-E-router123.cisco
• AP-V-router2.cisco
• ME-UL-router72.cisco

desired result:

• CA-E-router
• AP-V-router
• ME-UL-router

Thanks in advance!

[Gysbert_Wassenaar · Accepted solution]

subfield([resource],'router',1) & 'router'

[Clever_Anjos]

Testing if 'router' is present

=if(Index(resource,'router')>0,Left(resource,Index(resource,'router')-1)&'router',resource)

[#4]

Thank you Gysbert! That was a quick, easy solution.