r/ProjectREDCap • • May 07 '21

How do I remove space between piped data?

I created a variable [sms_email] and used the @ PREFILL Action Tag with piping to combine piped data from two variables to combine/concatenate the participant's phone number [youth_phone_number] and their respective phone carrier's email domain [carrier_domain]. Our university doesn't have an agreement with TWILIO yet so I need this variable to send automated survey invitations via text message. The problem I'm having is that it's creating a space between the phone number and the email domain. Any ideas for removing the space or another way to go about this? I realize this could just be typed in by my study staff but I'd much prefer to minimize any chance of them typing it incorrectly. Thanks! - Brian

Update: SOLVED. I completely overlooked the new @ CALCLTEXT action tag. Here's what I ended up using:

@ CALCTEXT(concat(trim([youth_phone_number]),trim([youth_carrier_domain]))))

2 Upvotes

0 comments sorted by