DSXchange

Its a decimal field with (10,2). I want to remove the spaces inbetween them
Sample data:
2006093033 001 0000000000.00 0002055498.78 0000018615.46
2006093061 001 0000000000.00 0000000000.00 0000801466.59
2006093062 001 0000000000.00 0000000329.00 0000216546.21
2006093033 002 0000000000.00 0000166177.06 0000000173.07
2006093061 002 0000000000.00 0000021250.35 0000053596.18
2006093062 002 0000000000.00 0000000018.03 0000036382.91

Can you give an sample of how your output data should look?

decimal fields are putting a leading space by default.
The data should look like this:
20060930none33none002none00000000.0000none00166177.0598none0000173.071

Finally I fished out the input that relates to your output

Input Output

I dont see a direct way of getting to your output

What are the rule for your transformation? More information please.

Thanks for the result but my questionis how to remove the default leading space that it puts for the decimal fields
I was using none for testing

The leading space is for the sign character. You can only remove it by converting the data type to VarChar and applying a function such as TrimF to it.

It worked ray :D .

Thanks a lot for all your help.

shilpa79 wrote:It worked.

Thanks a lot for your help.

Can you please let everyody know, how you solved it?

I have changed the sqltype to varchar and used the function in the col derivation Decimaltostring