Need to substring cell with embedded newline characters
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi
Can you upload an example of the data?
kr
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Might do the trick
Sent from my iPhone
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks, this did the trick!
