Forum Discussion
Solved
Text Replace help
Hey, I need assistance in removing "years" from the data output in a column. The data comes in labeled as.. 1 Year 2 Year 3 Year etc, I need it to just display a # like 1 2 3 4 and so on I...
thomas_coltrain
Please use the followingYear Number = VAR String = Data[Year] VAR NumberLength = SEARCH ( "Y", String, 1, 3 ) - 2 RETURN LEFT ( String, NumberLength )
thomas_coltrain
Please use the following
Year Number =
VAR String = Data[Year]
VAR NumberLength = SEARCH ( "Y", String, 1, 3 ) - 2
RETURN
LEFT ( String, NumberLength )
Fast service!! Thank you for the help!