Hi experts,
I need urget help! I have the a text file with this format:
Types of fruits
Name of fruits
1,1
Farm_no,1
apple,1
pineapple,1
grapes,1
orange,1
banana,1
2,2--->this is the record seperator
Farm_no,2
apple,1
pineapple,1
grapes,3
orange,2
banana,1
3,3--->this is the... (1 Reply)
Hi experts,
I need urget help! I have the a text file with this format:
Types of fruits
Name of fruits
1,1
Farm_no,1
apple,1
pineapple,1
grapes,1
orange,1
banana,1
2,2--->this is the record seperator
Farm_no,2
apple,1
pineapple,1
grapes,3
orange,2
banana,1
3,3--->this is the... (2 Replies)
this is Korn shell unix.
The scenario is I have a pipe delimited text file which needs to be customized. say for example,I have a pipe delimited text file with 15 columns(| delimited) and 200 rows. currently the 11th and 12th column has null values for all the records(there are other null columns... (4 Replies)
Hi,
I have a comma (,) delimited file, in which few fields are enclosed with in double quotes " ". I have to print the records in the file which donot have expected number of field with the line number.
File1
====
name,desgnation,doj,project #header#... (7 Replies)
Hi All,
I need a unix script to convert .csv files to .skv files (changing a comma delimited file to a semi colon delimited file). I am a unix newbie and so don't know where to start. The script will be scheduled using cron and needs to convert each .csv file in a particular folder to a .skv... (4 Replies)
Hi,
Is there a one-liner that I can use to change a line of text into a comma delimited string?
For example, convert
user1
user2
user3
user4to
user1,user2,user3,user4Currently using while read x, although got the extra comma at the end that I have to remove manually.
Please... (5 Replies)
Hi,
I am wanting to create a script that will construct a SQL statement based on a a space delimited string that it read from a config file.
Example of the SQL will be
For example, it will read a string like "AAA BBB CCC" and assign to a variable named IN_STRING.
I then concatenate... (2 Replies)
I have file in linux with comma delimited and string fields in double quotations ", I need to convert them to pipe delimiter please share your inputs.
Example:
Input:
"2017-09-30","ACBD,TVF","01234",NULL,18,NULL,"686091802","BANK OF ABCD, LIMITED, THE",790456
Output:
... (4 Replies)
Hi,
Apologies in advance to the moderator if I am posting this the wrong way.
I've searched and found the solution to an old post but as it is a very old post, I don't see an option to update it with additional question.
The question I have is in relation to the following post:
How to... (6 Replies)
Discussion started by: newbie_01
6 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)