‎01-20-2020 10:00 PM
SubQuery1.Value As Image
‎01-20-2020 10:36 PM
SELECT Right(SubQuery1.Value, Len(SubQuery1.Value) - CharIndex('e v', SubQuery1.Value) - 2)Given your source text as example,
Windows 10 Enterprise v1903
....:....1....:....2....:..
Len(SubQuery1.Value)returns 27, the length of the source text.
SELECT CharIndex('e v', SubQuery1.Value)returns 21, the position of the "e" where "e v" was found.
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now