i have a variable ticker.
for example, one observation can be: aaa.1
i want to have end up with just aaa, deleting .1, esssentially deleting "." and everything that comes after "."
plz help. thank you
Use the scan function:
Check the docs for all the modifies and options available i.e. keep/drop character lists etc
Scan(var, 1, ".")