Code:
SELECT NBOI.[NBOI Sort Order (int)], NBOI.[VRC-116 HMS MP Single WLS-1] AS Nets, IIf([Nets]<>"",IIf(Left([Nets],InStr([Nets],":")-1) Like "*|*",Replace(Left(Left([Nets],InStr([Nets],":")-1),InStr([Nets],"|")-1),"[",""),Mid(Left([Nets],InStr([Nets],":")-1),2,20)),"") AS CH1a, IIf([CH1a]="SRW1",[SRW1],IIf([CH1a]="SRW2",[SRW2],IIf([CH1a]="MUOS",[MUOS1],IIf([CH1a]="SINCGARS1",[SINC1],IIf([CH1a]="SINCGARS2",[SINC2],IIf([CH1a]="SINCGARS3",[SINC3],IIf([CH1a]="SINCGARS4",[SINC4]))))))) AS CH1aNet, IIf([Nets]<>"",IIf(Left([Nets],InStr([Nets],":")-1) Like "*|*",Mid(Left([Nets],InStr([Nets],":")-1),InStr([Nets],"|")+1))) AS CH1b, IIf([CH1b]="SRW1",[SRW1],IIf([CH1b]="SRW2",[SRW2],IIf([CH1b]="MUOS",[MUOS1],IIf([CH1b]="SINCGARS1",[SINC1],IIf([CH1b]="SINCGARS2",[SINC2],IIf([CH1b]="SINCGARS3",[SINC3],IIf([CH1b]="SINCGARS4",[SINC4]))))))) AS CH1bNet, IIf([Nets]<>"",Mid(Left([Nets],InStr([Nets],"]")-1),InStr([Nets],":")+2)) AS 116CH2, IIf([116CH2] Like "*|*",Left([116CH2],InStr([116CH2],"|")-1),[116CH2]) AS CH2a, IIf([CH2a]="SRW1",[SRW1],IIf([CH2a]="SRW2",[SRW2],IIf([CH2a]="MUOS",[MUOS1],IIf([CH2a]="SINCGARS1",[SINC1],IIf([CH2a]="SINCGARS2",[SINC2],IIf([CH2a]="SINCGARS3",[SINC3],IIf([CH2a]="SINCGARS4",[SINC4]))))))) AS CH2aNet, IIf([116CH2] Like "*|*",Mid([116CH2],InStr(1,[116CH2],"|")+1)) AS CH2b, IIf([CH2b]="SRW1",[SRW1],IIf([CH2b]="SRW2",[SRW2],IIf([CH2b]="MUOS",[MUOS1],IIf([CH2b]="SINCGARS1",[SINC1],IIf([CH2b]="SINCGARS2",[SINC2],IIf([CH2b]="SINCGARS3",[SINC3],IIf([CH2b]="SINCGARS4",[SINC4]))))))) AS CH2bNet, [CH1aNet] & IIf([CH1bNet]<>""," | " & [CH1bNet],"") AS [116R1 Channel1], [CH2aNet] & IIf([CH2bNet]<>""," | " & [CH2bNet],"") AS [116R1 Channel2]FROM NBOI
WHERE (((NBOI.[VRC-116 HMS MP Single WLS-1])<>""));