Jump to content
Sign in to follow this  

formatting export data

Recommended Posts

Hey all,

I tried to search around, but wasn't entirely sure how to phrase it.

Basically I'm running a db with close to 2k clients. I need to export their URL's to a simple list (1/line) for use with Xenu link checker.

I have it working, only I need to do some sanity checks on the URL field first -- e.g. if there is no leading http://, add it - or split multiple URLs at the ;

My main concern is the prefixing 'http://' while using the Export command.

thinking its something along these lines, but need it for _all_ records. Best solution would be to not alter the actual record, just prefix before the export.

If ( Lower ( Left ( Clients::URL; 3 ) ) = "www";

Clients::URL = "http://" & Clients::URL;



[Export Records cmd here]


any help is much appreciated.



Share this post

Link to post
Share on other sites

Just add a calc field to build the correct URL. Then export that. The calc won't modify the existing data at all.

Share this post

Link to post
Share on other sites

I had thought about doing that yesterday but was wondering if there was another way around it.

Not a huge deal, I'll build out the calc field :

Thanks Ender.

Share this post

Link to post
Share on other sites

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
Sign in to follow this  


Important Information

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