Ask Your Question
0

[Calc] DBF export filter uppercases field names in 6.1

asked 2019-01-21 18:13:38 +0100

Cev gravatar image

Hello all,

On version 6.1.2.1 (x64) When I open a dbf file with lowercase field names and save it, all fields are uppercased. This breaks my current data flow, although it seems uppercase field names are common practice. Uppercasing all field names without having the option to optout in the dBASE filter seems a little brutal to me. - Is this a wanted effect ? - What solution would you recommend ? A custom dbf filter ?

Thanks for the help and the great job !

Cev.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-01-21 18:53:15 +0100

erAck gravatar image

Calc writes dBASE III+ compatible files in which field names are upper case, can not be longer than 10 characters and not contain spaces. There is no workaround.

edit flag offensive delete link more

Comments

Thanks for the reply ! I've checked on a dBASE III+ manual here and at §8.2 it says that

Field names can be up to 10 characters long and begin with a letter. Spaces are not allowed

But I don't see a mention about uppercase. Could you point to the right reference ?

Thanks.

Cev.

Cev gravatar imageCev ( 2019-01-21 22:15:40 +0100 )edit

The original dBASE software stored only upper case field names. I don't know if there is a normative reference or whether it's an implicit requirement or what happens with any piece of software in the wild if not. Anyhow, it's implemented in Calc that way.

erAck gravatar imageerAck ( 2019-01-23 20:46:54 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-01-21 18:13:38 +0100

Seen: 18 times

Last updated: Jan 21