Is there a way to strip spaces that are in the middle of a string? I know the LTrim,RTrim & Trim functions for trailing, leading & both spaces but what about in the middle. For example:
The sentence below was imported from a spreadsheet into one field and it treated the hard line feed as a huge space. So now I need to figure out how to put "....-You begin your assessment and management of the situation because you b" on a new line in that field.
this is currently what the sentence looks like in the field:
You are called to the scene of a middle-aged man who has “passed out” in the hallway. Upon arrival the scene is safe, and the patient remains unresponsive. -You begin your assessment and management of the situation because you b
I want to update the data to look like this:
You are called to the scene of a middle-aged man who has “passed out” in the hallway. Upon arrival the scene is safe, and the patient remains unresponsive.
-You begin your assessment and management of the situation because you b
The sentence below was imported from a spreadsheet into one field and it treated the hard line feed as a huge space. So now I need to figure out how to put "....-You begin your assessment and management of the situation because you b" on a new line in that field.
this is currently what the sentence looks like in the field:
You are called to the scene of a middle-aged man who has “passed out” in the hallway. Upon arrival the scene is safe, and the patient remains unresponsive. -You begin your assessment and management of the situation because you b
I want to update the data to look like this:
You are called to the scene of a middle-aged man who has “passed out” in the hallway. Upon arrival the scene is safe, and the patient remains unresponsive.
-You begin your assessment and management of the situation because you b