wildmatch or subfiled

[PARK_JY]

hello,

model	weight
a-1	1
a	5
a-2	4
b	3
b-1	3
b-2	2

I want to convert the above to below using wildmatch or subfiled function.

model	weight
a	1
a	5
a	4
b	3
b	3
b	2

Please help me. thank you.

[MayilVahanan · Accepted solution]

HI

Try like below

Load SubField(model,'-',1) as model, weight Inline
[
model weight
a-1 1
a 5
a-2 4
b 3
b-1 3
b-2 2
](delimiter is ' ');

[sidhiq91]

@PARK_JY  Please use the below code:

NoConcatenate
Temp:
Load SubField(model,'-',1) as model,
weight

inline [
model, weight
a-1, 1
a, 5
a-2, 4
b, 3
b-1, 3
b-2, 2
];

Exit Script;

Please like and accept it as a solution if it resolves your issue.