Need to substring cell with embedded newline characters

[jenniecobb]

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.

[GavinAttard]

Hi 

Can you upload an example of the data?

kr

[MarqueeCrew · Accepted solution]

Regex_replace([field],"(.*?)\n.*","$1")

Might do the trick

Sent from my iPhone

[jenniecobb]

Thanks, this did the trick!