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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    Lee Smith 
×
×
  • Create New...

Important Information

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