I am trying to read a comma delimited file with special characters. The program can read the first few fields correctly until a special character is reached. Thereafter, the next column shifts to the left. Please see below example: Expected outcome Field 1 Field 2 Field 3 Field 4 I UNABLE TO EARMARK FOR VAF S/SHIP PRIOR TO 2002� ZAR 88 However, this is what I am getting: Field 1 Field 2 Field 3 Field 4 I UNABLE TO EARMARK FOR VAF S/SHIP PRIOR TO 2002�ZAR 88
... View more
Seems to be running into an infinite loop. See below example string: UPDATED BY : A134906 (BFC PTA:SUPPORT) Current employer: N/A Employer phone number: N/A Source of phone number: BDS Contact last name: N/A Contact first name: N/A Contact designation: N/A Employment restrictions: Basic salary: N/A Payment method: CREDIT TRANSFER COE capture user: A134906 Approved by: A134906
... View more
I have a field from a source system which is 800 characters long. The target system only allow 80 characters. If the string is more than 80 characters long, I must break it down into multiple records of 80 characters. Please note that the string vary in length. Therefore I must first calculate the length of each record/string.
... View more
I have a string of the following numbers which I would like to separate with commas. 000100002000300040005 Expected: 0001,0002,0003,0004,0005 I do not at any point know the length of the string. Thanks in advance
... View more
Hi All
I have a requirement to look at three numeric fields. if field one is not populated and field two and three are, then field two and three must be their values minus one. in summary, if the values on the left are not populated, the the values on the right must be reduced by either one or two.
Source Data
v1
v2
v3
1
2
3
2
3
3
1
3
Expected Reslts
v1
v2
v3
1
2
3
1
2
1
1
2
... View more
I am trying to compare two fields and output the difference. Please see below example: field_1 field_2 results 003,004,006 003,004 006 002,003,005 002,005 003 003,004 003,004,006 006 002,005 002,003,005 003 Thanks in advance
... View more
Hi All I need to connect SAS to a DB2 database on the mainframe. I have a user and password, database and table name as well as the ip address. Can someone assist with the syntax. Thanks in advance.
... View more
