Dim String, and divide/split into parts

Hello experts,

I have a string, and I need to split it into parts, and each part will represent different things, the parts will be seperated by either "." or "_", for example:

TOPOLOGY.WC.39.214S.138.DICKSON_DAM1

How do I dim it as a string with 7 parts. Or dim it as a whole and split it into 7 parts, then define the parts like ID=part(3), NAME=part(1) etc...


Thank you for your help in advance
Hallet

Thank you so mych lmvk99!
Appreciate your help!

Hello Experts,


So I haven't actually tried the code yet, but I don't really understand the "a6" part.
And I ran into a bit of a roadblock, more like a special case. So in the same string "TOPOLOGY.WC.39.214S.138.DICKSON_DAM1", there are 6 parts:
part1:TOPOLOGY
part2:WC
part3:39
part4:214S
part5:138
part6:DICKSON

since I am using "." as a divider, everything works fine.
However part 5 can be a decimal value, for example "TOPOLOGY.WE.30.62S.13.8.BRAZEAU_HYDRO2",
In this case part 5 has the value "13.8", so it would have 7 parts instead of 6.
I was thinking to counter this I can split it into 7 parts first, and check if part 7 is empty or not, but have no idea how to put that into code language as I am very new to VBA
And also I need a way to trim whatever is after the underscore including the underscore, "_HYDRO2" is useless for example, so is "_DAM1"



Thanks in advance
Hallet

HI Imvk99,
thank you so much for responding in such detail.
Here's the actual file with the strings
EMS_MODEL1.xlsx
However the number of rows of data will vary, since this is only part of the actual file, so I probably will need a Do Until IsEmpty, and I just need to split the parts, and give each part a variable name.
So would you please modify your code for me? =)


Appreciate your help!

Hallet

I think I got it now, sorry about the confusion, what I meant was I just want to give a name for each part like your very first post did, "part1, part2, etc..."

Thanks so much