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.
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...
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?
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”!
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!
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...
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.
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...
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.
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.