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 DEBIAN
fadecut
fadecut(1) General Commands Manual fadecut(1)NAME
fadecut - Toolset to rip audiostreams, cut, fade in/out and tag the resulting audiofiles
SYNOPSIS
fadecut -p <profile> [ OPTIONS ]
DESCRIPTION
fadecut is a script to rip audio files from a livestream (using streamripper) and to process them automatically. Beginning and ending fo
the audio files will be cut and faded in/out. So logos and advertising of radio stations will be automatically removed.
In streaming mode fadecut is ripping audio files using streamripper. The downloaded audio files are cutted using silence detection and then
faded in and out. Subsequently, the files are encoded to either ogg or mp3 and tagged with tags (title, artist, genre and comment pro-
vided).
In file mode fadecut is just processing already ripped audio files.
An audio file which has already been processed is detected and will not be processed again. Not desired songs can be stored in a separate
directory. This files are not processed anymore too.
FOLDERS
fadecut is working with some standard folders. You may change them in your profile or fadecutrc
done/ here you put all your songs which were already processed by fadecut and which you want to keep. See also new/ folder.
dontlike/ in this folder you may put songs which you don't like. Fadecut is checking this folder before it is processing new files in the
working folder. Null size files are ok.
error/ whenever an error occurs while fadecut is processing a file, that file is moved to the error folder for later examining.
incomplete/ this folder is created by streamripper. All not fully ripped songs are saved here.
new/ processed songs are going here. Usually you may rip and process files with fadecut, they are going in to new/ folder, you listen to
them and put good songs to the done/ folder.
orig/ if you want to keep the original file (which is ripped by streamripper), you may use the -k option. fadecut is putting the ripped
files untouched into that folder.
OPTIONS -c Create a new profile <profilename>
-e Edit an existing profile <profilename>
-i optional input <directory>
-o optional output <directory>
-k optional to keep the untouched original song in the /orig folder
-d Debug: -d 0|1|2|3 (level 0 is standard, -d without number is like 1)
-h Show this message
-p Profile <profilename>
-q Quiet
-r Stream (and rip), start streamripper
-v Verbose
VARIABLES
STREAM_URL="http://streamurl"
test
ENCODING=ogg
preferred destination fileformat. (ogg/mp3)
GENRE="SwissPop"
Processed files will get the above genre.
COMMENT="Radio Swiss Pop"
Processed files will get the above comment.
TRIM_BEGIN=0
cut <n> seconds off the file in the beginning.
TRIM_END=0
cut <n> seconds off the file at the end.
FADE_IN=1
Fade in for <n> seconds.
FADE_OUT=4
Fade out for <n> seconds.
EXAMPLES
Create a new ripping profile
fadecut -c test
Edit/update profile test
fadecut -e test
Rip, cut and fade in-/out with profile test
fadecut -p test -r
Only cut and fade in-/out without ripping from livestream
fadecut -p test
SEE ALSO id3v2(1), oggenc(1), sox(1), streamripper(1), lame(1)FILES
~/.fadecut/fadecutrc
The main fadecut configuration file, executed with every start of fadecut
~/.fadecut/statslog.csv
The statistics file
~/.fadecut/profiles
The folder where all profiles are located
RESOURCES
fadecut git website
https://github.com/micressor/fadecut
0.1.0 fadecut(1)