logo
down
shadow

How to replace the third comma in a csv file with a space in linux using bash?


How to replace the third comma in a csv file with a space in linux using bash?

Content Index :

How to replace the third comma in a csv file with a space in linux using bash?
Tag : linux , By : user176691
Date : January 12 2021, 08:33 AM

wish helps you The sed s command has a flag to specify which occurrence of a regex to apply the command to:
sed 's/,/ /3' infile

Comments
No Comments Right Now !

Boards Message :
You Must Login Or Sign Up to Add Your Comments .

Share : facebook icon twitter icon

How to use PHP regex to replace a space AND comma AND combination of space AND comma with arbitrary string?


Tag : php , By : Jesse
Date : March 29 2020, 07:55 AM
wish help you to fix your issue How do you use PHP's preg_match to replace:
preg_replace('/[\s,]+/', 'YES', $str);

Linux bash: how to replace 2 words in a file from bash command line


Tag : linux , By : Chaz
Date : March 29 2020, 07:55 AM
hope this fix your issue I need to replace 2 words in a file from Bash command line, for example: fileA.txt , You could try the below sed command,
sed -i 's/AA BB/CC DD/g' file
$ echo 'xxxx AA BB xxx' | sed 's/AA BB/CC DD/g'
xxxx CC DD xxx
awk '{sub(/AA BB/,"CC DD")}1' infile > outfile
$ echo 'xxxx AA BB xxx' | awk '{sub(/AA BB/,"CC DD")}1'
xxxx CC DD xxx

Bash replace a comma with space colon space sequence


Tag : bash , By : ianium
Date : March 29 2020, 07:55 AM
wish of those help tr -d is usually used for deleting characters. If you want a quick way to replace commas with a space-colon-space sequence1, just use:
sed 's/,/ : /g' testfile
sed -i.bak 's/,/ : /g' testfile
mv testfile testfile.bak
sed 's/,/ : /g' testfile.bak >testfile
tr ',' ':' <testfile
mv testfile testfile.bak
tr ',' ':' <testfile.bak >testfile

How to replace comma with space in text file using VBA


Tag : vba , By : Nate Bedortha
Date : March 29 2020, 07:55 AM
it helps some times I have data in a text file (input.jpg). I want to replace the comma with the space and align the data in one line.Please see the output text file (output.jpg). , This should do the trick:
Sub foo()
Dim objFSO
Const ForReading = 1
Const ForWriting = 2
Dim objTS 'define a TextStream object
Dim strContents As String
Dim fileSpec As String

fileSpec = "C:\Test.txt" 'change the path to whatever yours ought to be
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objTS = objFSO.OpenTextFile(fileSpec, ForReading)

Do While Not objTS.AtEndOfStream
    strContents = strContents & " " & objTS.ReadLine 'Read line by line and store all lines in strContents
Loop

strContents = Replace(strContents, ",", " ")
objTS.Close

Set objTS = objFSO.OpenTextFile(fileSpec, ForWriting)
objTS.Write strContents
objTS.Close
End Sub

How can I cut each line in a file when it reaches a space or comma in bash?


Tag : awk , By : Carter
Date : March 29 2020, 07:55 AM
this one helps. I basically want the first word of each sentence in a file, but since words can be followed by punctuation, cutting after a space doesn't do it. , Could you please try following.
With sed:
sed -E 's/(^[a-zA-Z]+).*/\1/' Input_file
awk 'match($0,/^[a-zA-Z]+/){print substr($0,RSTART,RLENGTH)}' Input_file
awk 'match($0,/^[a-zA-Z]+\(\)-/){print substr($0,RSTART,RLENGTH)}' Input_file
awk 'match($0,/^[[:alpha:]()-]+/){print substr($0,RSTART,RLENGTH)}' Input_file
Related Posts Related QUESTIONS :
  • How to merge column output to the end of a row in the previous column?
  • How to write a custom device registration function for custom device such as RTC or ADC etc.?
  • Linux command to delete all the files older than the latest modified file/s
  • The sort command in linux does not work "correctly"
  • Atomic read and truncate of file in linux
  • Zip files within the directory without file extensions
  • How to prevent changes to the underlying file after mmap()-ing a file from being visible to my program?
  • OpenJDK9 Missing in Alpine Linux
  • Insert data into database using sqlldr in coldfusion
  • Can't realize alias/substitution function for my .bashrc
  • Can ack/ag/grep print function name?
  • How to extract log using bash script between a date / time and another
  • Homework: Trying to calculate Easter using arithmetic evaluations
  • How to loop through an output and format the result into a new report?
  • How to add verbosity option to control script output?
  • xm64 fills my processor resource in Linux Mageia 6
  • Measuring temperature while benchmarking on Linux
  • Grep using a regular expression and capturing using groups
  • Getopts default case bash script
  • C can I open a directory's files using open dir in an alphabetical order?
  • Get a tag value in multi line XML using shell script
  • Errors while execute 'make' command, debian
  • How to speed up grep/awk command?
  • Why does calling the C abort() function from an x86_64 assembly function lead to segmentation fault (SIGSEGV) instead of
  • Passing commandline argument to qml
  • Bash command with pipe not working in crontab
  • DBD-Oracle (1.74 or 1.76) with oracle instantclient 11.2 on win10 wsl ubuntu
  • How can I use Bash to contract/shrink a set of values
  • sed only print substring in a string
  • How to make find . -name "*.txt" | xargs grep "text" to work with filename with spaces
  • numeric variable in egrep regular expression bash script
  • How to use case to identify a specific pattern in BASH script
  • Pipe stdout to with multiple lines to individual files
  • How to remove a file called * (asterisk) without using quotations?
  • How to enable CONFIG_RT_GROUP_SCHED in Ubuntu to make it RT
  • How to make the query work in linux server?
  • Linux device driver for a gps module
  • Command for printing part of a String?
  • GitLab-Runner "listen_address not defined" error
  • How does logrotate work when there are two process use the same file?
  • Got error while Mounting, error massage:"mount.nfs: remote share not in 'host:dir' format"
  • Does read/write blocked system call put the process in TASK_UNINTERRUPTIBLE or TASK_INTERRUPTIBLE state?
  • How to create a 3 second timer in Bash?
  • Breaking out of nested function loops in Bash
  • no module named numpy even after installing it
  • How to fix error "'recipe for target "doc/automake-1.14.1' failed" while building Xenomai
  • Is it possible to partially unzip a .vcf file?
  • Sorting the time format in shell script
  • why bash changing my command 'mysql*' to 'mysql.sql'?
  • Is D-Bus a middleware IPC?
  • Make runs cc and I don't understand why
  • Add same files to multiple PACKAGES
  • Getting a symbolic link full path
  • How do I recover a corrupted dnf database?
  • docker-compose up and user inputs on stdin
  • How to convert DOS/Windows newline (CRLF) to Unix newline (LF) in a Bash script?
  • Installing sSMTP from SSH
  • Passing lines as args to a script
  • Create setup for Linux C project
  • Move/copy files/folder in linux/solaris using only bash built-ins
  • shadow
    Privacy Policy - Terms - Contact Us © scrbit.com