sensitive sharing of content with subfield()-funktion

[beck_bakytbek]

Hi Folks,

i got a situation:

my field does look like:

Case 1: 1.4000_3,00X2500X1219_1_D

Case 2: 1.4000_3,00x2700x3000

i'va shared this field by using of subfield():

for example:

Case1:  Subfield(MyField,'X',2) = 2500 does look great,

but in the case 2 (due to small x) my output does not work.

my question is: how can i share my content within field, if i have some deviation like big X and small x? Does anybody have any idea?

[raman_rastogi · Accepted solution]

Something like this

Subfield(upper(MyField),'X',2)

Regards

Raman

[arulsettu]

try this 

SubField(Replace(('1.4000_3,00x2700x3000'),'x','X'),'X',2)

[beck_bakytbek]

Hi Raman,

thanks a lot for your help and time

[beck_bakytbek]

Hi Arulsettu,

thanks a lot for your help and time