Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a funny situation where data is stored with " ". Double quotes for all the values. I am wondering if there is a way to get rid of it easily. the problem is it exists for all the columns and rows of data.
like
"Coutnry"
"USA"
"JAPAN"
"GERMANY"
"Revenue"
"200000"
"600000"
"800000"
You could use the purgechar function in your load script:
For example purgechar([Your Field], chr(34))
(n.b. chr(34) is a double quote character)
You could use the purgechar function in your load script:
For example purgechar([Your Field], chr(34))
(n.b. chr(34) is a double quote character)
I appreciate it. Thanks.
is it possible to do all tables, coulumns in one go ?
Thanks