I have a field in my data that is actually comprised of multiple fields from the original data (which I can't access). A series of 70 character strings are strung together to create my field, but in the process a space is added between the original fields. I'd like to figure out how I can remove that space that occurs after 70 characters - so characters, 71, 142, 213, etc. in each record of a column.
An example string/record:
Clean out sump closet
Clean exterior flat work
Clean unfinished baseme nt area
Clean out cabinets at basement bar, clean countertops
Clean tr acks of sliding glass doors throughout, difficult to operate
Clean fro nt porch, check for defects
In essence, I want to fix the spelling of "basement," "tracks," and "front"
I apologize if this was posted elsewhere, my search didn't turn up results.
An example string/record:
Clean out sump closet
Clean exterior flat work
Clean unfinished baseme nt area
Clean out cabinets at basement bar, clean countertops
Clean tr acks of sliding glass doors throughout, difficult to operate
Clean fro nt porch, check for defects
In essence, I want to fix the spelling of "basement," "tracks," and "front"
I apologize if this was posted elsewhere, my search didn't turn up results.