Try this:

CREATE TABLE T
(
    title VARCHAR(100) NOT NULL
   ,Computed AS
        REPLACE(
   ...

• This reply was modified 3 years ago by  vikasjagadale8. Reason: Updated the post with sample query and data

Hello @Phil Parkin I have updated my post with Query to create a table with sample data.

And I have already posted expected output

Thanks, everyone for the input.

Thanks, Jeff I tried your suggested format file 

Bulk insert generated the error: Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row...