Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to determine column separation format?
Top Forums Shell Programming and Scripting How to determine column separation format? Post 302957925 by Don Cragun on Friday 16th of October 2015 02:38:16 PM
Old 10-16-2015
You didn't supply any way for a program looking at your input file to determine whether a one or more spaces or one or more tabs found in a line in that input file is supposed to be interpreted as a field separator or as data within a field. And since you said the separation formats include spaces, tabs, ...; we don't know whether any given character in the input file is a field separator or data.

If you can't explicitly explain the difference between data and field separators in your input, there is nothing we can do to help you write an awk script that will determine the format for you.
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Joining three lines with comma separation

I have a file that looks like this: G. KRESSLAR 9618 W. APPALOOSA DRIVE SUN CITY, AZ 85373 SHIRLEY ALLEN 7272 W. VIA MONTOYA DRIVE GLENDALE, AZ 85310 LOUIS VALDEZ 244441 N. 86TH AVENUE PEORIA, AZ 85383 DONNA NEWBON 3231 W. DENTON #D PHOENIX, AZ 85017 SARAH WILSON 6534 W. PALO... (3 Replies)
Discussion started by: BCarlson
3 Replies

2. Shell Programming and Scripting

AWK CSV to TXT format, TXT file not in a correct column format

HI guys, I have created a script to read 1 column in a csv file and then place it in text file. However, when i checked out the text file, it is not in a column format... Example: CSV file contains name,age aa,11 bb,22 cc,33 After using awk to get first column TXT file... (1 Reply)
Discussion started by: mdap
1 Replies

3. Shell Programming and Scripting

How to format a column

Hi everybody I want to manipulate the output of this command: df -h to something like this: df -h | awk '{print"\t\t "$1"\t\t"$6"\t\t"$2"\t\t" $4}' | sed 's/Mounted/Mount Point/g' | sed 's/Avail/Free Space/g'but my problem is: if for example the mounting point is a long name everything beside... (3 Replies)
Discussion started by: ialbert
3 Replies

4. Shell Programming and Scripting

Help need to write a script on column separation for syslog output in perl

HI Pros, I have a issue.I need to write a script to parse the logs got from syslog server and update the same in my database.I need the following output.I donot know perl and I heard it very easy to write in perl I have the sample log I need each column seperated by commas and all equals... (0 Replies)
Discussion started by: iron_michael86
0 Replies

5. Shell Programming and Scripting

Format Column

I need a script that takes it input wither it be from a file or inputed as variables and sort that into three columns. Thanks (3 Replies)
Discussion started by: prottheman
3 Replies

6. Shell Programming and Scripting

metacharacters separation

I have prepared a script to submit a string in a txt file. However there are somethings that I have to check before submitting the string in the txt file. One of those checks is to determine whether the string entered contains any metacharacters. I have tried sth like; echo "string" | grep -v ... (3 Replies)
Discussion started by: ozum
3 Replies

7. UNIX for Dummies Questions & Answers

Using awk/sed to determine whether there are any 2's, 3's and 4's in a column

Hi, I have a very large file which is of the general format: 0 3 4 2 ... 3 2 4 0 ... 0 3 4 2 ... 3 0 4 2 ... . . . . ... . . . . ... I would like to apply a simple awk/sed script to work out whether there are any 2's, 3's and 4's in each column. The results would look as... (3 Replies)
Discussion started by: kasan0
3 Replies

8. Shell Programming and Scripting

Using filename to determine a prefix that needs to be added to string column on file?

Possible filenames: CDD_Whatever.txt DDD_Whatever.txt If the file prefix = CDD, I'd like to prefix every person ID (second column in my examples below) on the file with "c-" If the file prefix = DDD, I'd like to prefix ever person ID with "d-" Input: Desired Output: Any help... (2 Replies)
Discussion started by: lrluis
2 Replies

9. Shell Programming and Scripting

File Separation

Hi I have an XML File with default header($ lines of data) and default tail (Two Lines) and the body has occurrence of start<Folder> and ends with </Folder>. Now i want to split each occurrence i mean each start and end in to separate files with header and tail. For example: header line... (12 Replies)
Discussion started by: Nithin Kumar
12 Replies

LEARN ABOUT DEBIAN

mdb-hexdump

MDBTools(1)															       MDBTools(1)

NAME

       mdb-hexdump - Hexdump utility from MDB Tools

SYNOPSIS

       mdb-hexdump file [pagenumber]

DESCRIPTION

       mdb-hexdump is a utility program distributed with MDB Tools.

       mdb-hexdump makes a hex dump of a binary file (such as an mdb file).

ENVIRONMENT

       MDB_JET3_CHARSET
	      Defines the charset of the input JET3 (access 97) file. Default is CP1252. See iconv(1).

       MDBICONV
	      Defines the output charset. Default is UTF-8. mdbtools must have been compiled with iconv.

       MDBOPTS
	      semi-column separated list of options:

	      o  use_index

	      o  no_memo

	      o  debug_like

	      o  debug_write

	      o  debug_usage

	      o  debug_ole

	      o  debug_row

	      o  debug_props

	      o  debug_all is a shortcut for all debug_* options

SEE ALSO

       gmdb2(1) mdb-export(1) mdb-prop(1) mdb-sql(1) mdb-ver(1) mdb-array(1) mdb-header(1) mdb-parsecsv(1) mdb-schema(1) mdb-tables(1)

AUTHORS

       The mdb-hexdump utility was written by Brian Bruns.

0.7								   13 July 2013 						       MDBTools(1)
All times are GMT -4. The time now is 10:13 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy