Conversion / Format help

[sierra467]

I have 2 questions that I think maybe similar.

First Question
When building a Select query through query builder, is there a function or a way I can convert the field, fldWebSite, which is of the datatype Hyperlink to text? The problem I am having is that when I export the results to a csv or txt file, the field instead of saying "www.website.com" turns into "www.website.com#http://www.website.com#"

Second Question
When building a Select query through query builder, How do I convert a field that is of the type currency into a fixed 2 dec. number? Inother words, I get "$1,234,567.00" when what I really want is "1234567.00".

 

[RuralGuy]

The answer to both questions is to create another field in the query that has just the data you require.

Question1:
NewField1:Left([HyperLinkField], InStr(1, [HyperLinkField], "#") - 1)

Question2:
NewField2:Format([CurrencyField], "###########0.00")

Replace the Bold names with your Field Names in the query builder and try it.