Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

1151.Text file parser -- How to extract 3,4,5th columns from csv file and replace comma with space?

User: Kun -- 2013-12-04          << 1150  1152 >>
Hits: 1157
Type: Text file parser   
Search all Text file parser examples
Description:
I need to extract 3,4,5th columns from a huge csv file and replace all the comma with space. I can do this with "cut" and "grep". But it will be fun to know how can i do this in RP~
Input Sample:
,357.377990,121805.926987,206489.117478,357.377990
Output Sample:
121805.926987 206489.117478 357.377990
Answer:
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
1. ctrl-o open csv file
2. ctrl-h open "replace" dialogue
* set "replace unit" to "Line"
* set "replace with pattern" to:

3. click "replace", done.
4. ctrl-s save to new file.

Screenshot 1:  Replace_Window


Similar Examples:
How to extract column 1 and 7 from csv files and replace each dash with space? (79%)
How to extract the 7th column from text files with 8 columns? (66%)
How to extract column X from csv file where X is decided by column A? (64%)
How to extract 3 lines from each file randomly? (60%)
How to delete the 4th column from text files with 8 columns? (59%)
How to extract half of lines from a text file randomly? (55%)
How to extract first line from multiple files and generate a new file? (54%)
How to insert two columns into a database file separated by "|"? (54%)

Check Demo of Text file parser
Keywords:
5th  grep  cut  columns  replace comma  comma  space  csv  text file parser  file parser  extract columns csv file  extract columns from csv file  space columns  extract columns  space comma  replace space with comma  extract csv  how to extract words from a