cancel
Showing results for 
Search instead for 
Did you mean: 

shifting data

Former Member
0 Kudos

i have data curr 13.2

he has value

' 0.00'

i want him to be like this

'0.00 '

how

thanks

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos
shift curr left deleting leading space.

Message was edited by: Sekhar

Answers (3)

Answers (3)

vinod_gunaware2
Active Contributor
0 Kudos

use

Condense statement with no-gap Or

SHIFT <c> [BY <n> PLACES] [<mode>].

REPLACE <str1> WITH <str2> INTO <c> [LENGTH <l>].

regards

vinod

Former Member
0 Kudos

Hi Liat,

Do you want the data to be shifted left..

or you want it to be printed LEFT-JUSTIFIED..

regards

satesh

Former Member
0 Kudos

i ennter space and it's not show

i mean ltrim or rtrim