How to get rid of embedded newlines

[Lizbhernan]

Hello, I need assistance with getting rid of embedded newlines.

I tried using the RegEx tool to get rid of the new embedded lines I got on my workflow after I added a join tool to bring my mapping table in to the workflow but it does not seem to be working. I'm not sure if I am not using the tool correctly or what I can possibly be doing wrong. Is there another way to get rid of new embedded lines that are duplicating my hours?

Any assistance would be extremely helpful. I have attached a sample of my workflow for reference.

TIA

[abacon · Accepted solution]

@Lizbhernan Change it from '\n' to \n, that will do the trick for you.

Another trick is to use the data cleansing tool or the data cleanse pro tool, those will remove new lines. But the regex tool will do the trick and it looks like you are on the right track, just a few tweaks.

Bacon

[Lizbhernan]

@abacon Thank you for that. I tried that but my lines are still being duplicated. Prior to the join tool, there were only 6 lines and after the join tool there are 10 duplicating the hours. At this point, I am not sure if the worktags embedding new lines is the reason why my data is duplicating. 

[abacon]

@Lizbhernan When a join creates duplicates, it is usually on the field you are joining. It looks like you have a duplicate value of 'Light Duty-Hourly' in your position mapping data. Remove the duplicates and you won't have a problem in your join.

Bacon

[Lizbhernan]

@abacon OH MY GOODNESSSS!!! Thank you, I had not noticed there were duplicates on that list. I just updated the list and that worked.

Thank you again 😊

[abacon]

@Lizbhernan You're very welcome! Always a good rule of thumb when working with joins is to test either side or dupes, that can cause a lot of fun changes to the data model you won't expect😂

Bacon