I want to get everything from the first character to the word United States, for example:
if the address is
123 Grand Concourse, Bronx, NY 10451 United States
i want everything but the United States
It would be easy to trim from the right, but sometimes, they use the word US, or USA.... That's why i couldn't use the replace function.