Jump to content

Filed name ending in space on cvs file


This topic is 2847 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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 by Lee Smith
Took the center alignment off the text
Link to comment
Share on other sites

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

  • Like 1
Link to comment
Share on other sites

Look at the Trim( ) function.

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

Edited by doughemi
Bad information originally given
Link to comment
Share on other sites

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.

 

Link to comment
Share on other sites

This topic is 2847 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.