I need sting coversion help
I have a file "a.txt" which contains say 500 email address in the following format
****************
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
.
.
.
.
.
[email protected]
*****************
I have created a Loop in which i am creating a variable say z, that z should contain concanted emailids (in group of 5) like this
z= [email protected],[email protected],[email protected],[email protected],[email protected]
A smtp component takes this value as CC and sends email
then z has to go back again to "a.txt" and form 5 variable from where it left , so for the next loop
z= [email protected],[email protected],[email protected] and so on...
i will appreciate anybody help
thanks in advance
Help me
Moderators: JRL, Dorian (MJT support)
- Bob Hansen
- Automation Wizard
- Posts: 2475
- Joined: Tue Sep 24, 2002 3:47 am
- Location: Salem, New Hampshire, US
- Contact:
Basically need to count the addresses, divide by 5 and make that a counter value for your loop. Do the loop "count/5 +1" times and you will be done. May need to modify the last run to deal with counts less then 5.
It will be easiest to help if you will provide a sample of the script and point out where it does not work, and what you are seeing as symptoms.
It will be easiest to help if you will provide a sample of the script and point out where it does not work, and what you are seeing as symptoms.
Hope this was helpful..................good luck,
Bob
A humble man and PROUD of it!
Bob
A humble man and PROUD of it!
my code until now
My code until now
******************
Let>EE=
Let>k=1
Label>start
ReadLn>c:\temp\test.txt,k,line
If>line=##EOF##,finish
Concat>EE,LINE
Concat>EE,,
MESSAGE>EE
Let>k=k+1
Goto>start
Label>finish
****************
But this needs improvement, at the moment the code just reads the "test.txt" completely (with "," delimiter) and displays it as Message
What i need is the ability to cut a particularly concated string consisting of say 5 mailids, how to put that?
right now, the program just reads the complete emails present in "test.txt" file
any replies will be appreciated
thanks in advance
******************
Let>EE=
Let>k=1
Label>start
ReadLn>c:\temp\test.txt,k,line
If>line=##EOF##,finish
Concat>EE,LINE
Concat>EE,,
MESSAGE>EE
Let>k=k+1
Goto>start
Label>finish
****************
But this needs improvement, at the moment the code just reads the "test.txt" completely (with "," delimiter) and displays it as Message
What i need is the ability to cut a particularly concated string consisting of say 5 mailids, how to put that?
right now, the program just reads the complete emails present in "test.txt" file
any replies will be appreciated
thanks in advance