解析包含\ n作为分隔符的字段 [英] Parse field that contains \n as a delimiter
问题描述
我们有一个在输出文本文件的linux机器上运行的程序。描述字段有\ n作为换行符。
这里有一个例子:
\\\
Synopsis:\ n\\\
Error在机器上。\ n \\ n \\ n描述:\ n \\ n \\ n有一份关于可靠性的报告。这会使计算机处于危险之中。解决方案:\ n \解决方案:\ n安装新补丁
有没有办法让\ n作为报表或表单上的换行符?
我目前只有一个导入的表有一个findID然后是描述,也就是上面的数据。
We have a program that runs on a linux machine that outputs a text file. The description field has \n as line breaks.
here is an example:
\nSynopsis :\n\nError on machine.\n\nDescription :\n\nThere is a report of volnerability\nthis would make the computer at risk\nSolution :\n\nSolution:\nInstall new patches
Is there a way to make the \n as line breaks on a report or form?
I currently just have an imported table that has a findingID and then the description, which is the data above.
推荐答案
你好barmatt,
您是否尝试过使用字符代码如果是/ n,则用于回车和换行在字符串中?
我已经在报告中添加了文本框,如果我添加了Chr(13)& CHR(10)"到文本框它会休息一下。我认为你应该能够使用instr设置类似的东西并替换函数来完成你的任务。
Hi barmatt,
Have you tried using the character codes for carriage return and line feed if "/n" is in the string?
I''ve added textboxes to reports and if I add "Chr(13) & Chr(10)" to the textbox it will do a break. I would think that you should be able to setup something similar using the instr and replace functions to accomplish your task.
好主意我会试一试
FYI...小心使用Chr(13)& CHR(10)"在报告中的文本框中(不能是标签)。如果我只使用Chr(13),那么过去我的结果好坏参半。或Chr(10)或Chr(10)。没有其他人陪伴它。
FYI...be careful when using "Chr(13) & Chr(10)" in a textbox (can''t be a label) on your report. I''ve had mixed results in the past if I only used "Chr(13)" or "Chr(10)" without the other to accompany it.
这篇关于解析包含\ n作为分隔符的字段的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!