Let's say there is data with one delimiter vbCrlf :
it's easy to split this data using code like this:Code:Jack Jhon James George
But, how i can I split the data that has two delimiters: vbCrlf & Space? Something like this:Code:entry= Split(data, , vbCrLf, vbBinaryCompare)
This example contans "space" and "new line", how can I split them?Code:010203 Jack 909090 Jhon 304050 James 506070 George
Thanks




Reply With Quote