How can I get the newline content with the regex in csv
I want to get the content of the title,des and description columns.
It is not clear what you mean by "get the newline context". Please provide detailed example.
Also, to really help you, you will need to post at least a few rows of the CSV file. You can either upload the entire file as zip file, or a few rows using a Code Block.
HI JMichaelTX
I want to get the content of the title,des and description columns.
thank you
pendientes.csv.zip (1.4 KB)
scv.kmmacros (4.3 KB)
OK, thanks for the clarification and the file. I'll take a look at it, but it may be a day or two before I can get back to you. This is a fairly complicated task.
1 Like
Ok, thank you very much
Actually, it turned out to be a lot easier than I thought.
Let us know if this will work for you.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Example Output
RegEx
(?m)^(.+?),"(.+?)","([^,]+)",
For details see: regex101: build, test, and debug regex
MACRO: scv Revised by @JMichaelTX
**Requires: KM 8.2.4+ macOS 10.11 (El Capitan)+**
(Macro was written & tested using KM 9.0+ on macOS 10.14.5 (Mojave))
#### DOWNLOAD Macro File:
<a class="attachment" href="/uploads/default/original/3X/2/5/257a3b87eea2e284433de60c7b93f57a7cf7470f.kmmacros">scv Revised by @JMichaelTX.kmmacros</a>
**Note: This Macro was uploaded in a DISABLED state. You must enable before it can be triggered.**
---
<img src="/uploads/default/original/3X/3/7/374008184684e3d5c9cca8a11ae4b4ad40e000dc.png" width="713" height="1578">Already working. Thank you very very much
1 Like