How to remove the last line in flat file using Arc script ??
The below script is to add the “END” on the last line but I need to remove the END which is present in the last line of a Flat-file??
<arc:set attr="file.file" value="[filepath]" />
<arc:call op="fileRead" item="file">
<arc:set attr="tmp.originalBody">[file.file:data]</arc:set>
</arc:call>
<arc:unset attr="output.data">[tmp.originalBody]END</arc:set>
<arc:unset attr="output.filename" value="940_[now()]" />
<arc:push item="output" />
Best answer by Rohit
Hi
If you only want to remove the last line from a flat file without shifting it to the second-to-last line, you can use the following script.
In this script:
fileReadLine operation. I initialize a total (total lines) variable to 0 and increment it by 1 for each line during iteration.This approach ensures the last line is excluded without affecting the rest of the file.
Here is the script:
<arc:set attr="file.file" value="[filePath]" />
<arc:set attr="file.total" value="0" />
<!-- Counting total number of lines present in the file -->
<arc:call op="fileReadLine" in="file" out="line">
<arc:set attr="file.total" value="[file.total | add(1)]" />
</arc:call>
<!-- printing the data less than the size of total lines variable, in order to remove the last line -->
<arc:set attr="output.data">
<arc:call op="fileReadLine" in="file" out="line">
<arc:if exp="[_index] < [file.total]">[line.file:data]\n</arc:if>
</arc:call>
</arc:set>
<arc:push item="output" />Do let me know if it works or if you have more questions.
It’s a little difficult to tell from your question, what it is you want to achieve, but likely you’d want to use a regular expression in a regex replacement.
It sounds like you want to take a flat file with a freestanding END line:
This is a test.
Second line.
END
And move END to the end of the previous line:
This is a test.
Second line.END
Regular expressions are powerful ways to manage pattern matching, and you can use Regexr to test out new patterns. That code, combined with your existing setup, would look something like:
<arc:set attr="file.file" value="[filepath]" />
<arc:call op="fileRead" item="file">
<arc:set attr="tmp.originalBody">[file.file:data]</arc:set>
</arc:call>
<arc:set attr="output.data">[tmp.originalBody | regexreplace('\s+END$','END')]</arc:set>
<arc:set attr="output.filename" value="940_[now()]" />
<arc:push item="output" />
Hi
If you only want to remove the last line from a flat file without shifting it to the second-to-last line, you can use the following script.
In this script:
fileReadLine operation. I initialize a total (total lines) variable to 0 and increment it by 1 for each line during iteration.This approach ensures the last line is excluded without affecting the rest of the file.
Here is the script:
<arc:set attr="file.file" value="[filePath]" />
<arc:set attr="file.total" value="0" />
<!-- Counting total number of lines present in the file -->
<arc:call op="fileReadLine" in="file" out="line">
<arc:set attr="file.total" value="[file.total | add(1)]" />
</arc:call>
<!-- printing the data less than the size of total lines variable, in order to remove the last line -->
<arc:set attr="output.data">
<arc:call op="fileReadLine" in="file" out="line">
<arc:if exp="[_index] < [file.total]">[line.file:data]\n</arc:if>
</arc:call>
</arc:set>
<arc:push item="output" />Do let me know if it works or if you have more questions.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
