Concatenate

skp · Post by **skp** » Mon Dec 31, 2007 2:43 am

Hi all,

My input date is like this......

Hmphonenumber
212-790-2820
607-871-2144
215-563-6417
804-924-4245
213-680-5200
858-453-4100
206-622-2294
-------------

I need to get the phone number without the delimeter' -'Ex:2127902820

I am useing field function and writeing to a stage variable A,B,C
1) Field(lk_AccInfo.AI_HomePhone,'-',1,1)---->211 (A)
2)Field(lk_AccInfo.AI_HomePhone,'-',2,1)---->790 (B)
3)Field (lk_AccInfo.AI_HomePhone,'-',3,1)---->2820(C)

I am trying to concatenate (in transformer Stage) all the variables but I am getting 211 only insetad of 2117902820

Is there any other ways to implements???

Thanks in advance

ray.wurlod · Post by **ray.wurlod** » Mon Dec 31, 2007 2:54 am

Welcome aboard.
Your Field() functions are good. Show us how you are attempting the concatenation. What is should look like is:
1) Field(lk_AccInfo.AI_HomePhone,'-',1,1)---->211 (svA)
2) Field(lk_AccInfo.AI_HomePhone,'-',2,1)---->790 (svB)
3) Field (lk_AccInfo.AI_HomePhone,'-',3,1)---->2820 (svC)
4) svA : svB : svC -----> 2117902820 (outputcolumn)

skp · Post by **skp** » Mon Dec 31, 2007 3:14 am

ray.wurlod wrote:Welcome aboard.
Your Field() functions are good. Show us how you are attempting the concatenation. What is should look like is:
1) Field(lk_AccInfo.AI_HomePhone,'-',1,1)---->211 (svA)
2) Field(lk_AccInfo.AI_HomePhone,'-',2,1)---->790 (svB)
3) Field (lk_AccInfo.AI_HomePhone,'-',3,1)---->2820 (svC)
4) svA : svB : svC -----> 2117902820 (outputcolumn)

Thanks ray,

I am implementing the same as specified, but getting 211 of the first Variable only.

balajisr · Post by **balajisr** » Mon Dec 31, 2007 3:29 am

What is your output column length? Hope it is not 3.

skp · Post by **skp** » Mon Dec 31, 2007 3:33 am

balajisr wrote:What is your output column length? Hope it is not 3.

output column lenght is 25 (char)

ArndW · Post by **ArndW** » Mon Dec 31, 2007 4:07 am

Could you cut-and-paste your concatenation derivation to this thread? Most likely that is not working as you expect. Also, what datatype and length have you declared your stage variables as?

dspxlearn · Post by **dspxlearn** » Mon Dec 31, 2007 10:05 am

skp,

Just addition to that, in my opinion the simpler would be,

Code: Select all

Convert(lk_AccInfo.AI_HomePhone,'-','')

OR

If your phone no format will be same in future also then,

Code: Select all

lk_AccInfo.AI_HomePhone[1,3] : lk_AccInfo.AI_HomePhone[5,7] : lk_AccInfo.AI_HomePhone[9,12]

If your issue has been resolved, please post your code for other's reference.

ArndW · Post by **ArndW** » Mon Dec 31, 2007 10:17 am

dspxlearn wrote:...
Code: Select all
Convert(lk_AccInfo.AI_HomePhone,'-','')
...

should read

Code: Select all

Convert('-','',lk_AccInfo.AI_HomePhone)

dspxlearn · Post by **dspxlearn** » Mon Dec 31, 2007 11:02 am

Oh yes!!

Thanks for correcting me Ray.

DSguru2B · Post by **DSguru2B** » Mon Dec 31, 2007 11:14 am

...that would be ArndW

ray.wurlod · Post by **ray.wurlod** » Mon Dec 31, 2007 3:42 pm

What happened that this suddenly became resolved? Most recently we had

skp wrote:I am implementing the same as specified, but getting 211 of the first Variable only.

Now the thread is marked as resolved!

Raamc · Post by **Raamc** » Tue Jan 01, 2008 6:05 pm

You can also remove '-' by using the TRIM Function as below.

MyStr = Trim("Telephone_Number", "-", "A")