To whom it may concern:

I am trying to delete blank lines that appear after appending multiple text files into an additional text file.   Also, I am receiving mutiple headers after the append.  How can I just keep the first header?

Thank you in advance.

George 

Category Survey AutoMate BPA Server 9 version: Windows version:

Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder)
<AMVARIABLE NAME="var1"></AMVARIABLE> <AMFTP ACTIVITY="logon" SERVER="mcftp.cumc.columbia.edu" USERNAME="cdis_webdev2" PASSWORD="AM2WEnddI8Xr7JdSc10lhftsglJinTmF9y2aME" TYPE="sftp" PORT="22" SFTPHOSTKEY="validate" /> <AMFTP AM_ERRORS="27109" SOURCE="/PEGFORM/*.*" DEST="C:\OutFiles\Peg\Downtime\*.*" RESULTDATASET="dsTest" OVERWRITE="yes" /> <AMFTP ACTIVITY="logoff" /> <!-- <AMSHOWDIALOG>%dsTest.LocalFileName%</AMSHOWDIALOG>--> <AMLOOP TYPE="DATASET" DATASET="dsTest"> <AMFILESYSTEM ACTIVITY="read_file" FILE="%dsTest.LocalFileName%" RESULTVARIABLE="var1" /> <AMFILESYSTEM ACTIVITY="write_file" FILE="C:\OutFiles\Peg\Downtime\Test.txt">%var1%</AMFILESYSTEM> <!-- <AMSHOWDIALOG>%var1%</AMSHOWDIALOG>--> </AMLOOP>

Hello George,

You can use the "trim text" action to eliminate the extra carriage returns. I am attaching a small example of how this can be accomplished using the "trim text" action.

The same concept will apply to the headers, you can trim text to look for the headers and eliminate them.

Category Survey

Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder)
<AMVARIABLE NAME="varResult" /> <AMVARIABLE NAME="varTarget">1234567890 1234567890 1234567890 </AMVARIABLE> <AMSHOWDIALOG>%varTarget%</AMSHOWDIALOG> <AMTEXT ACTIVITY="trim" TEXT="%varTarget%" RESULTVARIABLE="varResult" ACTION="remove_end" REMOVE="returns" /> <AMSHOWDIALOG>%varResult%</AMSHOWDIALOG>

-------------------------

Alex Escalante | Support Analyst
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700 | F: +1.213.738.7665