Extract characters
I am trying to extract the first two or three characters before "WN" in a text field. Left(Trim([Incident Number]),"WN") works until you have something that has another "N" or "W". Example text is: ...
Forum Discussion
You could get away using a Part function - which will split your text into parts based on a matching delimiter
So like
Part(string,1,"WN")
Will return whats in front of the first WN
Chayce Duncan | Technical Lead
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base
So like
Part(string,1,"WN")
Will return whats in front of the first WN
Chayce Duncan | Technical Lead
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base
It gives me an error message to check the sytax.
var text t=[Incident Number];
If(
Right(Left($[Incident Number],6),2)="WN",Left($[Incident Number],4),
Right(Left($[Incident Number],5),2)="WN",Left($[Incident Number],3),
Right(Left($[Incident Number],4),2)="WN",Left($[Incident Number],2),
Right(Left($[Incident Number],3),2)="WN",Left($[Incident Number],1),
"")
var text t=[Incident Number];
If(
Right(Left($[Incident Number],6),2)="WN",Left($[Incident Number],4),
Right(Left($[Incident Number],5),2)="WN",Left($[Incident Number],3),
Right(Left($[Incident Number],4),2)="WN",Left($[Incident Number],2),
Right(Left($[Incident Number],3),2)="WN",Left($[Incident Number],1),
"")