https://communities.sas.com/t5/SAS-Enterprise-Guide/How-To-find-string-in-one-field-with-2-delimiter/m-p/50063#M5447 Does not look nice, but formula should be <BR /> (SUBSTR(t1.A, Find(t1.a,'@')+1,Find(t1.a,'@',Find(t1.a,'@')+1)-Find(t1.a,'@')-1))<BR /> <BR /> if You string contains in variable t1.A (I used EG for testing)<BR /> Hopefully You have not need to convert in this way million of rows. <BR /> <BR /> P.S. I would add befoire this statement checks, that string really contains two pieces of @ sign. <BR /> <BR /> /oleg Wed, 15 Dec 2010 13:47:09 GMT Oleg 2010-12-15T13:47:09Z https://communities.sas.com/t5/SAS-Enterprise-Guide/How-To-find-string-in-one-field-with-2-delimiter/m-p/50062#M5446 Need help!!<BR /> <BR /> I have data field look like this :<BR /> <BR /> 78687hkjkjh43@hsak-786778@hhjjjh762lkjklll<BR /> <BR /> I want to get data beetween delimiter @.....@ I want get value <B>hsak-786778</B><BR /> Thx for your help....<BR /> <BR /> data getstr1(keep=memo test);<BR /> set Sastbl.sas;<BR /> test=input(delimiter="@" and "@",$10.);<BR /> run;<BR /> <BR /> this can't solve my problem, any other solution please advice.thx.... Wed, 15 Dec 2010 04:29:48 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-To-find-string-in-one-field-with-2-delimiter/m-p/50062#M5446 YadiAcho 2010-12-15T04:29:48Z https://communities.sas.com/t5/SAS-Enterprise-Guide/How-To-find-string-in-one-field-with-2-delimiter/m-p/50063#M5447 Does not look nice, but formula should be <BR /> (SUBSTR(t1.A, Find(t1.a,'@')+1,Find(t1.a,'@',Find(t1.a,'@')+1)-Find(t1.a,'@')-1))<BR /> <BR /> if You string contains in variable t1.A (I used EG for testing)<BR /> Hopefully You have not need to convert in this way million of rows. <BR /> <BR /> P.S. I would add befoire this statement checks, that string really contains two pieces of @ sign. <BR /> <BR /> /oleg Wed, 15 Dec 2010 13:47:09 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-To-find-string-in-one-field-with-2-delimiter/m-p/50063#M5447 Oleg 2010-12-15T13:47:09Z https://communities.sas.com/t5/SAS-Enterprise-Guide/How-To-find-string-in-one-field-with-2-delimiter/m-p/50064#M5448 Hello YadiAcho,<BR /> <BR /> This is another solution:<BR /> [pre]<BR /> data a;<BR /> i="78687hkjkjh43@hsak-786778@hhjjjh762lkjklll";<BR /> r=SCAN(i,2,'@');<BR /> run;<BR /> [/pre]<BR /> Sincerely,<BR /> SPR Wed, 15 Dec 2010 15:00:22 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-To-find-string-in-one-field-with-2-delimiter/m-p/50064#M5448 SPR 2010-12-15T15:00:22Z https://communities.sas.com/t5/SAS-Enterprise-Guide/How-To-find-string-in-one-field-with-2-delimiter/m-p/50065#M5449 thx... <BR /> <BR /> it works... Tue, 11 Jan 2011 08:22:16 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-To-find-string-in-one-field-with-2-delimiter/m-p/50065#M5449 YadiAcho 2011-01-11T08:22:16Z https://communities.sas.com/t5/SAS-Enterprise-Guide/How-To-find-string-in-one-field-with-2-delimiter/m-p/50066#M5450 And as a general-purpose pattern-matching approach, regular expressions work great. Check out the PRXMATCH function.<BR /> <BR /> <A href="http://www2.sas.com/proceedings/sugi29/129-29.pdf" target="_blank">http://www2.sas.com/proceedings/sugi29/129-29.pdf</A><BR /> <BR /> Chris Tue, 11 Jan 2011 19:05:11 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-To-find-string-in-one-field-with-2-delimiter/m-p/50066#M5450 ChrisHemedinger 2011-01-11T19:05:11Z