get/cut some words in the midle of field

[Handihusen]

Please somebody can help me:
How can i get/cut some words in the middle of field with delimetted? For example i want get word "adminFee" and next characthers (the amount of admin fee) ?
Examples:
I have field "Remarks" with contents: //name://davids://amount://100000://adminfee://500//date://20220131//city://jakarta//

[sbxkoenk]

Hello,

Build upon this :

data _NULL_;
remarks = '//name://davids://amount://100000://adminfee://500//date://20220131//city://jakarta//';
pos=index(remarks,'adminfee'); put pos=;
adminfee=substr(remarks,pos,20); put adminfee=;
adminfee_amount = input(compress(adminfee,'abcdefghijklmnopqrstuvwxyz:/'),best12.); put adminfee_amount=;
run;

Koen

[Handihusen · Accepted solution]

Thanks a lot mr/miss Koen.. you are the best 👍👍