single quote in source path while copying data

Post Reply
dilip
Posts: 128
Joined: Thu Dec 15, 2011 8:22 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2003

single quote in source path while copying data

Post by dilip »

I want to copy files from one path to another

say from csourcepath='\\abc\k\user's data' to ctargetpath='\\def\gggg\mn data'


how we can remove single quote in source path as TM1 is throwing syntax error because of single quote between r's
Wim Gielis
MVP
Posts: 3126
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: single quote in source path while copying data

Post by Wim Gielis »

Hello,

Double up the quotes: ' becomes '' (2 single quotes)
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply