Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
little_devil
Starting Member
1 Post |
 Posted - 2002-05-07 : 12:07:05
|
| How would I split this data?I have data in the form of:EN0ELA English Language and Study Skills A A 10EN0ELB English Language and Study Skills B S 10LK45FA Inter Faculty French 5a A 10LK45FB Inter Faculty French 5b S 10LKA2FA Inter Faculty French 2a A 10LKA2FB Inter Faculty French 2b S 10LKA2GA Inter Faculty German 2a A 10I am able to remove the first 6 characters which are the module code, but I now need to remove the module title, the semester (A, S, B, F), and the module credits (multiples of 5 upto 120). The file is in text format and is single space seperated. I was told to use the IIf rule but have found this un useful. If you can help me I would be very grateful. Thank you. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-05-07 : 13:28:05
|
| Why does this sound like a homework question? If it is, I'm sorry, but we don't answer homework or exam questions because you won't learn anything. And I'm extremely skeptical that this file is not part of a homework assignment, because nobody is stupid enough to export data in that format and expect someone else to import it successfully. |
 |
|
|
|
|
|
splitting fields