Skip to main content
K
KeithLaw999
Known Participant
September 15, 2007
Question

carrage return issue

  • September 15, 2007
  • 1 reply
  • 303 views
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?
This topic has been closed for replies.

1 reply

D
Dan_Bracuk
Inspiring
September 15, 2007
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.
K
KeithLaw999Author
Known Participant
September 16, 2007
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?
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices