Trim and pad a field in the middle of unix file Post: 302478612

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to trim the leading zeroes in a Currency field ?

How do I trim the leading zeroes, and (+,-) in the currency field ? I have a text file. Your bill of +00002780.96 for a/c no. 25287324 is due on 11-06. Your bill of +00422270.48 for a/c no. 28931373 is due on 11-06. I want the O/P file to be like. Your bill of 2780.96 for a/c no. 25287324...

2. Shell Programming and Scripting

How to trim a 419th column in UNIX file.

Hi All, I have a UNIX file, which has Total of 532 column, each delimited with ^~^. One of the column (419) is 202 character long. In real case, it should be 22 character long. cut -d~ -f419 filename ...

3. Shell Programming and Scripting

Trim leading zeros to make field 6 characters long

Hi all- I've got a file that will have multiple columns. In one column there will be a string that is 10 digits in length, but I need to trim the first four zeros to make it 6 characters? example: 0000001234 0000123456 0000234566 0000000321 output: 001234 123456 234566 000321

4. Shell Programming and Scripting

To trim Certain field in a line of a file and replace the new string in that position

To trim 3rd field in for all the lines of a file and replace the modified string in that particular field. For example i have a file called Temp.txt having content Temp.txt ----------------- 100,234,M1234 400,234,K1734 300,345,T3456 ---------------- So the modified file output should...

5. Shell Programming and Scripting

Unix File - Adding columns in the middle

Hello, I have a comma separated flat file. It contains some 20 columns. I want to add two new columns at position 2,3. So that file will have 22 columns. I am providing here sample data with file having 4 columns. Appreciate your help in finding solution for this. data in input file:...

6. Shell Programming and Scripting

Pad zeroes first field in a Delimited file

Need help. I tried using an awk command to pad zeroes. Unfortunately, the "|" pipe delimited character is gone when I tried to write the records to another file. awk -F \| ' {$1=sprintf("%06s", $1); print $0}' $CUSTFINAL2 > $CUSTFINAL3 BEFORE "KEYRECORD"|"SA ID"|"PER ID"|"SP ID"|"ACCT...

7. Shell Programming and Scripting

trim spaces in unix for variable

HI Guys I have written a script using awk to split a file based on some identifier and renaming the file based on two values from specific length. ts a fixed width file. When I am trying to fetch the values a = substr($0,11,10) b = substr($0,21,5); i am getting spaces in a and b values ....

8. Shell Programming and Scripting

awk - trim white space from a field / variable

Hi, Consider the data (FS = |): 1| England |end 2| New Zealand |end 3|Australia|end 4| Some Made Up Country |end 5| West Indies|end I want the output to be (i.e. without the leading and trailing white space from $2) England New Zealand Australia Some Made Up Country West...

9. UNIX for Dummies Questions & Answers

Quick UNIX command to display specific lines in the middle of a file from/to specific word

This could be a really dummy question. I have a log text file. What unix command to extract line from specific string to another specific string. Is it something similar to?: more +/"string" file_name Thanks

10. UNIX for Beginners Questions & Answers

Views How to replace a CRLF char from a variable length file in the middle of a string in UNIX?

My sample file is variable length, with out any field delimiters. It has min of 18 chars length and the 'CRLF' is potentially between 12-14 chars. How do I replace this with a space? I still want to keep end of record, but just want to remove these new lines chars in the middle of the data. ...

LEARN ABOUT DEBIAN

robot-playernav

robot-playernav(1)					      General Commands Manual						robot-playernav(1)

NAME

       robot-playernav - GUI client to control over localize and planner devices

SYNOPSIS

       robot-playernav [options] <host:port> [<host:port>...]

DESCRIPTION

       robot-playernav	is  a  GUI  client that provides control over localize and planner devices. It allows you to set your robots' localization
       hypotheses by dragging and dropping them in the map. You can set global goals the same way, and see  the  planned  paths  and  the  robots'
       progress toward the goals. robot-playernav can also display (a subset of) the localization system's current particle set, which may help in
       debugging localization. You can think of playernav as an Operator Control Unit (OCU). robot-playernav can also be used just to view a map.

OPTIONS

       -fps dumprate
	      dump screenshots rate in Hz (default: 5Hz).

       -zoom zoomlevel
	      initial level of zoom in the display (default: 1).

       -aa {0|1}
	      use anti-aliased canvas for display (0 == false; 1 == true).  The anti-aliased canvas looks nicer but  may  require  more  processor
	      cycles (default: 1).

       -map map_idx
	      the index of the map to be requested and displayed (default: 0).

AUTHOR

       Player  was  written  by Brian Gerkey <gerkey@users.sourceforge.net> and contributors.  This manual page was written by Daniel Hess for the
       Debian Project.

SEE ALSO

       The HTML documentation in /usr/share/doc/player/html of the robot-player-doc package.

Player								     May 2009							robot-playernav(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to trim the leading zeroes in a Currency field ?

Discussion started by: Amruta Pitkar

2. Shell Programming and Scripting

How to trim a 419th column in UNIX file.

Discussion started by: Amit.Sagpariya

3. Shell Programming and Scripting

Trim leading zeros to make field 6 characters long

Discussion started by: Cailet

4. Shell Programming and Scripting

To trim Certain field in a line of a file and replace the new string in that position

Discussion started by: rpadhi