Charles2019
New member
- Local time
- Today, 13:16
- Joined
- Mar 24, 2020
- Messages
- 22
I've got a data string that has an * in it followed by a comma with data with characters after it. I need to remove the * and all of the characters to the right after it. The range of characters vary in length. Data Sample;
CSQ_ACNY_Team1*, CSQ_ACNY_AllOther
CSQ_ACNY_Team1*
I've tried using this statement Replace([CSQ Names],Chr(42),"")
CSQ_ACNY_Team1*, CSQ_ACNY_AllOther
CSQ_ACNY_Team1*
I've tried using this statement Replace([CSQ Names],Chr(42),"")