Find function

[vmjan02]

Hi,

I have a data in column A as

ASR903/I-AP-VKPM-ENB-0178/VKPMGLNMPAR001/172.16.98.137/PSU fail 2/10 --> a1
ASR903//I-MH-PNJI-ENB-0070//PNJISNGLPAR002//172.16.98.38//p0 unknown --> a2
ASR-903// I-WB-ASSL-ENB-0077 *ASSLNCPRPAR001/172.16.58.119//P1 fail --> a3
ASR903/VDDRRMNGPAR001/I-GJ-VDDR-ENB-0123/IM37511249/P1 PSU is in failed state -->a4 and so on


Is there a function to only get (in column B output)
I-AP-VKPM-ENB-0178 --> from a1
I-MH-PNJI-ENB-0070 --> from a2
I-WB-ASSL-ENB-0077 --> from a3
I-GJ-VDDR-ENB-0123 --> from a4
all the len is 18

Is there a function to only get (in column C output)
VKPMGLNMPAR001 --> from a1
PNJISNGLPAR002 --> from a2
ASSLNCPRPAR001 --> from a3
VDDRRMNGPAR001 --> from a4
all the len is 14

 

[steve the fish]

This would work with all examples you have provided so far:

=MID(A1, SEARCH("PAR00?/",A1)-8, 14)

 

[vmjan02]

cool steve, went well. worked great.