Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Split a column

Status
Not open for further replies.
ffaabbrriiccee

ffaabbrriiccee

Programmer
Joined
Mar 29, 2017
Messages
1
Location
US
if i have +2, i want this to be + 2 as separate columns. Doing this for a large column so I cannot do it manually.
 
Sort by date Sort by votes
You can use regular expression substitution with back reference.
For example with sed it could be something like this
Code: 
$ echo "+2 +3    +123" | sed -E "s/\+([0-9]+)/+ \1/g"
+ 2 + 3    + 123
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

seifou45
  • Locked
  • Question Question
split row by group of ten in each row splited
Replies
17
Views
1K
mikrom
mikrom
visitnag
  • Locked
  • Question Question
Hi I have a file with following
Replies
2
Views
631
visitnag
visitnag
johngiggs
  • Locked
  • Question Question
How do I print from a specific string to a new line with a matching pattern
Replies
3
Views
685
mikrom
mikrom
V_M
  • Locked
  • Question Question
Awk Command not able to read French/Spanish characters from a file
Replies
1
Views
584
mikrom
mikrom
darioit
  • Locked
  • Question Question
match two file passing input as parameter
Replies
1
Views
565
mikrom
mikrom

Part and Inventory Search

Sponsor

Back
Top