Hi,
I have data like this 'F1', 'F34','JACK','NULL', 'ROB'
i want to do transformation only 4 letter string so in target it should look like 'F1', 'F34','JACK','NULL, 'ROB'
how can i do it
Thanks
REPLACE on four quotes
Moderators: chulett, rschirm, roy
Re: REPLACE on four quotes
Could it be that some spaces have been removed from your post? Do you want to blank-pad your strings to 4 characters?
Code: Select all
OutCol = Left(In.Col:' ',4)