Sponsored Content
Top Forums Shell Programming and Scripting delimitted file to fixed length file Post 302207425 by manneni prakash on Friday 20th of June 2008 01:36:57 AM
Old 06-20-2008
delimitted file to fixed length file

Hi, Iam new to unix. I have a variable length file seperated by delmitter "~", I need to change it to fixed length file including space instead of delimitter. To be clear.....

Input file:

Row-id name

123~name1
124~name2
125~name3

The above input file is a variable length file seperated by delimiter ~ and row-id is of 5 character length and name is a varchar of 20.

Output file:

row-id name
123 name1
124 name2
125 name3

The above is a fixed length file which has to be send to mainframe team. so they need a fixed length file.

Please let me know how to change a varaible length file to fixed length file. Thanks in advance.
 

10 More Discussions You Might Find Interesting

1. 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

2. Shell Programming and Scripting

existing file to a fixed length file

I want to copy a existing file to a fixed length file. Thanks , I used awk getline and infuntion mode was using 0 as end of file. and length to give but the programs comes out without doing anything I need the help CM (3 Replies)
Discussion started by: cmanand
3 Replies

3. Shell Programming and Scripting

how to convert Fixed length file to delimited file.

I have below fixed lenth file . I have to convert this to delimitted file. File1.txtE116005/29/19930E001E000 E12201/23/19940E001E003 E10406/4/19940E001E003 I want to convert this to : E116,0,05/29/1993,0,E001,E000 E122,0,1/23/1994,0,E001,E003 E104,0,6/4/1994,0,E001,E003 I have a... (7 Replies)
Discussion started by: satyam_sat
7 Replies

4. 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

5. 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

6. Shell Programming and Scripting

converting fixed length file to delimited file

hi , i need to convert fixed length file to delimited file using unix where length of each column is variable (2 Replies)
Discussion started by: Nishithinfy
2 Replies

7. Shell Programming and Scripting

Remove characters from fixed length file

Hello I've question on the requirement I am working on. We are getting a fixed length file with "33" characters long. We are processing that file loading into DB. Now some times we are getting a file with "35" characters long. In this case I have to remove two characters (in 22,23... (14 Replies)
Discussion started by: manasvi24
14 Replies

8. Shell Programming and Scripting

Splitting fixed length file using awk

Hi, I need to split a fixed length file of 160 characters based on value of a column. Example: ABC 456780001 DGDG SDFSF BCD 444440002 SSSS TTTTT ABC 777750003 HHHH UUUUU THH 888880001 FFFF LLLLLL HHH 999990002 GGGG OOOOO I need to split this file on basis of column from... (7 Replies)
Discussion started by: Neelkanth
7 Replies

9. 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

10. UNIX for Beginners Questions & Answers

Splitting the file based on two fields - Fixed length file

Hi , I am having a scenario where I need to split the file based on two field values. The file is a fixed length file. ex: AA0998703000000000000190510095350019500010005101980301 K 0998703000000000000190510095351019500020005101480 ... (4 Replies)
Discussion started by: saj
4 Replies
gss_compare_name(3)					     Library Functions Manual					       gss_compare_name(3)

NAME
gss_compare_name() - allow an application to compare two internal names to determine whether they are equivalent SYNOPSIS
DESCRIPTION
The routine lets an application compare two internal names to determine whether they are the same. This routine does not resolve the names to see if they refer to the same object. It simply compares the input names for equivalence. If either name presented to denotes an anonymous principal, the routines should indicate that the two names do not refer to the same identity. Input Parameters name1 Specifies the first internal name. name2 Specifies the second internal name. Output Parameters name_equal Returns one of the following values: The names are the same. The names are not the same. minor_status Returns a status code from the security mechanism. STATUS CODES
The following status codes can be returned: The routine was completed successfully. The name passed by the name1 or name2 parameter is unsupported. An invalid name was passed by the name1 or name2 parameter. The routine failed. Check the minor_status parameter for details. AUTHOR
was developed by Sun Microsystems, Inc. SEE ALSO
gss_import_name(3), gss_release_name(3). The manpages for DCE-GSSAPI are included with the DCE-CoreTools product. To see those manpages add to gss_compare_name(3)
All times are GMT -4. The time now is 06:53 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy