CONCAT problem/question

This topic has 3 replies, 3 voices, and was last updated 16 years, 6 months ago by Mike Wilson.

Creator

Topic
June 23, 2008 at 2:30 pm #50120
Mike Wilson
Participant
When I combine multiple fields using the concat function it seperates them with a ^. Is there any way to remove this so the field is seen as just one sentence?

Example of problem:

OBX|5|NM|^DiastolicPressure^^68^mmHg^—||||||||F

Wanted output:

OBX|5|NM|DiastolicPressure 68 mmHg—||||||||F

Thanks for any help you can provide!
Creator

Topic

Viewing 2 reply threads

Author

Replies
- June 23, 2008 at 5:15 pm #64946
  John Hamilton
  Participant
  One way of many.
  
  add .[0] to your destination.
  
  0(0).OBR(0).#3.[0].
- June 23, 2008 at 5:44 pm #64947
  Jim Kosloskey
  Participant
  Mike,
  
  Do you have a separator specified in the CONCAT?
  
  email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.
- June 23, 2008 at 6:18 pm #64948
  Mike Wilson
  Participant
  Guys, Adding the .[0] to the destination did get rid of the ^ symbols. However it then jumbled them into a run on of words with no spaces.
  
  Jim, To answer your question I did not have a seperator. But by adding a space as my seperator it made everything appear the way I was hoping.
  
  Thanks for all of the help everyone.
Author

Replies

Viewing 2 reply threads

The forum ‘Cloverleaf’ is closed to new topics and replies.