REPLACE on four quotes

[times29]

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

[ArndW]

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)

[chulett]

Sorry but this doesn't make much sense. Does that example go into four fields or one field? Did you really mean to only remove one of the quotes around the word NULL?

Please try again to explain your requirement.