Hello,
I am trying to create a query that deletes part of a text in a certain column. The length of the text that needs to be delete varies, but the one thing they all have in common is the word "Location" So I want all text, including the word location, after to be removed and everything else that is in the cell kept the same. Below is an example:
john smith 123 main st anytown us 12345 Location: Business - Status: Active
The location type and status have different types so that text length could vary.
I just need the fields to have
john smith 123 main st anytown us 12345
I have around 30,000 records that I need to update like this, I am trying to avoid just doing a find/replace operation for some many records
Any help would be apreciated
I am trying to create a query that deletes part of a text in a certain column. The length of the text that needs to be delete varies, but the one thing they all have in common is the word "Location" So I want all text, including the word location, after to be removed and everything else that is in the cell kept the same. Below is an example:
john smith 123 main st anytown us 12345 Location: Business - Status: Active
The location type and status have different types so that text length could vary.
I just need the fields to have
john smith 123 main st anytown us 12345
I have around 30,000 records that I need to update like this, I am trying to avoid just doing a find/replace operation for some many records
Any help would be apreciated