Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Adding delimiter to a fixed pattern of date
Top Forums Shell Programming and Scripting Adding delimiter to a fixed pattern of date Post 302920140 by Don Cragun on Tuesday 7th of October 2014 01:48:29 PM
Old 10-07-2014
Quote:
Originally Posted by Sharma331
I dont have gawk!

---------- Post updated at 03:01 AM ---------- Previous update was at 03:00 AM ----------

Hi Don,

Can you please tell me which part of your suggested code adds space after the last two characters of the line?

Thanks
The code I gave you does not add any space after the last two characters on the line as long as the input you give it is in the format you specified (your sample data included dates presented as a string of 15 or 16 non-space characters sometimes followed a single space character). Since your input file has additional characters at the end of the line that you didn't tell us about before, I'm not surprised that the output doesn't work for you.

In the future, please don't waste your time and ours by giving us sample data that is not representative of your actual data. If you would have given us representative data to begin with, you would probably have gotten working code in 2 or 3 posts instead of the 13 posts this thread took to solve your problem.
This User Gave Thanks to Don Cragun For This Post:
drl
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

adding delimiter to a fixed width file

Hi , I have a file : CSCH74000.00 CSCH74000.00 CSCH74100.00 CSCH74000.00 CSCH74100.00 CSCH74000.00 CSCH74000.00 CSCH74100.00 CSCH74100.00 CSCH74100.00 I have to put a delimiter( say comma) in between after 6th character: CSCH74,000.00 CSCH74,000.00 CSCH74,100.00 (2 Replies)
Discussion started by: sumeet
2 Replies

2. Shell Programming and Scripting

Adding delimiter to logged in users

Hi guys! Just was wanting to run a command that would allow me to seperate the currently logged in users. Basically from this format: user1 user2 user3 To: user1|user2|user3 (Note the lack of a pipe at the end, not sure if thats possible) Basically it needs to be in this... (11 Replies)
Discussion started by: crawf
11 Replies

3. Shell Programming and Scripting

Adding a delimiter to a text file

Im writing a KSH script to read a simple text file and add a delimiter. Ive written the following script but it runs very slow. I initially used the cut command to substring the input record then switched to this version using awk to substring... both run too slow. Any ideas how to make this more... (2 Replies)
Discussion started by: lock
2 Replies

4. Shell Programming and Scripting

Adding new lines to a file + adding suffix to a pattern

I need some help with adding lines to file and substitute a pattern. Ok I have a file: #cat names.txt name: John Doe stationed: 1 name: Michael Sweets stationed: 41 . . . And would like to change it to: name: John Doe employed permanently stationed: 1-office (7 Replies)
Discussion started by: hemo21
7 Replies

5. UNIX for Advanced & Expert Users

Insert Delimiter at fixed locations in a flat file

Hi Can somebody help me with solution for this PLEASE? I have a flat file and need to insert delimiters at fixed positions in all the lines so that I can easily convert into EXCEL with columns defined as per their width. For Example Here is the file { kkjhdhal sdfewss sdtereetyw... (7 Replies)
Discussion started by: jd_mca
7 Replies

6. Shell Programming and Scripting

search for a string without fixed delimiter in the line

Hi Need your help to assign the string to a variable from a line which has no fixed delimter in unix. for example , my file contains Name="report"" File Name one="test1" File Name two="test2" now how do I read report , test1 and test2 ? var1=report var2=test1 var3=test2 ... (1 Reply)
Discussion started by: rashmisb
1 Replies

7. Shell Programming and Scripting

how to implement in one-line awk in a fixed file having no delimiter

Hi, I have a file a.txt having no delimiter. I want to exclude the line which contains 435th character as 1 or 2 and redirect the rest of the lines to another file b. Can you pls suggest how to do this in one liner awk. Following is just one line of the input file a:- 120110116 ... (10 Replies)
Discussion started by: millan
10 Replies

8. Shell Programming and Scripting

Adding String at specific postition of a delimiter

I have a file containing data lines: 1|14|CONSTANT||11111111||00887722||30/04/2012|E|O|X||||20120528093654-30.04.2012|STA11ACT|ddts555S||||00001|rrttbbggcc| 1|15|CONSTANT||22222222||00887722||30/04/2012|E|O|X||||20120528093654-30.04.2012|rrtha772|llkis000||||00001|AAEtbbggcc| I want to add a... (3 Replies)
Discussion started by: pparthiv
3 Replies

9. Shell Programming and Scripting

Adding a delimiter to a variable length file

Hi, I'm new to unix, i have a variable length file like below, 01|Test|Test1|Sample| 02|AA|BB|CC|DD| 03|AAA|BBB|CCC|DDD|EEE|RRR|TTT|SSS|YYY| I need to make this as a fixed length file. Assume that i have 10 columns in the DAT file. for ex: the first 01 record is having 4cols -... (8 Replies)
Discussion started by: Mohankumar Venu
8 Replies

10. Red Hat

Converting fixed width file to pipe delimiter in Linux(red-hat)

Hi, I am facing a typical scenario for AWK command . In HP- UNIX is behave as expected but in red hat linux same awk code is not give the same result. The below code is for convert the fixed width file to pipe delimiter file in HP-unix server. awk code: #!/bin/awk -f NR!=1... (11 Replies)
Discussion started by: brij_abhi
11 Replies

LEARN ABOUT DEBIAN

utf8trans

utf8trans(1)							     docbook2X							      utf8trans(1)

NAME

       utf8trans - Transliterate UTF-8 characters according to a table

SYNOPSIS

       utf8trans charmap [file]...

DESCRIPTION

       utf8trans transliterates characters in the specified files (or standard input, if they are not specified) and writes the output to standard
       output. All input and output is in the UTF-8 encoding.

       This program is usually used to render characters in Unicode text files as some markup escapes or ASCII transliterations.  (It is  not  in-
       tended  for  general  charset conversions.)  It provides functionality similar to the character maps in XSLT 2.0 (XML Stylesheet Language -
       Transformations, version 2.0).

OPTIONS

       -m, --modify
	      Modifies the given files in-place with their transliterated output, instead of sending it to standard output.

	      This option is useful for efficient transliteration of many files at once.

       --help Show brief usage information and exit.

       --version
	      Show version and exit.

USAGE

       The translation is done according to the rules in the 'character map', named in the file charmap. It has the following format:

       1.  Each line represents a translation entry, except for blank lines and comment lines, which are ignored.

       2.  Any amount of whitespace (space or tab) may precede the start of an entry.

       3.  Comment lines begin with #.	Everything on the same line is ignored.

       4.  Each entry consists of the Unicode codepoint of the character to translate, in hexadecimal, followed one space or tab, followed by  the
	   translation string, up to the end of the line.

       5.  The	translation  string  is taken literally, including any leading and trailing spaces (except the delimeter between the codepoint and
	   the translation string), and all types of characters. The newline at the end is not included.

       The above format is intended  to  be  restrictive,  to  keep  utf8trans	simple.  But  if  a  XML-based	format	is  desired,  there  is  a
       xmlcharmap2utf8trans  script  that  comes with the docbook2X distribution, that converts character maps in XSLT 2.0 format to the utf8trans
       format.

LIMITATIONS

       o utf8trans does not work with binary files, because malformed UTF-8 sequences in the input are substituted with U+FFFD characters.  Howev-
	 er, null characters in the input are handled correctly. This limitation may be removed in the future.

       o There is no way to include a newline or null in the substitution string.

AUTHOR

       Steve Cheng <stevecheng@users.sourceforge.net>.

docbook2X 0.8.8 						   3 March 2007 						      utf8trans(1)
All times are GMT -4. The time now is 07:19 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy