Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I've got a situation where i would like to remove ' AB- ' & '???' below characters from table.
i would just like to have QWE , DFG , WER , RTY, TYU,GHJ in my field and nothing else in it.
is there a way i can achive this ?
AB-QWE |
AB-DFG??? |
AB-WER??? |
AB-RTY ??? |
AB-TYU ??? |
AB-GHJ??? |
Hi
If the strings are always if that format then try the following
PurgeChar(Mid(Yourfield,4),'?')
Regards
Adrain
Hi,
Try with : left(subfield(YourField,'-',2),3)
Hi
try with this
Subfield(PurgeChar(FIELD,'?'),'-',2)
Hi
If the strings are always if that format then try the following
PurgeChar(Mid(Yourfield,4),'?')
Regards
Adrain
Abhay, did any of the posts get you what you needed to resolve things? If so, please be sure to circle back and use the Accept as Solution button on those that did get you want you wanted. If you ended up doing something different, please consider posting that for others, and you can then mark it as the solution as well. If you are still trying to figure things out, please leave an update for us.
Regards,
Brett
thanks alot mate. This helped me , sorry for late acceptance as my id wouldn't work.