Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Goosetown

    Combining Records

    Hello all, First of all I want to thank everyone in this forum. It's the most helpful forum I've ever participated in. Again, thank you so much. I have a field that returns discreet records such as: NEGATIVE POSITIVE INDETERMINATE or 1+ 2+ 3+ 4+ The number of records is not constant nor is...
  2. Goosetown

    Extracting text out of a string

    Thanks Guys!, I used mrudolph's formula and it worked like a charm. I'm on V8.5. Can't thank you guys enough for your help. Goosetown.
  3. Goosetown

    Extracting text out of a string

    Hello, I have a field (normal range) that returns data like this: 1-10 11-20 21-50 and so on and so on. What I'd like to do is to be able to just pull out the value to the right of the '-' so that I'd be left with: 10 20 50 I have been playing with ExtractString but that isn't giving me what...
  4. Goosetown

    Crystal 9.0, Windows XP and a .txt file

    Figured it out. It's not Crystal nor WinXP but it is the format of the date field within the .txt file. When we changed the format to 04/30/04 it worked great. Sorry for the bad post.
  5. Goosetown

    Crystal 9.0, Windows XP and a .txt file

    Whoops, sorry for any confusion but this is happening on Win2000 also. I had my ODBC driver pointing to a wrong field.
  6. Goosetown

    Crystal 9.0, Windows XP and a .txt file

    Hello all, I'm writing a report based upon a '|' delimited text file (.txt). I've defined my ODBC data source and I have defined a field as a date type field. In the .txt file the data looks like '043004'. However, when I use this field on my Crystal report it will not pull anything at all...
  7. Goosetown

    Parsing text into discreet elements in Crystal 9.0

    Thank you Reebo99. That was brilliant. Both formulas worked like a charm. Thanks again!!
  8. Goosetown

    Parsing text into discreet elements in Crystal 9.0

    I need to write a Crystal formula that parses out the text from a field into discreet elements and I'm at my wits end. Basically the output from this field looks like: [G]Good <F>Fair <P>Poor or <1>`1T3 <4>`4T6 <7>`7T10 or [N]None Seen <P>Eos Present I need a formula that will strip...

Part and Inventory Search

Back
Top