Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 7173 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

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

Posted

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]

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.