Page 1 of 1

Concatenate Input fields with string without Spaces

PostPosted: Tue Aug 28, 2018 2:44 pm
by bmc444
Im struggling with the following task: Concatenate all three alphanumeric input fields with STRING. Leading and trailing spaces have to be removed. Note: Here you can use the function TRIM() if you find no other solution.

Thats how it should look like:
Input Alphanum. . 1: This string is
Input Alphanum. . 2: concatenated.
Input Alphanum. . 3:

Alphanum. output 1: This string isconcatenated.
Alphanum. output 2:

The only problem I have right now is that I can't find a way to remove the spaces between the two inputs. Either the spaces are gone but he only takes part of the 2nd input or they are just 20 spaces apart.

Re: Concatenate Input fields with string without Spaces

PostPosted: Tue Aug 28, 2018 6:47 pm
by Terry Heinze
If you are not restricted to using STRING, you could get the desired result using REFERENCE MODIFICATION.

Re: Concatenate Input fields with string without Spaces

PostPosted: Tue Aug 28, 2018 7:10 pm
by NicC
Locked as answered on another forum. We do noe want to waste our time.
Brian, do NOT post on multiple forums.