carrage return issue

[KeithLaw999]

hi i have a array which is set from a csv file, and then inserted into a table.

the problem i am having is the surname which is the first array is entering a carrage return before the text.

how can i remove this carrage return?

[Dan_Bracuk]

Try it without an array. Loop through your datarec list instead. If you still get the carraige return, use the replace function to get rid of it. You've shown in your posted code that you know how to do that.

[KeithLaw999]

ok i need the array as i use it later in my code, so i tried this

'#replace(dataArray[1], '#chr(13)#', '', 'all')#'

but the carrage return stil appears before the text, any ideas how i can replace this?