Hello,
I have this string that has multiple uneven number of spaces, such as a$=”asdasd utyutyu awer “
I need to extract the 3 non-empty strings t(0)=” asdasd”,t(1)=” utyutyu” and t(2)=” awer”.
I f I use T=split(a$,” “) I get the non-empty strings but also all the spaces as members of the array t.
Any ideas?
Thanks
Have you tried Data: Text To Columns, specifying the space as a delimiter?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
When I use Split(a$, " ") on the string I only get the 3 non-empty strings.
I can only replicate what you describe if I add some extra spaces inbetween the non-empty strings.
If posting code please use code tags, see here.
The double qoutes are wrong.
The standard delimeter of split = " "
Please Login or Register to view this content.
Kind regards, Harry.
Despite that you have little or never responds.
A other solution.
Please Login or Register to view this content.
in yor example do I need to knwo a priori that I have 3 strings? what if I do not know that in the full string I have 3 substrings?
Please Login or Register to view this content.
thanks,
now where is the data? I look at "A1" and there is nothing there. I assume I am missing something, sorry
See example and run code hsv().
Last edited by HSV; 03-29-2013 at 06:28 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks