on 11-26-2015 11:16 AM
Hello Experts,
I have one field in which I am accepting number from sender. The data type of that field is 'string'. I want to add blank spaces before that number.
Can you please let me know how to do that ? Do I need to write a UDF for this ?
Thanks.
Regards,
Swanand
If the Blank Space count is fixed through out, then this can be handled by normal graphical mapping using the 'Constant with the Spaces' and using Concatenate function.
If the Blank Space count varies depending upon the incoming field length once/everytime, then you have to use UDF to count the incoming field length and adding the required number of spaces.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Swanand,
If you know how many spaces you need to add to the field and if you are using the message mapping, then just concatenate the spaces using constant and concatenate function.
If you are not sure about the length then use UDF to handle all conditions.
regards,
Harish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.