We are currently working on the forum. For the short-term, all forum content will be in read-only format. We apologize for the interruption and look forward to collaborating with you shortly. All the best in your research!

CRF Design excel sheet- Response_Values_OR_Calculation field

Dear Community,

I have around 2000 fields, which has to be uploaded to Openclinica, and the text contains lots of commas,
ex: | 3, 0380185 YENTREVE GELUL. 20 MG 1*56 GELULES R 1 5 44,80 46,98 56,06 80 | 4, 0380204 YENTREVE GELUL.

My question is can I change the delimiter in Response_Values_OR_Calculation field to someother special character say '&' instead of comma.
if yes, How to go about it?.

Thank you in Advance



  • KavitaRegeKavitaRege Posts: 27
    Returning back with same issue, It is possible to change the delimiter character?
  • kristiakkristiak Posts: 1,340 ✭✭✭
    via Email
    Are you referring to the comma in the "Response Options Text", then the answer is no!

  • KavitaRegeKavitaRege Posts: 27
    :( Yeah, I was referring to commas in "Response Options Text". As mentioned before, I have 2k+ fields and have Questions with many options, texts etc containing commas, I wanted to know, if it is possible. Thanks Anyway.
  • toskriptoskrip Posts: 279 ✭✭✭

    maybe not helpful but if you do want to render commas in your Response Option Text you can use \\,

    Than every comma prefixed with \\ will be rendered and every other comma considered to be a delimiter character.

Sign In or Register to comment.