Convert Embedded Lines into Single Line
- 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
Hi,
I have a data set that has some embedded lines in it and I need to combine these embedded lines into a single line in order to join with another data set.
Example:
Is there a 1/2 Pallet at Store?
Please refer to attachment
I need it to look like this:
Is there a 1/2 Pallet at Store? Please refer to attachment
I've tried a number of tools (Find and Replace, Reg Ex, etc) but havent been able to find a solution, any help would be great!
Thanks,
Joel
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @jniles
You could maybe use a Text to columns tool and use the delimeter "\n" for new line and split to columns. This would then have the embedded line on the same row and use can use a formula tool to concatenate the two fields back?
Best,
Jordan Barker
Solutions Consultant
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks Jordan that worked perfectly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
disregard
