How do I create a data mapper that knows to go from one field to next based on pipe delimiters, where the fields may not be the same number of characters, such as below?
|065205|Vicks NyQuil Cold & Flu Nighttime Relief Liquid| |611681|Benadryl Allergy Ultratabs|
This blog article might help: Horizontal data mapping
If it does, feel free to subscribe to the blog to get notified when new articles are published!
Thanks Phil. I have one more question but I’ll open a new topic. Thanks again for all your help.