Line Break with Concatenated Data
- 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
So I have a list of employee names, IDs, and Job titles that are associated with Supervisors. I have concatenated the information to group employees by supervisor and have a single cell with "Name, Title (ID), Name2, Title2 (ID2) ..." I want to have each of those employees' information on separate lines in a singular cell. How would I do that?
Solved! Go to Solution.
- Labels:
- Data Investigation
- Datasets
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @ryanmor24 ,
can you please post some mock data and a mock outcome showing what you're trying to achieve?
M.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @ryanmor24
If you're using the Summarize tool to concatenate your results together, you can use a '\n' separator to signal that you want each record on a new line.
Sample Data:
Output:
If this solves your issue please mark answer as correct, if not let me know!
Thanks!
Phil
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @ryanmor24
How does the data look like concatenated? Is it with commas (,)?
Depending on how this looks like you could just replace commas with line breaks using REGEX
REGEX_Replace([Field], ",", "\n")
Cheers,
