Since I'm new to VBA, I having trouble parsing text in excel I have attached a sheet where I bring it over into excel in the ERR Sheet and I want to sort it like the WO sheet. Any help will be appreicated. Thanks
Since I'm new to VBA, I having trouble parsing text in excel I have attached a sheet where I bring it over into excel in the ERR Sheet and I want to sort it like the WO sheet. Any help will be appreicated. Thanks
I am struggling to see how to work out what goes in column B.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
And what goes in Col. D. "Equip ID" and where does it come from? I didn't notice any data for that field among your sample records.
Ron
Windermere, FL
Yes, that's hard to figure out becasue there is really no rhyme or reason. If it get populated then there is something
Equipment ID gets populated only if there is something in that field in another program. In this example there is nothing. Maybe if i can get a start then I might be able to figure it out if and when it get populated.
If that is the case, you have asolutely no chance of writing code to do it. Code needs both a rhyme and a reason, we don't do AI in VBA.Originally Posted by zrupnick
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
How does the report get created that you want to import into an Excel worksheet? Can you (or can the person who prints it for you) cause the report program to print a "separator" character between fields? (Some character, like the pipe symbol ("|").)Originally Posted by zrupnick
How did you determine the data for Column B when you created the "sample" target "WO" worksheet? Knowing this may help us help you outline 'rhyme and reason.'
Thanks,
Ron McKenzie
Windermere, FL
(living in the huge shadow of a tiny rodent)
Here is a copy of how the text file looks before I bring it over into excel. It is a text file, I just copied it to word for now. It seems that the first 9 or 10 charactors in the second line determine the location. I don't know if thsi helps. Maybe something with out the location for now until I can make sure it's they imput it with a special charactor like a / or somthing. Again thanks for all the help.
Last edited by zrupnick; 07-06-2010 at 01:36 PM. Reason: Did not attach text.