Add prefix $ t the number

Hi,

I would like add prefix $ in front of the number,
For example, 100 will be the $100, 1000 will be $ 1,000, 10000 will be $10,000
In the excel, these is function called "accounting number format", i would like to show the same result.
is there any similar functions?

Thank you,
Marc

You can use ensure prefix function for this kind of transformation

www.etl-tools.com/wiki/aetl:transformation_functions:strings