10-03-2016 03:09 PM
I want to convert array to string and If in some array have a space like capture2 I want to keep a space in string.
ex.
array Q to string "QQ S"
Q
S
10-03-2016 03:35 PM
Does it have space " " or is it empty string? If it is empty, you have to loop through array, search for empty character, replace with space, then convert array.
You do not need array to spreadsheet string, just use concatenate strings, it will merge all array elements into one string.
10-03-2016 03:40 PM
It have a space " "
10-03-2016 03:59 PM
Then I do not understand, where does space disappear - does not for me. Check if simple "Concatenate strings" works for you.
Also spreadsheet string to array adds extra new line characters (\r\n), that, after replacing all line feed you have used (\n) leaves carriage return symbol in the end (\r). Change display format of the string to "\ codes" to see whitespace characters.
10-03-2016 11:24 PM
Try to attach the Code Snippet/Vi along with the data....