I have a spreadsheet that has a field with embedded newline characters. I really just need to keep the first line of this 'multi-line' field. I've tried doing a find and then substring on the field, but it's not truncating after the first line. I tried the following asubstrnd several similar options, but the field is not getting substringed: Substring([AddressField],1,FindString{[AddressField],"\n")-1) but this is still returning the full field in the output file. Is there a correct way to truncate the field?
Example of the data:
Address Line 1
Address Line 2
City, ST, Zip
I only need to keep the first line in this case, as there are other fields with the same data. Thanks.
Solved! Go to Solution.
Hi
Can you upload an example of the data?
kr
Thanks, this did the trick!