String manipulation

Question

0.00/5 (No votes)

See more:

Hif guys, i have this assignment where im supposed to extract headstone data from an inscription file(structured text files).From this file im supposed to extract the name of dead person,date of burial,date of birth (or age) and also personal message.The application should analyse a raw file and then extract information and dislay it in tabular form.The raw text file looks like this:in lovin memory of/JOHN SMITH/who died on 13.02.07/at age 40/we will miss him/in loving memory of/JANE AUSTIN/who died on 10.06.98/born 19.12.80/hope you are well in heaven. Basically "/" is a delimiter and a name is always in capital letters.i have tried using String.Split() and substring bt i cant get it to work line by line i can only get the raw data without the delimiter but i dont know how to extract specific information i really need help asap.thanks

Posted 16-Jan-10 9:55am

2gizzo

Add a Solution

3 solutions

Solution 1

What problem are you having specifically? If each line contains the same type of information, then you can just split each line and then split by a right slash. You can always put the strings for each line into their own list. So, you'd have a list of list of strings (that will help you keep things separate). The first string will be the first inscription, the second the name, the third the date of death, and so on. If you are having trouble extracting the date, look into regular expressions, or just use substring to extract the last few characters (the date). Then you can use DateTime.Parse to get the date into a workable format. Let us know what your specific problem is and we can help further.

Posted 16-Jan-10 10:09am

AspDotNetDev

Solution 3

Use Split('/') to get the separate lines, and then for each line, use Split(' ') to break the line up into words.

At that point, you can use the TryParse() method for the desired type to retrieve data. You'll have to do additional coding to determine exactly what data you're getting (to see if an integer is an age, or what the date represents), but it's certainly not hard to do.

Posted 17-Jan-10 3:04am

#realJSOP

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)

Sandeep Mewara · Accepted Answer · 2010-01-17T00:51:00

Looks like you need to split the string two times.

First step would be to split the strings using newline feed.
This would give you a list of all the strings that will be related to one person per item with data delimited by "/"
something like:

// Split the string on line breaks.
// ... The return value from Split is a string[] array.
//
string[] lines = Regex.Split(value, "\r\n");

Now split each item using "/" as delimiter.

// Split string on /.
        // ... This will separate all the words.
        //
        string[] words = s.Split('/');

You will get all the info.