Here's a suggestion that may get you something that works for that file:   Post some example text in a code box opened on the forum with the {I}. The picture you posted does not include an actual example of your end of record appearance. The example doesn't need to contain any sensitive values and would be a good idea to contain at least 3 records so we can see two or more "end of record"   Code would be needed but he field delimiter can be addressed with the DLMSTR option on an infile statement: data example; infile datalines dlmstr="~##~"; input a $ b c; datalines; abc~##~1.23~##~999 ;     ... View more

Thank you ... View more

Thanks for all the quick responses. For some reason changing the output file type to .CSV (instead of .XLSX) works for us. We will try the ODS EXCEL suggestion also. ... View more

Thanks to all! The following worked best for my needs but the other suggestions were good options too!   location = index(name_plus_address, strip(name)); ... View more