strstr is not available in 5.3 visual mapper - the closest I see is this, but offhand I didn't see any operator to return the position number a specific character so you might have to loop through using the macro to return the position of the ",".
portion of text: Extract a series of alphanumeric characters from a specified value according to the starting position and length specified. portion [of text] EXP1 starting [at position] EXP2 for EXP3 [characters] Where: EXP1=Either a source field or element with an alphanumeric data type or an alphanumeric expression EXP2=An arithmetic expression EXP3=An arithmetic expression This mapping operation produces data consisting of some of the characters of the original data (EXP1). The part returned by this operation starts with the character at the position specified by EXP2 and continues for EXP3 characters. Example The mapping operation portion of text 'ABCDE FG' starting at position 3 for 5 characters produces 'CDE F'. Dave Records Records Consulting, LLC Phone: 616.583.0090 Email: [email protected] On Feb 22, 2011, at 11:57 AM, Mukesh Kumar wrote: > Dear All, > > I have come across a requirement in which I have to search a particular > character within an element. > > I am using Gentran v5.3 (visual map) on IBM-AIX platform. > > My requirement is: full name is coming in one source element of 70 > characters long and it consists first name as well as last name separated by > a comma (,) > I have to look for comma and have to map first name in our destination > element and last name in other. > > As far as I know I can use macro to search comma in the element but as the > source element is 70 characters long, hence I have to put same logic for all > 70 positions which I don't think will be a smart solution. > > Can any one suggests do we have any other way to write such logic. > Will appreciate all solutions. > > Thanks > Mukesh > +91-9874320420 > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed] ------------------------------------ ... Please use the following Message Identifiers as your subject prefix: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Job postings are welcome, but for job postings or requests for work: <JOBS> IS REQUIRED in the subject line as a prefix.Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/EDI-L/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/EDI-L/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
