question

RAJABHARATHI29 avatar image
RAJABHARATHI29 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?
stringcolumn
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
David Wimbush avatar image
David Wimbush answered
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.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.