Skip to Content
0
Former Member
Jun 29, 2015 at 09:10 PM

Replace() function multiple times on Promptsummary()

260 Views

Hi, I would want to use replace() function at once to

1) remove comma(,) from year 2,013 as Replace(PromptSummary();",";"")

2) replace *** Query Name:Query ***" with "Prompt Parameters:" as replace(promptsummary();"*** Query Name:Query ***";"Prompt Parameters:")

3) replace (optional) with ""

etc.

I have these separate working okay but how do I have all three together in a single statement. I did not want to use UserResponse() function in the report.

Tried =Replace(PromptSummary();",";"") and replace(promptsummary();"*** Query Name:Query ***";"Prompt Parameters:") with AND but no luck i know this is a wrong SQL.

I would appreciate your help on this

Thanks, Kris