jeffreydavidson
New member
- Local time
- Yesterday, 21:06
- Joined
- Nov 28, 2018
- Messages
- 3
I have a field in a table named ItemData that returns multiple items... i.e.
R431161|,||,|True|,||,|False
I am looking to show in the query results only the data before the first space, which would be the account number only in this case. The account number (Rnumber) can be 6 or seven digits so it cannot be just a hard number to trim from the left but most likely all after the first space in the string. Thanks!
R431161|,||,|True|,||,|False
I am looking to show in the query results only the data before the first space, which would be the account number only in this case. The account number (Rnumber) can be 6 or seven digits so it cannot be just a hard number to trim from the left but most likely all after the first space in the string. Thanks!