How to get the value by using wildMatch

[Nagaraj6]

Hello Guys,

I need a help!

Below my field data coming like this 

FSC=0.0,JN=0.0,PSF=236.0,UDF=142.0,YR=180.0,TTF=231.0,CJN=175.0,SJN=175.0
FSC=0.0,JN=0.0,PSF=236.0,UDF=142.0,YR=180.0,TTF=231.0,CJN=213.0,SJN=213.0
FSC=0.0,JN=0.0,PSF=236.0,UDF=142.0,YR=180.0,TTF=232.0,CJN=176.0,SJN=176.0
FSC=0.0,JN=0.0,PSF=236.0,UDF=e142.0,YR=180.0,TTF=233.0,C.JN=176.0,SJN=176.0=FSC=0.0,JN=0.0,PSF=236.0,UDF=177.0,YR=100.0,TTF=219.0,IJN=329.0
FSC=0.0,JN=0.0,PSF=236.0,UDF=142.0,YR=180.0,TTF=233.0,IJN=353.0
FSC=0.0,JN=0.0,PSF=236.0,UDF=142.0,YR=180.0,TTF=235.0,CJN=178.0,SJN=178.0
FSC=0.0,JN=0.0,PSF=236.0,UDF=142.0,YR=180.0,TTF=235.0,IJN=357.0
FSC=0.0,JN=0.0,PSF=236.0,UDF=142.0,YR=180.0,TTF=236.0,CJN=178.0,SJN=178.0
FSC=0.0,JN=0.0,PSF=236.0,UDF=142.0,YR=180.0,TTF=236.0,CJN=179.0,SJN=179.0=FSC=0.0,JN=0.0,PSF=236.0,UDF=177.0,YR=100.0,TTF=275.0,IJN=412.0
FSC=0.0,JN=0.0,PSF=236.0,UDF=142.0,YR=180.0,TTF=238.0,CJN=180.0,SJN=180.0

I want to extract the data  CJN & SJN value's sometimes CJN and SJN position are changing thats why  I am using wildmatch .

I am not getting proper out.I need individual CJN column and SJN column of data.

[marcus_sommer]

I wouldn't extract those values per wildmatch() else transforming it into a normal table-structure per subfield(), maybe something on this way:

load *, subfield(FieldPart, '=', 1) as DataType, subfield(FieldPart, '=', 2) as Value, rowno() as RowNo;
load Field, subfield(Field, ',', iterno()) as FieldPart, iterno() as Iterno, recno() as RecNo
from Source while iterno() <= substringcount(Field, ',');

[BrunPierre · Accepted solution]

@Nagaraj6 Is this what you're looking for?

LOAD *,
Alt(Num#(TextBetween(Field,'CJN=',','),'#,##0.00'), 0) as "CJN Value",
Alt(Num#(TextBetween(Field,'SJN=',''),'#,##0.00'), 0) as "SJN  Value"
Inline[
Field
'FSC=0.0,JN=0.0,PSF=236.0,UDF=142.0,YR=180.0,TTF=231.0,CJN=175.0,SJN=175.0'
'FSC=0.0,JN=0.0,PSF=236.0,UDF=142.0,YR=180.0,TTF=231.0,CJN=213.0,SJN=213.0'
'FSC=0.0,JN=0.0,PSF=236.0,UDF=142.0,YR=180.0,TTF=232.0,CJN=176.0,SJN=176.0'
'FSC=0.0,JN=0.0,PSF=236.0,UDF=e142.0,YR=180.0,TTF=233.0,C.JN=176.0,SJN=176.0=FSC=0.0,JN=0.0,PSF=236.0,UDF=177.0,YR=100.0,TTF=219.0,IJN=329.0'
'FSC=0.0,JN=0.0,PSF=236.0,UDF=142.0,YR=180.0,TTF=233.0,IJN=353.0'	 
'FSC=0.0,JN=0.0,PSF=236.0,UDF=142.0,YR=180.0,TTF=235.0,CJN=178.0,SJN=178.0'
'FSC=0.0,JN=0.0,PSF=236.0,UDF=142.0,YR=180.0,TTF=235.0,IJN=357.0' 	 
'FSC=0.0,JN=0.0,PSF=236.0,UDF=142.0,YR=180.0,TTF=236.0,CJN=178.0,SJN=178.0'
'FSC=0.0,JN=0.0,PSF=236.0,UDF=142.0,YR=180.0,TTF=236.0,CJN=179.0,SJN=179.0=FSC=0.0,JN=0.0,PSF=236.0,UDF=177.0,YR=100.0,TTF=275.0,IJN=412.0'
];

EXIT SCRIPT;

[Nagaraj6]

@BrunPierre  Thank you! Yeah ,I am looking this only.