Hi,
I need to find a specific string in one big text file and save it to a new file.
Below are the sample of the text.
1.0 abc
1.5 def
2.8 abd
2.7 bfv
2.9 bbg
2.0 bbh
2.2 ffg
2.1 ddf
3.4 jjj
3.2 hhh
3.9 lll
4.5 kkk
What I need to do;
All strings that start with 1.XXX will be saved as 001.txt
All strings that start with 2.XXX will be saved as 002.txt
All strings that start with 3.XXX will be saved as 003.txt
...
Pls advise on how to create the macro.
Thanks,
I need to find a specific string in one big text file and save it to a new file.
Below are the sample of the text.
1.0 abc
1.5 def
2.8 abd
2.7 bfv
2.9 bbg
2.0 bbh
2.2 ffg
2.1 ddf
3.4 jjj
3.2 hhh
3.9 lll
4.5 kkk
What I need to do;
All strings that start with 1.XXX will be saved as 001.txt
All strings that start with 2.XXX will be saved as 002.txt
All strings that start with 3.XXX will be saved as 003.txt
...
Pls advise on how to create the macro.
Thanks,