How to remove quotes from export and imported data files in SQL?

Asked By Aditya Derick 30 points N/A Posted on - 11/06/2012

In need of steps on how to remove quotes from export and imported data files in SQL server database table.

• Status: Open
• Question Views: 772
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Server Software

Best Answer by Roth Bridgette

Go To Solution

Answered By parker_carter 0 points N/A #135186

How to remove quotes from export and imported data files in SQL?

Hi Aditya!

You can use these codes to remove the quotes:

"UPDATE TableName SET FieldName = SUBSTRING(FieldName, 2, LEN(FieldName)) WHERE LEFT(FieldName, 1) =’”’;"

                //This removes the left quote

"UPDATE TableName SET FieldName = SUBSTRING(FieldName, 1, LEN(FieldName)-1) WHERE RIGHT (FieldName, 1) =’”’;"

                //This removes the right quote

Or this code:

"UPDATE TableName SET ColumnName = REPLACE(ColumnName,'"','');"

Hope this solves your problem.

About parker_carter

Questions
1

Answers
98

Best Answers
24

• Vote Up 0 Vote Down

• Posted on - 11/08/2012
• Question Category: Server Software

Best Answer

Best Answer

Answered By Roth Bridgette 10 points N/A #135187

How to remove quotes from export and imported data files in SQL?

Hi Aditya Derick,

There are so many ways to  delete First bulk command, Second BCP and  Last export / import wizard.

In Bulk command this command NO  NEED to use a format file your will going to use this when you want to import a data that the first column quotation mark is prefix then the last is suffix.

In the BCP this command follows the default when you executed a SSMS query window.

In Export and Import you NEED to modify to select a file should me imported in GUI. This kind of command so many to me done so that you will come this kind of command.

I have a link to share with, it helps you to guide in all commands.

Thank you. 

Hopefully that link will helps you and answered your question.

This link is to remove unwanted quotation Marks while importing a data.

 

About Roth Bridgette

Questions
1

Answers
41

Best Answers
16

• Vote Up 0 Vote Down

• Posted on - 12/19/2012
• Question Category: Server Software