Help Adding Underscore At End of Number

[jenelsebo]

Hi, I have a set of account numbers that I need to add an underscore to the end of, so 1234 to show as 1234_ I recall doing this a while ago but cannot remember how, I know it ended & "_" as .... but cannot remember? I've look online, but cannot find the solution? Any suggestions please?

[canerkan]

Hi Jenelsebo,

you already guessed it.

Add the following to the load script of your table:

Field_you_want_to_load & "_" as AccountNo

Let me know if it helped.

Regards

Can