cleaning up ticker. deleting everything after .

Reply
Frequent Contributor
Posts: 102

cleaning up ticker. deleting everything after .

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

Super User
Posts: 19,770

Re: cleaning up ticker. deleting everything after .

Use the scan function:

Check the docs for all the modifies and options available i.e. keep/drop character lists etc

Scan(var, 1, ".")

Ask a Question
Discussion stats
  • 1 reply
  • 176 views
  • 0 likes
  • 2 in conversation