Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Regular expression to find the length of a field
Top Forums Shell Programming and Scripting Regular expression to find the length of a field Post 302455721 by aigles on Wednesday 22nd of September 2010 09:46:14 AM
Old 09-22-2010
Try and adapt the following script :
Code:
awk '

function fmtSize( fmt, typ   ,s) {
   if (! fmt) return 0;
   if (sub("^" typ "*\\(", "", fmt)) {
      s = fmt+0
   } else {
      match(fmt, "^" typ "*");
      s = RLENGTH;
   }
   return s
}

NF>=3 {
   column = $2;
   format = toupper($3);
   gsub(/^[SZ]|\.$/, "", format);
   type   = substr(format, 1, 1);
   split(format, f, /V/);
   if (type == "9")
      size = fmtSize(f[1], type) + fmtSize(f[2], type);
   else if (type == "X")
      size = fmtSize(f[1], type);
   else
      next;
   printf "Column=%s Format=%s Size=%d\n", column, $3, size;
}

' inputfile

With your sample inputfile, the output is:
Code:
Column=col1 Format=s9(10)V99. Size=12
Column=Col2 Format=s9(10)V9(3). Size=13
Column=Col3 Format=XXXX. Size=4
Column=Col4 Format=X(3). Size=3
Column=Col5 Format=S999999. Size=6
Column=Col6 Format=s999V99. Size=5
Column=Col7 Format=Z9(9). Size=9

Jean-Pierre.
This User Gave Thanks to aigles For This Post:
ahmedwaseem2000
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How To Find Length of a Field in XML File

Hi I have a xml file with below data...have to find the length of the filedvalues... <?xml version="1.0" encoding="ISO-8859-15" standalone="no"?><abc xmlns:xsi="http://www.w3.org/2000/XMLSchem... (3 Replies)
Discussion started by: naughty21
3 Replies

2. UNIX for Dummies Questions & Answers

using regular expression for directories in find command

Hi, I want to find the files available in a directory /var/user/*/*/data/. I tried using the command "find /var/user/ -path '*/*/data/ -name '*' -type f" it says find: 0652-017 -path is not a valid option and then i tried using "find /var/user/ -name '*/*/data/*' -type f" but its not... (3 Replies)
Discussion started by: vinothbabu12
3 Replies

3. UNIX for Dummies Questions & Answers

grep regular expression to find = not ==

I suspect this is commonly done, but haven't found the right combination of search terms to find the answer. I want to grep for lines in .cpp files that contain only 1 '=' sign in an if statement. e.g., if (a = b) -- find this if (a==b) -- don't find this My attempt: egrep... (7 Replies)
Discussion started by: offkilter
7 Replies

4. Shell Programming and Scripting

Using grep and regular expression to find class references in a c++ file

I'm trying to math all class references in a C++ file using grep with regular expression. I'm trying to know if a specific include is usuless or not, so I have to know if there is a refence in cpp. I wrote this RE that searches for a reference from class ABCZ, but unfortunately it isn't working... (0 Replies)
Discussion started by: passerby
0 Replies

5. Shell Programming and Scripting

Find, regular expression, anyway to simplify this find command?

Hello everyone, first post here, trying to learn scripting on my own and this forum as been really helpful so far. I made few little scripts working great but I m facing some problems with RE. I have a bunch of files in many subdirectories called *001.ext *002.ext OR simple *.ext or *01.ext... (7 Replies)
Discussion started by: Sekullos
7 Replies

6. Programming

Perl: How to read from a file, do regular expression and then replace the found regular expression

Hi all, How am I read a file, find the match regular expression and overwrite to the same files. open DESTINATION_FILE, "<tmptravl.dat" or die "tmptravl.dat"; open NEW_DESTINATION_FILE, ">new_tmptravl.dat" or die "new_tmptravl.dat"; while (<DESTINATION_FILE>) { # print... (1 Reply)
Discussion started by: jessy83
1 Replies

7. Shell Programming and Scripting

Regular Expression in Find command [KSH]

Hello, I am trying to use regex wtih find command in KSH. For some reason it is not working as expected. Input: comm_000_abc_0102.c comm_000_abc.c 456_000_abc_1212.cpp 456_000_abc_.cpp Expected Output: comm_000_abc_0102.c kkm_000_abc_8888.cpp (Basically I want to find all... (6 Replies)
Discussion started by: vinay4889
6 Replies

8. Shell Programming and Scripting

How to find out whether a file exists with the help of regular expression?

Hi all I have a list of file names in array. But this file names are not exact. so i want to search whether a file exists or not using regular expression. code snippet: if ; then echo "File exists" else echo "File does not exits" fi over here "*EQST*" should be treated as a regular... (4 Replies)
Discussion started by: Ganesh_more
4 Replies

9. UNIX for Dummies Questions & Answers

How to using Regular expression to find file.?

Hi Gurus, I need to identify the file with below format: ABC20110101.DAT ABCD2011010103.DAT If I use ABC*\.DAT, it get two file. I want to get file after "ABC' then number, the ".DAT". I tried ABC* but it doesn't work. Thanks in advance. (9 Replies)
Discussion started by: ken6503
9 Replies

10. Shell Programming and Scripting

How to find regular expression for two files?

I have files: sum_<INPUT FILENAME>.YYYYMMDDhhmmss.csv and sum_details_<INPUT FILENAME>.YYYYMMDDhhmmss.csv I have no idea, what is input filename, but in the code I would like to catch them in case I process them in the loop above case statement for *.${Today}.*.txt... (3 Replies)
Discussion started by: digioleg54
3 Replies

LEARN ABOUT ULTRIX

dtif

DTIF(5) 							File Formats Manual							   DTIF(5)

Name
       DTIF - Digital Table Interchange Format

Description
       Digital	Table Interchange Format (DTIF) is the standard format for the storage and interchange of documents that contain data tables, for-
       mulas, and spreadsheets. You can use DTIF to store and retrieve database information, interchange spreadsheets, and reference table data in
       compound documents.

       DTIF defines the logical structure and physical layout of a data table, the values within the table (absolute data and/or expressions), and
       presentation attributes (formatting) to be used when displaying or printing the table. DTIF works with Digital Document Interchange  Format
       (DDIF) so that you can store or reference DTIF tables in DDIF-encoded compound documents.

       A  DTIF	document  can  contain	a sequence of one or more tables and is uniquely identified by a product name, a version number, and other
       descriptive information such as the document's title and creation date.	Each DTIF table is a 2-dimensional display of  data  values  orga-
       nized in columns and rows that has its own structure and table data stored in cells.

       In  DTIF  documents,  attributes  specify  the  type  and format of information pertaining to the data stored in a table. Column attributes
       describe information for all the cells in a particular column, whereas generic column attributes can be applied to any column in any  table
       that  references  them. Format attributes define the printed and displayed presentation of data stored in the table.  Format attributes can
       also be redefined at the window, column, or cell level.

See Also
       CDA(5), DDIF(5), DTIF(5)
       Compound Document Architecture Manual

																	   DTIF(5)
All times are GMT -4. The time now is 10:38 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy