0

I'm using data merge to import two variables per line, and have checked the "Remove blank lines for empty fields" box. The result is a wealth of extra characters that I can't remove using find-and-replace. Of the 24 lines of variables, typically only three contain text, so the other 21 should be empty lines and be deleted by the "Remove blank lines" option.

Attempting to paste these characters into the "find and replace" field, I see 

^|^|^|^|^|^|^|^|^|^|^|^|^|^|

Any suggestions? Thanks

Nic3500
  • 8,144
  • 10
  • 29
  • 40
Beamish007
  • 33
  • 7
  • I used to get files from a customer with these and always wondered where they came from. We used find and replaced them with nothing to remove them. – cybernetic.nomad Dec 07 '18 at 17:45

1 Answers1

0

Try doing a regular text find/change. In the Find What field, type < FEFF > (but delete the spaces before and after those angle brackets – the Stack Overflow editor seems to delete this if there are no spaces). In the Change To, leave blank, and click change all.

Ariel
  • 119
  • 1
  • 10