Remove first and last comma

[rustyfishbones]

Hi All,

I have a field with comma separated values, like below

, PB , D , 28006 , 0 , 0 ,   9 ,

I am using SUBFIELD(MyField,',',) as MyNewField

however I keep getting blank values for the first and last comma

I want to remove the first and last comma while still using the above SUBFIELD Function

Regards

Alan

[rbecher]

How the field content looks if it doesn't start with a comma? Is there a value for the first subfield? I would guess it has the same structure..

[rustyfishbones]

Hi Ralf,

There does not seem to be any value before the first comma

Regards

Alan

[rustyfishbones]

Thanks Henric,

But that does not seem to be working

Regards

Alan

[rbecher]

Then please post an example with the different content..

[rustyfishbones]

Hi Ralf,

Please see the attached file

Regards

Alan

[rbecher]

..but how you will handle those different record types/structures? Do you have the record descriptions? If not I think the values are meaningless.

[rustyfishbones]

Hi Ralf,

I think you are correct, the Database Structure was written by the MD, I am meeting him shortly, I just wanted to try so I have an answer to give him.

I done a SUBSTRINGCOUNT and some strings contain 256 values, it's crazy

Thanks everyone for their help

Regards

Alan