Change the field data

[#1]

Hi all,

In current field "A"  having the data like

Defect.Edgechip

Defect.ExcessPiece.Poly

Defect.Excess.Flah

System.Others

Lens.Missing.

Now can i get the field "A" values like

EdgeChip

ExcessPiece.Poly

Excess.Flash

Others

Missing

what calculated expression should i use to work on it ?

Thanks in advance.

Regards

Venkat

[Miguel_Angel_Baeyens]

Hi Venkat,

Use something like the following:

SubField(A, '.', 2) AS A

Hope that helps.

Miguel

[#3]

Hi Miguel,

For below two values

Defect.ExecePiece.Flash,

Defect.ExecePiece.Poly

it is showing the result for both values like ExecePiece,

but it should have like

ExecePiece.Flash ,

ExecePiece.Poly.

Regards

Venkat

[Miguel_Angel_Baeyens · Accepted solution]

Venkat,

Use this instead:

=Mid('Defect.ExcessPiece.Poly', Index('Defect.ExcessPiece.Poly', '.') +1) 

Regards.

Miguel

[#5]

Hi Miguel,

Its working fine.

And one more doubt in attached application, the axes of the barchart should change according the bars displayed in chart for each DefectNameShort.

i.e; if the max barchart count is 315, then the StaticMax Axes should be 315, and

if the min barchart count is 10, then the StaticMax Axes should be 0

what expression should i provide for the axes ?

Regards

Venkat

[Miguel_Angel_Baeyens]

Hi Venkat,

This is a quite different question (string handling, static axes chart...), so can you please place in a different thread with that elaborating on the document you attach what you expect and what selections to make? You can always use in the Static Min or Max the Min() and Max() as well as any other aggregation expression.

Regards,

Miguel