csv file extract

Get help with installation and running here.

Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators

Post Reply
sheridany
Posts: 36
Joined: Thu Nov 15, 2007 4:20 am

csv file extract

Post by sheridany »

I want to extract certain fields in a csv file into a new csv file and save it.

Filter List
-----------
Filter options
| [ ] Log to file
| [X] Append to logfile
| Log filename: textpipe.log
| Threshold 500
|
|--Input from file(s)
| [ ] Confirm before processing each file
| [ ] Confirm before processing read/only files
| [ ] Delete input files after processing
| Process binary files
|
|--Restrict fields:Comma-delimited field 5 .. field 5
| | [ ] Process fields individually
| | [X] Exclude delimiter
| | [ ] Exclude quotes (if present)
| | Delimiter Type: 0
| | Custom delimiter:
| | [X] Has Header
| |
| +--EasyPattern [[capture(longest 1 or more characters or numbers or digits)]] with [$1]
| [ ] Match case
| [ ] Whole words only
| [ ] Case sensitive replace
| [ ] Prompt on replace
| [ ] Skip prompt if identical
| [ ] First only
| [X] Extract matches
| Maximum text buffer size 4096
|
+--Output to file(s)
[ ] Only update date on changed files
[ ] Append mode
[ ] Change extension to: .txt
[ ] Open output file
Only output modified files Backup mode
Post Reply