Combine two field values in straight table

[karan_kn]

Combine two field values and create expression in a straight table, as per below screenshot

[johnca · Accepted solution]

Karan, have you tried something like this?

KeepChar(New,'.0123456789') - KeepChar(Old,'.0123456789')

HTH,

John

[martinpohl]

see attached

Regards

[rajaxavier]

Tab:
LOAD * INLINE [
ID,OLD,NEW
1,03-BAC,02-ZAC
2,02-BAC,02-BAC
3,04-TAC,04-TAC
4,01-CAC,02-ZAC
5,01-CAC,04-TAC
6,01.5-CAC,02-ZAC
7,01-CAC,04-TAC
8,02-ZAC,03-BAC
9,01-CAC,03-BAC
10,02-ZAC,02-ZAC
];

TAB1:
LOAD * ,
SubField(NEW,'-',1) - SubField(OLD,'-',1) AS OUTPUT
Resident Tab;

Drop Table Tab;