Click here to Skip to main content
15,867,453 members
Home / Discussions / Database
   

Database

 
AnswerRe: Need Help with this SQL Statement Pin
Richard Deeming5-Oct-21 21:48
mveRichard Deeming5-Oct-21 21:48 
GeneralRe: Need Help with this SQL Statement Pin
crmfghtr6-Oct-21 2:37
crmfghtr6-Oct-21 2:37 
GeneralRe: Need Help with this SQL Statement Pin
Richard Deeming6-Oct-21 3:36
mveRichard Deeming6-Oct-21 3:36 
GeneralRe: Need Help with this SQL Statement Pin
Eddy Vluggen8-Oct-21 15:23
professionalEddy Vluggen8-Oct-21 15:23 
General[Resolved] Re: Need Help with this SQL Statement Pin
crmfghtr10-Oct-21 16:18
crmfghtr10-Oct-21 16:18 
QuestionImport CSV Problems Pin
Jörgen Andersson3-Oct-21 21:32
professionalJörgen Andersson3-Oct-21 21:32 
AnswerRe: Import CSV Problems Pin
Mycroft Holmes4-Oct-21 12:12
professionalMycroft Holmes4-Oct-21 12:12 
GeneralRe: Import CSV Problems Pin
Jörgen Andersson4-Oct-21 20:24
professionalJörgen Andersson4-Oct-21 20:24 
I thought the purpose of the text qualifier is to tell the parser that the following chunk of text is in one field despite containing a column delimiter

Anyway, If I don't use a text qualifier, it behaves exactly the same, except that the preview now shows the same as the data in the tables.

The data our supplier sends looks like this:
¦Column1¦;¦Column2¦;¦Column3¦;¦Column4¦
¦Text¦;¦Some other text¦;¦Text¦;¦Also text¦
¦¦;¦More text¦;¦Text with a ; embedded¦;¦¦
¦etc.¦;¦etc.¦;¦etc.¦;¦...¦

What I want in the database is this:
Column1                 Column2                 Column3                 Column4             
Text                    Some other text         Text                    Also text
                        More text               Text with a ; embedded
etc.                    etc.                    etc.                    ...


What I get is this:
Column1                 ;Column2                Column3                 Column4
¦Text¦                  ¦Some other text¦       ¦Text¦                  ¦Also text¦
¦¦                      ¦More text¦             ¦Text with a             embedded¦;¦¦
¦etc.¦                  ¦etc.¦                  ¦etc.¦                  ¦...¦

Wrong is evil and must be defeated. - Jeff Ello

AnswerRe: Import CSV Problems Pin
CHill604-Oct-21 21:04
mveCHill604-Oct-21 21:04 
GeneralRe: Import CSV Problems Pin
Jörgen Andersson4-Oct-21 21:13
professionalJörgen Andersson4-Oct-21 21:13 
GeneralRe: Import CSV Problems Pin
CHill604-Oct-21 21:34
mveCHill604-Oct-21 21:34 
GeneralRe: Import CSV Problems Pin
Jörgen Andersson4-Oct-21 21:43
professionalJörgen Andersson4-Oct-21 21:43 
GeneralRe: Import CSV Problems Pin
Jörgen Andersson4-Oct-21 22:04
professionalJörgen Andersson4-Oct-21 22:04 
AnswerRe: Import CSV Problems Pin
Richard Deeming4-Oct-21 22:04
mveRichard Deeming4-Oct-21 22:04 
GeneralRe: Import CSV Problems Pin
Jörgen Andersson4-Oct-21 22:11
professionalJörgen Andersson4-Oct-21 22:11 
GeneralRe: Import CSV Problems Pin
Richard Deeming4-Oct-21 23:12
mveRichard Deeming4-Oct-21 23:12 
GeneralRe: Import CSV Problems Pin
Jörgen Andersson5-Oct-21 1:17
professionalJörgen Andersson5-Oct-21 1:17 
AnswerRe: Import CSV Problems Pin
RedDk5-Oct-21 8:11
RedDk5-Oct-21 8:11 
GeneralRe: Import CSV Problems Pin
Jörgen Andersson5-Oct-21 23:33
professionalJörgen Andersson5-Oct-21 23:33 
QuestionWHERE NOT EXIST QUERRY Pin
remiki13-Sep-21 5:00
remiki13-Sep-21 5:00 
AnswerRe: WHERE NOT EXIST QUERRY Pin
Richard Deeming13-Sep-21 5:58
mveRichard Deeming13-Sep-21 5:58 
AnswerRe: WHERE NOT EXIST QUERRY Pin
remiki13-Sep-21 6:02
remiki13-Sep-21 6:02 
AnswerRe: WHERE NOT EXIST QUERRY Pin
0x01AA6-Jan-22 9:39
mve0x01AA6-Jan-22 9:39 
QuestionDatabase programming Pin
Member 153534049-Sep-21 23:54
Member 153534049-Sep-21 23:54 
AnswerRe: Database programming Pin
Richard MacCutchan10-Sep-21 0:27
mveRichard MacCutchan10-Sep-21 0:27 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.