on 05-06-2008 4:18 PM
Hi,
I had a source message with four fields,
in the target there is only one field that is string.
I had to pass the four fields in to that string seperated with delimeter or comma.
how can i do that.
Source Structure
Messge
Vendor Number
Status
Vendor Name
Target Structure
String
Please help me on this.
Thanks
Srinivas
Please help me on this.
Hi,
you could use the standard-function concat:
concat(concact(concat(Messge, Vendor Number)Status)Vendor Name)
In the concat function you can edit a Delimiter (with double click on the function).
Regards
Patrick
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Srinivas,
Use
Concat R = Linking of strings X and Y (without blanks).
Example: X = Mrs.; Y = Miller; R = Mrs.Miller. Use the dialog for the function properties to insert a separator in the string.
Thanks,
Satya..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
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.