Splitted list to string

[Anonymous]

Hi!

I've a list of elements wich are actually a range in Excel, I mean: 

(setq i 1)
(setq my_rank (list 'A i ': 'B i))

I also have the GetCells.lsp function, and one of the arguments is the needed range. So, I must convert my_rank into a string. I've tried by using the strcat function but it doesn't work, I get a sort of error saying I'm giving a stringp...

Thank you so much

[Anonymous]

@Anonymous Try this?

_$ (setq i 1)
1
_$ (setq my_rank (list 'A i ': 'B i))
(A 1 : B 1)
_$ (vl-string-trim " ( ) " (vl-princ-to-string my_rank))
"A 1 : B 1"
_$ 

[doaiena]

Here is what i came up with:

_$ (apply 'strcat (mapcar '(lambda (x) (if (vl-symbolp x) (vl-symbol-name x) (itoa x))) my_rank))
"A1:B1"
_$ 

[Satish_Rajdev]

One more :

_$ (apply 'strcat (mapcar 'vl-princ-to-string my_rank))
"A1:B1"

[Kent1Cooper · Accepted solution]

---

@Anonymous wrote:

....

I've a list of elements wich are actually a range in Excel, I mean: 

(setq i 1)
(setq my_rank (list 'A i ': 'B i))

I also have the GetCells.lsp function, and one of the arguments is the needed range. So, I must convert my_rank into a string. ....

---

Dumb question, perhaps [I don't work with Excel files in connection with AutoCAD], but do you need the my_rank "middleman" variable at all?  Can you just build the string directly?

(strcat "A" (itoa i) ":B" (itoa i))
"A1:B1"