>
Hi Sharon,
I have not use the most recent PCCF for StatsCan, but have received similar
files from StatsCan that have way too much information in each column. I
have separated by converting the file into Excel and using the Tools > Text
to Column option. You can split of items in Files by spaces, commas, other
characters etc. You may have to do some manual splitting, but it does the
job.
I had the same problem where I had two files and one file had a space in
the middle of the postal code and one did not. What I did was create
another column in the file where there wasn't a space in the Post Code and
using Update Column option under Table, I added the space in the middle by
typing in the Value: spot
Left$(postal code, 3) + " " + Right$(postal code, 3).
Hope this helps.
Cassandra Dunstall
Statistics & Data Entry
Nova Scotia Department of Education & Culture
> The '91 pc column does
> not have a space in the middle (i.e. K1A0T6) whereas my data table does
> (i.e. K1A 0T6). How can I get rid of the space in my table? Can anyone
> relate and offer some advice?
>
> Thanks in advance.
>
> Sharon
>
> ----------------------------------------------------------------------
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
