The phrase is important!
"""any given character delimited"""
I read this as ANY character of ASCII, UNICODE or binary!
An assumption that the delimiter is any printable ASCII character was not even in my thoughts.
So until the OP clarifies what "any given character delimited" is then we have to assume the "0x00" and "0x80 to 0xFF" characters might be wanted, removed or replaced.
Last edited by wisecracker; 07-23-2019 at 09:20 AM..
Reason: Remove typo and add "or replaced"
Hi,
I have a delimited file generated by a database and i need to convert it to fixed width file using the field length of the database. Can any body suggest me how can i proceed with it?
:confused:
Thanks
Raghavan (2 Replies)
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)
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)
Hi, Iam new to unix. I have one input file .
Input file :
ID1~Name1~Place1
ID2~Name2~Place2
ID3~Name3~Place3
I need output such that only first column should change to fixed width column of 15 characters of length.
Output File:
ID1<<12 spaces>>Name1~Place1
ID2<<12... (5 Replies)
Open to a sed/awk/or perl alternative so that i can stick command into my bash script.
This is a problem I resolve using a combination of cut commands - but that is getting convoluted. So would really appreciate it if someone could provide a better solution which basically replaces all... (3 Replies)
Hello gurus,
I have a file in a tab delimited format and a header row. I need a code to delete the header in the file, and convert the file to a fixed width format, with all the columns aligned. Below is a sample of the file:... (4 Replies)
Hello gurus,
I have a file containing 5 columns delimited by '#' as shown in the example below:
HRP1000-PLVAR#HRP1000-OTYPE#HRP1000-OBJID#HRP1000-BEGDA#HRP1000-ENDDA#
99991231#AU7129#000000000#1 PROCTER & GAMBLE#
99991231#TT4283#1000013883#21111 LAUNDRY#
99991231#TT4283#1000013884#21121 DISH... (3 Replies)
Hi All,
I have space delimited file similar to the one as shown below.. I need to convert it as a pipe delimited, the values inside the pipe delimited file should be as highlighted...
AA ATIU2345098809 009697 005374
BB ATIU2345097809 005445 006518
CC ATIU9685098809 003215 003571
DD... (7 Replies)
I have a file with different record length. The file as to be converted into fixed length by appending spaces at the end of record. The length should be calculated based on the record with maximum length in the file.
If the length is less than the max length, the spaces should be appended... (4 Replies)
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 HPUX
strord
strord(3C)strord(3C)NAME
strord - convert string data order
SYNOPSIS DESCRIPTION
The text orientation (mode) of a file can be right-to-left (non-Latin) or left-to-right (Latin). This text orientation can affect the way
data is arranged in the file. The data arrangements that result are called screen order and keyboard order.
converts the order of characters in s2 from screen to keyboard order or vice versa and places the result in s1. The arguments s1 and s2
point to strings (arrays of characters terminated by a null character). returns s1.
performs the conversion based on mode information indicated by the argument m. The argument m is of type nl_mode found in the header file
The mode argument can have two possible values: and
If the mode argument is the text orientation is left-to-right, and all non-Latin sub-strings are reversed. Non-Latin sub-strings are any
number of contiguous right-to-left language characters. Non-Latin sub-strings are delimited by ASCII characters.
Similarly, if the mode argument is the text orientation is right-to-left and all Latin sub-strings are reversed. Latin sub-strings are any
number of contiguous printable ASCII characters. Latin sub-strings are delimited by right-to-left language characters and ASCII control
codes.
Some right-to-left languages have a duplicate set of digits called alternative numbers. Alternative numbers always have a left-to-right
orientation.
EXTERNAL INFLUENCES
Locale
The category determines whether a right-to-left language has alternative numbers.
International Code Set Support
Single-byte character code sets are supported.
WARNINGS
does not check for overflow of the array pointed to by s1.
Obsolescent Interfaces
is to be obsoleted at a future date.
AUTHOR
was developed by HP.
SEE ALSO forder(1), nljust(1), setlocale(3C), environ(5), thread_safety(5).
TO BE OBSOLETED strord(3C)