| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Split with consecutive delimiters
I am reading lines from a formatted data file (values in right justified
columns) and using split to extract the values from each line into an array. The problem is the number of spaces between values is not constant, and split adds a new array value for every space it finds in the text string. Is there a way to set split to treat consecutive spaces as a single delimiter like you can in TextToColumns? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Delimiters | New Users to Excel | |||
| Multiple Delimiters | Excel Discussion (Misc queries) | |||
| Consecutive date range on consecutive worksheets | Excel Worksheet Functions | |||
| delimiters and manipulation | Excel Worksheet Functions | |||
| How Do I Modify Pearson's Code to Add "Treat Consecutive Delimiters As One"? | Excel Programming | |||
Threaded Mode
