Hi,
I need to select the text from the right of the last comma and insert the column of the result into the existing table.
The only issue is the last comma isn't always in the same position. It can be the 9 or 10th character of the string.
Help
Novice
Windows 10 
Access 2016
Selecting text from right of last comma
Hi,
I need to select the text from the right of the last comma and insert the column of the result into the existing table.
The only issue is the last comma isn't always in the same position. It can be the 9 or 10th character of the string.
Help
Last edited by Seraphina; 06-28-2018 at 04:51 PM. Reason: spelling
Moderator
Windows 10 Access 2010 32bit
Who is John Galt?
Windows XP Access 2007
And use that within the Mid() function:
https://www.techonthenet.com/access/...string/mid.php
Text query before comma if any
Split Comma Separated Text on Separate Lines of Texbox
End of Text Box - Replace Comma with Period
Posting Permissions
Reply With Quote