asked
removing specific charaters from a column
Hi I am having column values like 66 In. x 82 In. 22 In. x 11 In. Rectangular Lite 4-Panel Pre-Finished White Double Steel Entry Door with Astragal and Brickmould Aquadica GS 30 In. x 30 In. x 72 In. Completely Frameless Square Shower Enclosure with Glass Shelves in Stainless Steel and so on . I need to remove the measurements (i.e)- 66 In. x 82 In. 22 In. x 11 In. and the ouput should be like this Rectangular Lite 4-Panel Pre-Finished White Double Steel Entry Door with Astragal and Brickmould Aquadica GS Completely Frameless Square Shower Enclosure with Glass Shelves in Stainless Steel. can anyone please help?
That's going to very difficult even with regular expressions. Have you questioned this requirement? It might not be very important. When you explain the effort (ie. cost) involved they might realise they don't need it that much. And is there a possibility of moving the dimensions to other fields? This is potentially useful data that's just lost in a blob of text. If it was stored in other columns you could use it better and this problem would go away. It's much easier to build a description like this from its parts on demand than it is to strip some parts back out again.
18 People are following this question.
