Need to get data from it

Question

1.00/5 (2 votes)

See more:

, +

Below is the column data that has data in it.

{"",11750,"","","","","","","","","","","","","","","","","","","","","","",""}

{'2021-11-04','0001-01-01','0001-01-01','0001-01-01','0001-01-01','0001-01-01','0001-01-01','0001-01-01','0001-01-01','0001-01-01','0001-01-01','0001-01-01','0001-01-01','0001-01-01','0001-01-01','0001-01-01','0001-01-01','0001-01-01','0001-01-01','0001-01-01','0001-01-01','0001-01-01','0001-01-01','0001-01-01','0001-01-01'}

Like this above 2 columns

What I have tried:

I have not yet tried any thing for it. Can you please help me to extract data from that.

Posted 8-Jan-24 5:38am

Member 11776570

Add a Solution

Comments

0x01AA 8-Jan-24 11:46am

No idea, what the problem is and what you would like to do and what the question is :(

Member 11776570 8-Jan-24 11:55am

I need to get those numeric values from the whole single data column. Like below if we have values like this {52000,5523,"",9965,4556,55236,"","","","","","","","","","","","","","","","","","",""}
It should get me only those number in column format. means separate records for each numeric value.

Richard MacCutchan 8-Jan-24 12:07pm

You have not provided anywhere near enough information about your problem. What is this data, where does it come from, what are you trying to do with it, what have you already tried, etc? Please use the Improve question link above, and add complete details of what is not working.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2024-01-08T06:08:00

Don't do that. Don't store CSV data in a single column, it's wasteful, inefficient, and leaves you with nasty problems whenever you want to use the data or change it. SQL string handling is ... um ... poor, so you have to jump through a lot of hoops to use CSV data at all, let alone well.

I'm not saying it can't be done - it can: Converting comma separated data in a column to rows for selection[^] - but it's really not a good idea, even if doing it properly seems like a lot of up-front work to get the data into a "proper" table.
The "right way" will save you loads of time later!