Fill the remaining spaces

cherry · Post by **cherry** » Thu Jul 23, 2009 9:23 am

Hi All,

I have a field that has its length as Char(10), for this field if it has the data length that is coming in is 7 characters and the remaing space it has to get filled with the values AAA

Could you please tell me how can we achieve this.

Thanks in advance

Best Regards
Cherry

ArndW · Post by **ArndW** » Thu Jul 23, 2009 9:28 am

A Char(10) field cannot have 7 characters. This will only work if your source field is defined as CHAR(7), in which case your derivation will be "In.Char7Field:'AAA'".

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Jul 23, 2009 9:57 am

Maybe the o/p is saying that input is char(10) of which it has 7 non-blank chars and 3 blank chars (which is to be replaced by 'AAA')

Something like

Code: Select all

inputField[1, 7] : 'AAA'

Obuli · Post by **Obuli** » Thu Jul 23, 2009 12:36 pm

Why not you try "PadString" function

algfr · Post by **algfr** » Thu Jul 23, 2009 2:21 pm

PadString with 'A' as the pattern and 3 as the length I'd say

ray.wurlod · Post by **ray.wurlod** » Thu Jul 23, 2009 5:15 pm

A more general solution would have regard for the length of the inbound string. I'd use something like

Code: Select all

Left(InLink.TheString : Str("A",10), 10)

If InLink.TheString is likely to contain more than ten characters this expression will return only the leftmost 10 of them. If this is not the requirement, please adapt the expression to suit.

DSXchange

Fill the remaining spaces

Fill the remaining spaces

Re: Fill the remaining spaces