Question Re: Get a substring from lon char source field in Technology Q&A https://community.sap.com/t5/technology-q-a/get-a-substring-from-lon-char-source-field/qaa-p/1860957#M817568 <HTML><HEAD></HEAD><BODY><P>No. I'm using 2004s data source. At data source definition screen I get the error "An invalid data type was defined in Alan AFIM3 " So I can't store the data to PSA.</P></BODY></HTML> Thu, 25 Jan 2007 12:09:49 GMT Former Member 2007-01-25T12:09:49Z Get a substring from lon char source field https://community.sap.com/t5/technology-q-a/get-a-substring-from-lon-char-source-field/qaq-p/1860955 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I need to get only a few characters from a field of non-sap table. I don't want to get the text field which is 1100 chars. long,. i.e. how can i get the 3 chars. into my infoobject like SUBSTR(AFIM, 403, 3)</P><P>thanks and regards,</P><P>Yigit</P></BODY></HTML> Thu, 25 Jan 2007 11:56:27 GMT https://community.sap.com/t5/technology-q-a/get-a-substring-from-lon-char-source-field/qaq-p/1860955 Former Member 2007-01-25T11:56:27Z Re: Get a substring from lon char source field https://community.sap.com/t5/technology-q-a/get-a-substring-from-lon-char-source-field/qaa-p/1860956#M817567 <HTML><HEAD></HEAD><BODY><P>you can create a formula in transfer rules in which you specified (with substring function) substring offset and length .</P></BODY></HTML> Thu, 25 Jan 2007 12:05:07 GMT https://community.sap.com/t5/technology-q-a/get-a-substring-from-lon-char-source-field/qaa-p/1860956#M817567 Former Member 2007-01-25T12:05:07Z Re: Get a substring from lon char source field https://community.sap.com/t5/technology-q-a/get-a-substring-from-lon-char-source-field/qaa-p/1860957#M817568 <HTML><HEAD></HEAD><BODY><P>No. I'm using 2004s data source. At data source definition screen I get the error "An invalid data type was defined in Alan AFIM3 " So I can't store the data to PSA.</P></BODY></HTML> Thu, 25 Jan 2007 12:09:49 GMT https://community.sap.com/t5/technology-q-a/get-a-substring-from-lon-char-source-field/qaa-p/1860957#M817568 Former Member 2007-01-25T12:09:49Z