Sponsored Content
Top Forums Shell Programming and Scripting Replace delimiter for a particular column in a pipe delimited file Post 303041256 by vbe on Tuesday 19th of November 2019 01:16:55 PM
Old 11-19-2019
Welcome on board,

What have you tried so far?
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Need help with shell script for chekking a column in txt file - pipe delimited

Hi: I have a text file date(pipe delimited) which is loaded in to the DB using sql loader(&CTL files) after some initial validation by the shell script. Now i have a situation where the shell script needs to check a column in the text file and if it is NULL then it needs send this record/row... (12 Replies)
Discussion started by: ravi0435
12 Replies

2. UNIX for Dummies Questions & Answers

Search and replace string only in a particular column in a delimited file

I have file with multiple columns. Column values for a record may be same. Now i have to replace a column value(this can be same for the other columns) with new value. File.txt A,B,C,D,A,B,C,D,A,B,C,D A,B,C,D,A,B,C,D,A,B,C,D A,B,C,D,A,B,C,D,A,B,C,D A,B,C,D,A,B,C,D,A,B,C,D... (1 Reply)
Discussion started by: ksailesh
1 Replies

3. Shell Programming and Scripting

How to insert a sequence number column inside a pipe delimited csv file using shell scripting?

Hi All, I need a shell script which could insert a sequence number column inside a dat file(pipe delimited). I have the dat file similar to the one as shown below.. |A|B|C||D|E |F|G|H||I|J |K|L|M||N|O |P|Q|R||S|T As shown above, the column 4 is currently blank and i need to insert sequence... (5 Replies)
Discussion started by: nithins007
5 Replies

4. Homework & Coursework Questions

how to show particular column from pipe delimited file

hi, I have pipe delimited flat file as below 1|ab|4.5|9| 2|ac|3|12| 3|ac|4.5|8| i want to show (display) only 3rd field between pipes. please help (1 Reply)
Discussion started by: vai15517
1 Replies

5. Shell Programming and Scripting

Replace specific column range in a non-delimited file with a string!

Hi All, I will need an help with respect to replacing a range of columns on a non-delimited file using a particular string pattern. Say file input is MYNUMBERD000000-BAN CHUE INSNTS ** N+ MYAREDSDD000000+BAN CHUE INSNTS ** N+ MYDERFFFSD00000-GIR PENT - ACH ** ... (5 Replies)
Discussion started by: navojit dutta
5 Replies

6. Shell Programming and Scripting

Replace pipe delimited column string to null

Hi All, I have a large dat file where each lines are pipe delimited values. I need to parse the file depending on the request. For example: sometimes I have told to remove all the values in the 7th column (this case remove values '3333' only from the first line and '3543' from the second line)... (4 Replies)
Discussion started by: express14
4 Replies

7. Shell Programming and Scripting

Replacing a column in a pipe delimited file

Hi, I have a pipe delimited file as below and I need to replace the 2nd column of each line with null values. 1|10/15/2011|fname1|lname1 2|10/15/2012|fname2|lname2 3|10/15/2013|fname3|lname3 Output file: 1||fname1|lname1 2||fname2|lname2 3||fname3|lname3 I tried this ... (2 Replies)
Discussion started by: member2014
2 Replies

8. UNIX for Dummies Questions & Answers

Check for not null column in a pipe delimited file

Hi, I have a requirement where I have to check whether the mandatory columns in a pipe delimited file is null and print error message. For eg, I have to check if the 3rd,5th,6th,7th and 8th column are null and print the message "<column name> is null". The data file will have aroung 100,000... (6 Replies)
Discussion started by: reshma15193
6 Replies

9. Shell Programming and Scripting

Replace CRLF between pipe (|) delimiter with LF

Hi Folks! Need a solution for the following :- Source data ------------- 123|123|<CRLF><CRLF><CRLF>|321<CRLF> Required output ------------------ 123|123|<LF><LF><LF>|321<CRLF> <CRLF> represents carriage return <LF> represents line feed Being hunting high and low for a... (10 Replies)
Discussion started by: hishamzz
10 Replies

10. UNIX for Beginners Questions & Answers

Replace a column in tab delimited file with column in other tab delimited file,based on match

Hello Everyone.. I want to replace the retail col from FileI with cstp1 col from FileP if the strpno matches in both files FileP.txt ... (2 Replies)
Discussion started by: YogeshG
2 Replies
HOOLA(6)							     board_gen								  HOOLA(6)

NAME
make-gnome-freecell-board, make-aisleriot-freecell-board, make-microsoft-freecell-board, make-pysol-freecell-board - Programs to generate boards to be used as input to Freecell Solver. SYNOPSIS
program [-t] board-number or for make-pysol-freecell-board: program [-t] [-F] board-number [game-string] or for make-aisleriot-freecell-board: program [-t] board-number [game-string] DESCRIPTION
These programs are command-line programs that can generate the initial board of the Freecell games of several popular Solitaire implementations. Those boards can be in turn be inputted to fc-solve by means of a pipeline, or placed inside a file for safe-keeping. make-pysol-freecell-board and make-aisleriot-freecell-board also accept an optional third argument which indicates the game type. This type defaults to Freecell, but is useful for generating the boards of other games. Note that using this flag does not preclude one from using the "--game" flag of fc-solve. make_pysol_freecell_board.py accepts another parameter called -F or --pysolfc that deals the PySolFC boards instead of the classic PySol ones. A common paradigm for using those programs is something like: bash:~$ make-microsoft-freecell-board 11982 | fc-solve -l gi If the "-t" option is specified, then the 10 cards are printed with "T"'s, instead of "10"'s. While this does not have any effect on fc- solve it may prove useful for other solvers or solitaire implementations which do not accept "10"'s. Here is a short description of each program: make-gnome-freecell-board Generate the boards of the standalone Freecell program that comes with the GNOME desktop. make-aisleriot-freecell-board Generate the Freecell boards of GNOME's AisleRiot. make-pysol-freecell-board A Python script that generates the boards of the various games of PySol. make-microsoft-freecell-board A program that generates the boards of Microsoft Freecell and of the Freecell Pro implementation of Freecell. OPTIONS
board-number is the board number as a decimal number. game-string is a string describing the game. Valid strings and their respective games are: bakers_game - Baker's Game (*) bakers_dozen - Baker's Dozen (Broken) (*) beleaguered_castle - Beleaguered Castle (*) citadel - Citadel cruel - Cruel der_katz - Der Katzenschwantz die_schlange - Die Schlange eight_off - Eight Off (*) fan - Fan forecell - Forecell freecell - Freecell (the default) good_measure - Good Measure ko_bakers_game - Kings' Only Baker's Game relaxed_freecell - Relaxed Freecell relaxed_seahaven - Relaxed Seahaven Towers seahaven - Seahaven Towers (*) simple_simon - Simple Simon (*) streets_and_alleys - Streets and Alleys make-aisleriot-freecell-board supports only the games marked with an asterisk (*). SEE ALSO
fc-solve (6) /usr/share/doc/freecell-solver-bin/README.board_gen AUTHOR
Shlomi Fish, <http://www.shlomifish.org/> . board_gen 3.12.0 2012-06-22 HOOLA(6)
All times are GMT -4. The time now is 10:15 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy