@Hoibai wrote:
The problem is, the first record is with {"Cdtr":{"Nm":"DEUTSCHE BANK"} .
The second record is with '{"Cdtr":{"Nm":"VERGOELST GMBH"}'
according to the constant variables {"Cdtr":{"Nm":, each record in the file has a different value.
I don't understand what you mean be this. Of course each observation has a different value. But the PREFIX you are searching for looks exactly the same in both of those example values.
{"Cdtr":{"Nm":"
Personally I avoid having to use regex if I can get the result I want with simpler functions.
data have;
infile cards truncover;
input str $200.;
cards4;
{"Cdtr":{"Nm":"DEUTSCHE BANK"}
{"Cdtr":{"Nm":"VERGOELST GMBH"}
{"ar:pacs.003.002.04":{"Cdtr":{"Nm":"DEUTSCHE BANK"},"CdtrAcct":{"Id":{"IBAN":"DE0111111111111111111100"}}
;;;;
data want;
length cdtr_nm $60 ;
set have;
sp=index(str,'{"Cdtr":{"Nm":');
if sp then cdtr_nm = dequote(substr(str,sp+length('{"Cdtr":{"Nm":')));
run;
Do they all have the form
"Cdtr":{"Nm":"XXX XXXX XXXXXX"}
where "XXX XXXX XXXXXX" is the desired result, and can have variable length?
If so, you can always skip the first 14 characters and drop the last 2 characters, which can be done with the SUBSTR and LENGTH functions:
data sample;
string='"Cdtr":{"Nm":"DEUTSCHE BANK"}';
new_string=substr(string,15,length(string)-16);
put (_all_) (= /);
run;
Or if you want something more general, perhaps you can characterize the desired substring as the 5th word, where each double quote is treated as a word separator. Then, as long as the desired expression is double-quoted, and it is preceded by two expressions that are also double quoted (i.e. preceded by 4 double quotes), you can do this:
data sample;
string='"Cdtr":{"Nm":"DEUTSCHE BANK"}';
new_string=scan(string,5,'"');
put (_all_) (= /);
run;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.