Newbies pbfmp Posted March 30, 2005 Newbies Posted March 30, 2005 I have a file with 600 records apprx. one of the fields is "emailadress". I want to export these into a textfile, type csv and get it without tab and the "" if the field is empty. I also want a , after each adress (to separate them) so I can just paste it into the mailclient. If ist possible can I just get the "found records" on this export. I have tried to do a script for this but I have failed. Is it possible? A thousand thank you if someone could help me out peter
sbg2 Posted April 4, 2005 Posted April 4, 2005 Enter Find Mode Set Field [emailaddress; ">"""] Perform Find[] Loop GoTo Record [First] If[Get(CurrentRecord) < Get(FoundCount)] --Set Field[g_MyGlobalField; g_MyGlobalField & Quote(emailaddress) & ","] Else --Set Field[g_MyGlobalField; g_MyglobalField & Quote(emailaddress)] -End If GoTo Record [Next] ~ check the exit after last box End Loop Export Field Contents[g_MyGlobalField]
Recommended Posts
This topic is 7173 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now