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 TouchToneTommy 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. smmedeiros

    Removing or replacing IP address from text field

    Formula 2 is working! Thank you for all the guidance and instructions. Have a great holiday weekend! (I know I can now that I can deliver my reports!) :-) Appreciate all the guidance and patience.
  2. smmedeiros

    Removing or replacing IP address from text field

    I think I originally misread your question. The field has a limit of 4000 characters. Within the field, this IP address I'm trying to redact can be multiple showings. I've seen up to 8 occurrences so far. I wasn't sure if it's the loop within the field itself or the volume of the data I was...
  3. smmedeiros

    Removing or replacing IP address from text field

    LB - I ran your suggestion in a small sampling and it was perfect. Running it against my full collection of ticket extracts, I'm running into this error "A loop was evaluated more than the maximum number of times allowed" Any suggestions?
  4. smmedeiros

    Removing or replacing IP address from text field

    LBASS OMG. THANK YOU..THANK YOU..THANK YOU. You’re a GENIOUS! working as suggested above. You have saved me hours’ worth of manual data scrubbing! HUGE “Thank You”!
  5. smmedeiros

    Removing or replacing IP address from text field

    lbass - yes, an IP address will allows contain multiple "." whereas any other numeric value may contain a single 'dot' such as dollar amount or perhaps end of sentence ie - $1500.37 or "My account balance is 197.60." (not allows in proper $ format) yes - my data is ugly!
  6. smmedeiros

    Removing or replacing IP address from text field

    Thank you lbass for the idea. To answer your question, yes, more often than not there will be other numeric values in the field.
  7. smmedeiros

    Removing or replacing IP address from text field

    Has anyone been successful with removing an IP address from a text field of varying size with the IP address itself being of varying formats For example. line1 line2 some type of text information 11.1.111.1 line3 line4 desired output line1 line2 some type of text information xx.x.xxx.x line3...
  8. smmedeiros

    Conditional Row Suppression

    Thank you for the nudge pmax9999 - unfortunately, I was redirected on a different priority and have not had a chance to try the suggested solution. When I do, I will update accordingly.
  9. smmedeiros

    Conditional Row Suppression

    Appreciate any ideas or guidance. I want to conditionally suppress rows based on current record compared to previous or next record. Whatever is easiest. Explored several write-ups using next and previous and can't seem to get this working. My sample data is attached. I have 2 columns, server...
  10. smmedeiros

    Reading UP and Down and how to surpress unwanted rows

    Your the best. Just had a chance to walk through the recommendation. Brilliant. I have worked sub-reports in the past and completely escaped me to even try that option. Thanks so much for the help.
  11. smmedeiros

    Reading UP and Down and how to surpress unwanted rows

    Help or Ideas - please I reach configuration items and trying to create a customer report where I can display the relationships. I have a PRIMARY CI (i'll call it CI Search) I'm trying to display all the associations. dependant & provider I have 3 examples (attachment shows content) 1st...
  12. smmedeiros

    Cross Tab and Grouping

    Thank you both for your suggestions. Gordon - got your idea working. Only problem left would be the ability to have column headings. I have content in the row section, and content in the summarize section. Nothing in the column. Any thoughts on how I can get labels in place for the 4 new...
  13. smmedeiros

    Cross Tab and Grouping

    I'm working on a cross tab report where i have 4 variables I've placed in a crosstab Manager Name Door Access Flag in the row section Manager Name in the column section Door in the summarized Section Mode of Access Flag The results are what I expect, simple table showing Manager --> name...
  14. smmedeiros

    Business Ojbects Central Management Console - dynamically addressing based on report data results

    Looking for guidance (or confirmation if this is possible) I'm using Crystal Reports 2008. I have a report that provides me inflight change tickets with the association of the group in which it has a pending workflow. I want to be able to schedule the report for daily execution via Business...
  15. smmedeiros

    Date Differences - multiple dates, with blank values

    Thank You Deniall! Appreciate the help.
  16. smmedeiros

    Date Differences - multiple dates, with blank values

    Looing for help. Not good with nested statements. i have 3 date values active decom today() need formula to calculate date difference if active populate and decom blank, date value is today()-active if active populated and decom populated, date value is decom-active if active = blank and...
  17. smmedeiros

    Use of multiple accum/display/reset fields

    Thank You Very Much! Appreciate the help!
  18. smmedeiros

    Use of multiple accum/display/reset fields

    Thank You Charliy - worked great as you have described. I made a slight modification to have 2 independant columns one for dependant and one for provider, also removing reference to the server name. my only remaining item is, how to i remove the comma that is showing up as the first charater...
  19. smmedeiros

    Use of multiple accum/display/reset fields

    Charliy - Thank you for this idea. Can you offer a sample on how to do this?

Part and Inventory Search

Back
Top