Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Extracting fixed length number from a text file
Top Forums Shell Programming and Scripting Extracting fixed length number from a text file Post 302994211 by dsid on Monday 20th of March 2017 12:33:02 PM
Old 03-20-2017
@vgersh. awk -F ' ' is for defining delimiters as far as I know, what does your command mean
Code:
awk -F'[][]'

. The next part is the start of the string I got that and I think $NF would be number of fields, but why are you subtracting 1 from it and then printing that out.

@Scrutinizer: true my command did print out numbers more than 23 in length.


Code:
grep  -Eo '\<[0-9]{23}\>' file

the above command should work perfect as square brackets wont be in delimiters always so the awk command wont work in all occasions.

I am kinda confused as to why we are using single quotes in a grep expression. Cos I was reading the other day that single quotes remove any meaning from the special characters. Shouldn't we use double quotes?

Also the fact the you have used <,>. Are they working as a block to extract only 23 digits numbers/characters?

---------- Post updated at 04:33 PM ---------- Previous update was at 04:25 PM ----------

@andy391791

I tweaked your command a bit cos the square brackets may or may not be present in future texts for finding the 23 digit number. The tweak seems to be working fine

Code:
$ echo 'Original presentment record for ARN  24013935350549886999873 not found'|sed -n 's/.*\([0-9]\{23\}\).*/\1/p'
24013935350549886999873
[dsiddiqui@lxserv01 scripts]$ echo 'Original presentment record for ARN  [24013935350549886999873] not found'|sed -n 's/.*\([0-9]\{23\}\).*/\1/p'
24013935350549886999873

but when I increase the length of the 23 digit number and run the command, it just extracts 23 numbered digits from the complete numeric strings and pastes it, which is not the case that I want. I just want to print 23 digits only if present
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

creating a fixed length output from a variable length input

Is there a command that sets a variable length? I have a input of a variable length field but my output for that field needs to be set to 32 char. Is there such a command? I am on a sun box running ksh Thanks (2 Replies)
Discussion started by: r1500
2 Replies

2. Shell Programming and Scripting

convert XML file into Text file(fixed length)

If someone out there could help me out with this problem. I would really appreciate it. I am trying to convert xml into text file(fixed length) using Unix Borne shell scripts. My xml file: <root> <header_rec recordtype="00"> <record_id>00</record_id> ... (0 Replies)
Discussion started by: ram2s2001
0 Replies

3. UNIX for Dummies Questions & Answers

What the command to find out the record length of a fixed length file?

I want to find out the record length of a fixed length file? I forgot the command. Any body know? (9 Replies)
Discussion started by: tranq01
9 Replies

4. UNIX for Dummies Questions & Answers

Convert a tab delimited/variable length file to fixed length file

Hi, all. I need to convert a file tab delimited/variable length file in AIX to a fixed lenght file delimited by spaces. This is the input file: 10200002<tab>US$ COM<tab>16/12/2008<tab>2,3775<tab>2,3783 19300978<tab>EURO<tab>16/12/2008<tab>3,28523<tab>3,28657 And this is the expected... (2 Replies)
Discussion started by: Everton_Silveir
2 Replies

5. Shell Programming and Scripting

fixed length text file padding issues in AIX

Hi, I have a fixed length text file that needs to be cut into individual files in aix and facing padding issues. If I have multiple blank spaces in the file it is just making it one while cutting the files.. Eg:- $ - blank space filename:file.txt ... (2 Replies)
Discussion started by: techmoris
2 Replies

6. Shell Programming and Scripting

changing a variable length text to a fixed length

Hi, Can anyone help with a effective solution ? I need to change a variable length text field (between 1 - 18 characters) to a fixed length text of 18 characters with the unused portion, at the end, filled with spaces. The text field is actually field 10 of a .csv file however I could cut... (7 Replies)
Discussion started by: dc18
7 Replies

7. Shell Programming and Scripting

Help with extracting words from fixed length files

I am very new to scripting and need to write a script that will extract the account number from a line that begins with HDR. For example, the file is as follows HDR2010072600300405505100726 00300405505 LBJ FREEWAY DALLAS TELEGRAPH ... (9 Replies)
Discussion started by: bds052189
9 Replies

8. Shell Programming and Scripting

Insert a variable to a text file after fixed number of lines

Hi, I am new to unix. I need to insert a variable which contains some lines of text into a text file after fixed number of lines.. Please help me on this.. Thanks in Advance, Amrutha (3 Replies)
Discussion started by: amr89
3 Replies

9. UNIX for Dummies Questions & Answers

Fixed length file extracting values in columns

How do I extract values in a few columns in a row of a fixed length file? If there are 8 columns and I need to extract values of 2nd,4th and 6 th columns, how do i do that? I used cut command, this I used only for one column. How do I do it more than one column? The below command will give... (1 Reply)
Discussion started by: princetd001
1 Replies

10. UNIX for Dummies Questions & Answers

Length of a fixed width file

I have a fixed width file of length 53. when is try to get the lengh of the record of that file i get 2 different answers. awk '{print length;exit}' <File_name> The above code gives me length 50. wc -L <File_name> The above code gives me length 53. Please clarify on... (2 Replies)
Discussion started by: Amrutha24
2 Replies

LEARN ABOUT DEBIAN

shanty

SHANTY(1)							      Shanty								 SHANTY(1)

NAME

       Shanty - Makes a PostScript file from an image and some text.

SYNOPSIS

       shanty -i image_file [-t text_file] [-o output_file] [-s paper_size] [-d density] [-m margin] [-b background_color] [-x padding] [-n title]
       [-l orientation] [-rtl] [-btt] [-f font_name] [-altgd]

DESCRIPTION

       Shanty takes a text file and an image (PNG or JPG) and creates a PostScript file where one pixel in the image becomes one character in  the
       PostScript.

OPTIONS

       -i, -image
		 Name of the image to load in. JPG and PNG images are supported. This is the only compulsory field.

       -t, -text Name of the text file to load in, if omitted STDIN is used.

       -o, -output
		 Name of the PostScript file to produce, if omitted STDOUT is used.

       -s, -size Size  of  the	paper  to  work  with.	This  field  should be one of: "a0", "a2", "a3", "a4", "a5", "a6", "letter", "broadsheet",
		 "ledger", "tabloid", "legal", "executive" and "36x36". Default is "a4".

       -d, -density
		 Density of the text. Higher numbers are more dense, default is 1.4.

       -m, -margin
		 The margins of the page in cm. Default is 1.

       -b, -background
		 The colour of a backing rectangle to place behind the text. Colours are specified as "R,G,B" with each value between 0  and  255.
		 "off" means no backing colour. Default is "off".

       -x, -p, -padding
		 Density of the text. Higher numbers are more dense, default is 1.4.

       -n, -title
		 The title of the output to write as meta-data in the PostScript file. Default is "Shanty output".

       -l, -orientation
		 The orientation of the paper, can be "portrait", "landscape" or "auto". Default is "auto".

       -rtl	 Switch to right-to-left text.

       -btt	 Switch to bottom-to-top text.

       -f, -font Specify font. The font name specified must be visible to the not just make a font magically appear. Default is "Courier-Bold".

       -altgd	 If you have problems loading the GD library, try this switch.

HOMEPAGE

       <http://www.codebunny.org/coding/shanty/>

AUTHOR

       Duncan Martin <duncan@codebunny.org>

ACKNOWLEDGEMENTS

       Many thanks to DFB <http://www.cs.nott.ac.uk/~dfb/> and contributors to comp.lang.postscript.

Duncan Martin							  6 October 2006							 SHANTY(1)
All times are GMT -4. The time now is 01:09 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy