Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
splitting strings
I have multiple strings like the following... "ITEM 1000 20 X4" I want to split the string into an array. So I did the following... tmp = split(line) Now this is the array data... tmp[0] = "ITEM" tmp[1] = " " tmp[2] = " " tmp[3] = "100" tmp[4] = " " ...and so on. I want to get rid of the blank array points; tmp[1], tmp[2], tmp[4 such that the array will read like this... tmp[0] = "ITEM" tmp[1] = "100" tmp[2] = "20" ...and so on. Is there a way to split strings on "white space". I only ask becaus the strings I will be digesting are of variable length. I can program do-while-loop to count the number of blank entries and work around, bu I figured there had to be an easier way to do that. THANKS TONS -Tod -- tad_wegne ----------------------------------------------------------------------- tad_wegner's Profile: http://www.excelforum.com/member.php...fo&userid=2777 View this thread: http://www.excelforum.com/showthread.php?threadid=53661 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find and replace numeric strings in larger text strings | Excel Worksheet Functions | |||
String splitting for inconsistent strings | Excel Worksheet Functions | |||
Splitting Text strings in one cell | Excel Discussion (Misc queries) | |||
Splitting text strings along commas. | Excel Discussion (Misc queries) | |||
splitting number strings in excel | Excel Worksheet Functions |