Need a script to convert comma delimited files to semi colon delimited
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 equivalent and create a token in the folder to show completion as well as a log showing the number of files and records converted for auditing.
Sample data ... before conversion
Sample data ... after conversion
Please note that the number of columns in each file to be converted could be different, but that each .skv should have the same number of columns as the source .csv
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)
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)
Hi,
I am not sure if I've posted this question before.
Anyway, I previously asked about converting lines of text into a comma delimited string. Now I am needing to do the other way around ... :( :o
Can anyone advise how is this possible?
Example as below:
Converting records/lines to... (2 Replies)
Hi, I have a rquirement in unix as below .
I have a text file with me seperated by | symbol and i need to generate a excel file through unix commands/script so that each value will go to each column.
ex:
Input Text file:
1|A|apple
2|B|bottle
excel file to be generated as output as... (9 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 OSF1
rmf
rmf(1) General Commands Manual rmf(1)NAME
rmf - remove folder (only available within the message handling system, mh)
SYNOPSIS
rmf [+folder] [-help] [-[no]interactive]
OPTIONS
Prints a list of the valid options to this command. Asks for confirmation before deleting a folder. By default, rmf deletes a folder and
its messages without asking for confirmation. If you specify the -interactive option, rmf asks if you are sure before deleting the folder.
You are advised to use this option, since when rmf deletes a folder its contents are lost irretrievably.
DESCRIPTION
The rmf command removes all of the messages within the current folder, and then removes the folder itself. If there are any files within
the folder which are not part of MH, they are not removed, and an error message is displayed.
You can specify a folder other than the current folder by using the +folder argument. If you do not specify a folder, and rmf cannot find
the current folder,rmf asks you whether you want to delete +inbox instead.
If the current folder is removed, it makes +inbox current.
Note that the rmf command irreversibly deletes messages that do not have other links, so use it with caution.
If the folder being removed is a sub-folder, the parent folder becomes the new current folder, and rmf tells you that this has happened.
This provides an easy mechanism for selecting a set of messages, operating on the list, then removing the list and returning to the current
folder from which the list was extracted.
Using rmf to delete a read-only folder deletes the private sequence and current message information from the file, without affecting the
folder itself. If you have sub-folders within a folder, you must delete all the sub-folders before you can delete the folder itself.
PROFILE COMPONENTS
Path: To determine the user's Mail directory
EXAMPLES
This example shows how rmf asks for confirmation when the -interactive option is used: % rmf -interactive +test Remove folder "test"? y
FILES
The user profile.
SEE ALSO rmm(1)rmf(1)