'Regex splitting on newline outside of quotes in VBA Macros [closed]
I have a file which contains pipe separated string, I want to split that string on new lines that are outside double quotes using Split function of VBA if possible. File date looks like this. fileStr = abc|hbd|hss abd|"shs hshs"|jdjd hddn|hddd|sdjdd
desired ouput should be like below Row 1 -> abc|hbd|hss Row 2 -> abd|"shs hshs"|jdjd Row 3 -> hddn|hddd|sdjdd
I have tried Split(strData, vbNewLine) but its not working.
Can you please give the code snippet which I can directly use in my VBA Code.
Note: Need this in VBA Macros not in other languages
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
