Jump to content
Sign in to follow this  
rm-tfm

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.

Thanks

-rob

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.