I am importing a csv file and need to use matched field names when importing: the provider of the file adds fields from time to time. However one of the field names in the cvs file ends with a space and when managing field names I do not seem to be able to define a field name which ends in a space. Every time I do the field name has the trailing space removed when I save it. Does anyone have a solution?

Thanks in advance.

Edited June 11, 20169 yr by Lee Smith
Took the center alignment off the text

You are correct, you can not have a space after the Field Name. This is a good thing, because if you were allowed have spaces after the names, it will haunt you in relationships, calculations, etc. The fields need to be corrected on import to the non-space name. You can have leading spaces in a Field name which you do NOT want either.

HTH
Lee

Many thanks for your response it will save me a lot of further time looking. Correcting on import sounds good - just point me at the where this can be done. Thanks.

Look at the Trim( ) function.

EDIT: Totally missed the fact that the op wanted to change FIELD NAMES

Edited June 12, 20169 yr by doughemi
Bad information originally given

On 06/11/2016 at 3:32 PM, adrianatwork said:

Correcting on import sounds good - just point me at the where this can be done.

I'd be curious about that too.

 

On 06/11/2016 at 4:12 PM, doughemi said:

Look at the Trim( ) function.

As I would be about this.