Insert decimal (period) after first 3 characters

[Childrensmn]

I have a varchar column with alpha numeric records. I want to insert a decimal (period) after the first 3 characters. How do I accomplish this in the transformer?

Example
Current Diagnosis_Code
---------------------------
H13132D
78888D
43834

Converted As Diagnosis_Code
-----------------------------------
H13.132D
788.88D
438.34

Thanks!!

[chulett]

Substring. Use the substring operators "[]" to take the first three and the rest of the field and concatenate the period between them. Off the top of my head and without any kind of syntax check:

Code: Select all

Current Diagnosis_Code[1,3] : '.' : Current Diagnosis_Code[4,999]

That final size isn't important and won't error if it is 'too long' but you could always use the real size, even if it is not always known - that's what the length function is for.

[Childrensmn]

Works great. Thank You.