Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Crystal Report Remove String

General Discussion

Last Post by lhess 4 years ago

6 Posts

2 Users

0 Reactions

89 Views

RSS

mvolkert

(@mvolkert)

Posts: 143

Reputable Member

Topic starter

I am looking for a way to remove only a portion of a string in a crystal report. The portion I want removed will always start with "EZAccess" and always end with either "AM" or "PM" but what's between that will be different every time. I want to remove everything between the "EZAccess" and "AM/PM" but leave the rest of the string intact. I've tried several different variations of the "REPLACE" function and have not been successful. Any help would be greatly appreciated. Thank you!

Posted : November 18, 2020 4:27 am

lhess

(@lhess)

Posts: 27

Eminent Member

This worked for me. First remove the last 2 characters of the string, then replace EZaccess with blanks:

Replace (Left ({mystring},len({mystring})-2),"EZaccess" ,"" )

Posted : November 18, 2020 5:29 am

mvolkert

(@mvolkert)

Posts: 143

Reputable Member

Topic starter

Thank you for your response Laura. This partly worked for me by only removing the beginning of the string I'm looking to remove. I will list an example below of what I'm trying to accomplish.

"EZAccess - Appt Confirmed on 11/16/2020 10:13 AM"

I want to remove everything in this portion of the string but the bolded section will not be the same every time. Is it possible to have the formula look for "EZAccess" and "M" and remove everything in between as well. Thank you!

Posted : November 18, 2020 5:38 am

lhess

(@lhess)

Posts: 27

Eminent Member

The above command should have worked. Is the AM/PM always at the very end of the string? Breaking down the formula:

len({mystring})-2 counts the length of the string & subtracts 2, i.e. 48-2=46 using your string

Left ({mystring},len({mystring})-2) starting from the left of the string, keep 46 characters

Replace (Left ({mystring},len({mystring})-2),"EZaccess" ,"" ) in remaining string, replace EZaccess with blanks

Posted : November 18, 2020 10:17 am

mvolkert

(@mvolkert)

Posts: 143

Reputable Member

Topic starter

I'm sorry, I don't think I'm explaining what I'm trying to do very well. That code worked but only removed the string "EZAccess" and the "AM/PM". I am wanting to remove the whole string from "EZAccess" to "AM/PM". Below is an example of an entire appointment note. I am wanting to remove the portions that say "EZAccess....AM/PM" (crossed out text) but keep everything else.

WC Ultrasound Injection. Ref from HSE. Left Shoulder DOI 08/30/2020. CF LEawood. 11/5 bam
EZAccess - Reminder Sent on 11/16/2020 12:01 AM
EZAccess - Appt Confirmed on 11/16/2020 9:23 AM CA!

Posted : November 19, 2020 5:02 am

lhess

(@lhess)

Posts: 27

Eminent Member

Ah, I misunderstood what you were trying to do.... I don't know how to reformat the string the way you need it.

Posted : November 24, 2020 7:02 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
1 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0