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,296 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;)
Sai Raghunadh M 1,760 Reputation points Microsoft Vendor

2024-12-30T02:44:10.09+00:00

Hi Vineet S

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
LiHongMSFT-4306 29,906 Reputation points

2024-12-30T03:40:54.2066667+00:00

Hi @Vineet S

For this type of question, you help yourself a lot if you post CREATE TABLE statements for your tables, preferably simplified to focus on the actual problem, together with INSERT statements with sample data and the desired result of the given sample.

Your answer