Click here to Skip to main content
15,445,757 members
Home / Discussions / Database
   

Database

 
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
MemberRedDk5-Oct-21 8:11 
This might or might not help ... check what happens using Excel or Access and their X-referencing/inter-app-transferring abilities on specific data table (as .txt; I'm assuming you can morph tables by exporting them with whatever tool you're currently sleuthing the inputs and outputs).

In Excel or Access, generally speaking, parsing data using what Microsoft terms a "delimiter" and those various options of which you speak, can often run afoul of it's own preaching (doc code won't run as-printed) ... in which case deploying UDF using the copious functionality of VBA most times does the trick. A favorite workaround of mine is to use Split and InStr, along with Find and Search although logic there becomes draconian quickly.

It sounds like you're in the testing stages anyway.

[Pleaso oh please ... have Excel andor Access]

Final addition: Search Stack Overflow.
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
Memberremiki13-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
Memberremiki13-Sep-21 6:02 
AnswerRe: WHERE NOT EXIST QUERRY Pin
0x01AA6-Jan-22 9:39
professional0x01AA6-Jan-22 9:39 
QuestionDatabase programming Pin
Member 153534049-Sep-21 23:54
MemberMember 153534049-Sep-21 23:54 
AnswerRe: Database programming Pin
Richard MacCutchan10-Sep-21 0:27
mveRichard MacCutchan10-Sep-21 0:27 
QuestionHow to design sql db for storing Name/Value objects with unknown value type (EF Core 5 as ORM)? Pin
Member 146377867-Sep-21 0:43
MemberMember 146377867-Sep-21 0:43 
Rant[REPOST] How to design sql db for storing Name/Value objects with unknown value type (EF Core 5 as ORM)? Pin
Richard Deeming7-Sep-21 1:00
mveRichard Deeming7-Sep-21 1:00 
QuestionWhy not to use NoSQL instead of RMDBS? (not Mongo) Pin
Hopeless Idealist14-Aug-21 1:21
MemberHopeless Idealist14-Aug-21 1:21 
AnswerRe: Why not to use NoSQL instead of RMDBS? (not Mongo) Pin
Mycroft Holmes14-Aug-21 12:36
professionalMycroft Holmes14-Aug-21 12:36 
AnswerRe: Why not to use NoSQL instead of RMDBS? (not Mongo) Pin
jschell5-Sep-21 9:07
Memberjschell5-Sep-21 9:07 
QuestionSql query , comparing a table field to a list of values , condition (MS SQL) Pin
zira178929-Jul-21 15:32
Memberzira178929-Jul-21 15:32 
AnswerRe: Sql query , comparing a table field to a list of values , condition (MS SQL) Pin
Richard MacCutchan29-Jul-21 21:15
mveRichard MacCutchan29-Jul-21 21:15 
AnswerRe: Sql query , comparing a table field to a list of values , condition (MS SQL) Pin
Anand RB 20218-Aug-21 18:16
MemberAnand RB 20218-Aug-21 18:16 
GeneralRe: Sql query , comparing a table field to a list of values , condition (MS SQL) Pin
CHill609-Aug-21 23:23
mveCHill609-Aug-21 23:23 
AnswerRe: Sql query , comparing a table field to a list of values , condition (MS SQL) Pin
RedDk10-Aug-21 7:57
MemberRedDk10-Aug-21 7:57 

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.