Export results to bat file with new lines

I am attempting to output dynamic results into a batch file to execute after it is produced.

The results that I see in the workflow have new lines however the output is not reflecting this new lines and I am not sure what output format I should use to make sure these appear.

As a result of the new lines not being included the batch files is failing.

Any suggestions?

See the attached workflow

CreateBatchfile.yxmd

Output

Accepted answers

darryl5280

Spoiler

I would just skip the writing out the BAT file and send it to the "Run Command" tool so you can execute it.

Here is my BAT file commands in the Formula Tool:

Batch file created with a Formula tool.jpg

And the field contain the code is passed into the "Run Command" tool and the "Run Command" saves it.
Just the Temp directory is used here.

Batch File Setup in the Command Tool.jpg

All comments

darryl5280

This looks strange but it is simple solution.

Change:

[Code1] + "xxx" + [Code2] + "xxx" + [Code3]

To:

[Code1] + "
xxx" + [Code2] + "
xxx" + [Code3]

aehrenwo

I actually don't need the xxx if I use this method as the Regex becomes redundant.

[Code1] + "
"
+ [Code2] + "
"
+ [Code3]

However, when I do this and export the results as a pdf.bat file using the "csv" option

It produces a file that looks like this all on ONE line with no new lines. any suggestions?

cd "C:\Program Files\wkhtmltopdf\bin\"wkhtmltopdf.exe "https://www.google.com/search?q="Adam+Ehrenworthcorruption+cases&num=50" "C:\Users\SA-JJC-HCC_Ops\OneDrive - JNJ\workflows\TPIGoogle\pdf\000001.pdf' pause

danilang

Hi @aehrenwo

When you're writing to bat files, you need to include the complete Windows line ending CRLF, ASC(13)ASC(10). \n(Asc10) only includes the LF.

you can either change your regex to

REGEX_Replace(Code, 'xxx', "\r\n")

Or change your formula to

[Code1] + CharFromInt(13) + CharFromInt(10) + [Code2] + + CharFromInt(13) + CharFromInt(10) + [Code3]

This also removes the need for your regex in the same tool.

In both cases your line breaks will be preserved.

Dan

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703