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 |
|
rohit.kumar.barik
Starting Member
4 Posts |
 Posted - 2013-08-22 : 05:47:27
|
| I need to implement below scenario in SSIS 2008I am getting values like below.EN 60320.V.1EN 61000-4-1EN 294EN ISO 3506-1EN 61400-25-6Need output as6032061000294350661400 |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2013-08-27 : 12:06:49
|
| 1st establish rules for where the number is within a string.i.ea) always after at least 1 space (or whatever)b) always ends with something other than 0-9...i.e comma, dash, a-z, dot, etcc) other rules as necessary2nd - code the rules. experiment around the edge cases - scientific numbers, decimal places etc...you'll need to use the some search and replace techniques. experiment and post your example code here and poeple will help you imrpvoe it. |
 |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2013-08-27 : 23:17:40
|
| parsing will always come to bite you, 100%. something will come in one day that will mess you up. is there any way you can ask the provider of these values to standardize them? is there any predictable pattern in these values, whatever industry they are from.<><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
|
|
|
|
Fetch numeric values from string in SSIS