Solved

Vb.net Split , string with numbers (1,000) creates aditional fields  problem

Posted on 2009-04-07
1
255 Views
Last Modified: 2012-05-06
HI,

Im trying to split a string that is coma delimited but also contains numbers formated as 1,000
this is then split into two fields when it should be just one. Is there anything that can be done about this ?

Michal
0
Comment
Question by:MichMat
1 Comment
 
LVL 15

Accepted Solution

by:
David L. Hansen earned 500 total points
Comment Utility
Yes, if there is a way of detecting the delimiting commas from the others (the ones given as an association to currency).  Perhaps there is a space or other patterns which can be of use.  See below for an example...

1,000, 2,000, Joe Miller, 4,000.99

You see the space the follows each delimiting comma reveals it.  If however there is no way to make the distinction, no pattern from which you can deduce the two, there is nothing to be done I'm afraid :)

Per chance you do find such a pattern, change the dilimiting commas to somthing else (a tilda ~ or pipe | will do) then use the split command on that.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now