Welcome to the nuBuilder forums!

Please register and login to view forums and other content only available to registered users.

Space being stripped.

Post Reply
russhart
Posts: 2
Joined: Mon May 02, 2016 12:19 am

Space being stripped.

Unread post by russhart »

Hi, just found nuBuilder and like the program.
I am trying to get two fields to display as one in the browse form using CONCAT_WS(' ', field1, field2) in the 'Display' column so it displays as field1 field2. If i run it shown it displays field1 only. If I don't leave the space between the quotes I get field1field2. If I replace the space with an underscore the result I get is field1_field2 so somewhere in the code for the browse form it is stripping out that space. Using the same code on a form results in the correct display.
Can anyone help?
admin
Site Admin
Posts: 2781
Joined: Mon Jun 15, 2009 2:23 am
nuBuilder Version: 4.5
Been thanked: 1 time

Re: Space being stripped.

Unread post by admin »

russhart,

Try making the column wider, it might be going on to a new line.

Steven
russhart
Posts: 2
Joined: Mon May 02, 2016 12:19 am

Re: Space being stripped.

Unread post by russhart »

Yes that was it. I had already made the column wider, but mustn't have rechecked it with just the space. As I said before, only just found this and still learning.
Thanks for the reply.
admin
Site Admin
Posts: 2781
Joined: Mon Jun 15, 2009 2:23 am
nuBuilder Version: 4.5
Been thanked: 1 time

Re: Space being stripped.

Unread post by admin »

.
Post Reply