how to split string and convert according to database

Question

0.00/5 (No votes)

See more:

I want to split ABCDE0060GHIJKL037Mxxx convert this string into the following format according to database value

The formatted String code is
ABCDE 0060 GHIJ KL 037 XXX

condition is
1) It checks whether ABCDE is store in database or not if present then change that ABCDE to XXXXX same for remaining string.

Posted 29-Dec-14 22:01pm

Member 11270220

Updated 29-Dec-14 22:02pm

v2

Add a Solution

Comments

Arjsrya 30-Dec-14 4:14am

few doubts - how many characters will be there? is it constant?

Member 11270220 30-Dec-14 4:15am

no string length will be 15 or more.....I want to convert that string according to users input.....

OriginalGriff 30-Dec-14 4:23am

And?
What have you tried?
Where are you stuck?
What language are you using?
What help do you need?

Praveen Kumar Upadhyay 30-Dec-14 4:25am

So it's like split first 5 character then 4,4,2,3 and 3 character??

Member 11270220 30-Dec-14 4:25am

not tried anything but confused from where to start and how this will happen....want guidance for converting that type of string according to database value

Arjsrya 30-Dec-14 4:29am

It might be dynamic right? you are splitting the string based on some condition.My doubt is like Need to split 5 then 4 or 4.This is how you are spliting?

Member 11270220 30-Dec-14 4:31am

using substring

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)

Amresh Bahadur Singh · Answer 1 · 2014-12-30T00:16:00

Solution 1

you can use Substring Like this ..

C#

str = "ABCDE 0060 GHIJ KL 037 XXX ";
       retString = str.Substring(0, 5);

Posted 30-Dec-14 0:16am

Amresh Bahadur Singh

Comments

Member 11270220 30-Dec-14 6:18am

ya used but now want to check ABCDE and 0060 substring value with database value....how to do that

Amresh Bahadur Singh 30-Dec-14 6:25am

after that you can pass these values in Store procedure and check condition using like keyword

Member 11270220 30-Dec-14 6:26am

but keywords are more than 100 then how to do that??

Amresh Bahadur Singh 30-Dec-14 6:30am

your The formatted String code length is fix or not ?

Member 11270220 30-Dec-14 6:30am

formatted string code length is 12

Amresh Bahadur Singh 30-Dec-14 6:38am

ok, if more then one keywords are possible then you get any other column which have unique records .