coma delimeter

Vineet S 1,350

Hi,

have to insert data after coma there are sentences where coma is there one column also so needs to neglect that

create table table1

(id varchar (50) ,details varchar (50))

notepad file1 contains - 6 months,ABDOddssdAL FIsdsdsdsA,sdsdsdsd,

here 6 months -- col1 and ABDOddssdAL FIsdsdsdsA,sdsdsdsd col2

Yitzhak Khabinsky 26,206 Reputation points

2024-12-27T16:09:49.9066667+00:00

While asking a question you need to provide a minimal reproducible example:

(1) DDL and sample data population, i.e. CREATE table(s) plus INSERT, T-SQL statements.

(2) What you need to do, i.e. logic, and your attempt implementation of it in T-SQL.

(3) Desired output based on the sample data in the #1 above.

(4) Your SQL Server version (SELECT @@version;)

Your answer