Concatenate Input fields with string without Spaces
Posted: Tue Aug 28, 2018 2:44 pm
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.
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.