I have some data that needs to be separated before a special character indicator. For example, here is what the data looks like before:
getInfoRed.12354
getInfoGreen?54698
getInfoBlue/98765
And here is the desired outcome I am trying to achieve:
getInfoRed
getInfoGreen
getInfoBlue
Any help would be greatly appreciated. Thanks!
@Hoss2434
By a special character, i think we can assume that it is not word character or digit.