Find Jobs
Hire Freelancers

Formatting data using “SED” & “AWK” .

$30-250 USD

Opravljeno
Objavljeno pred več kot 6 leti

$30-250 USD

Plačilo ob dostavi
I have data in a fixed length format - [login to view URL] containing a sample is appended. My existing SED & AWK commands were working well in transforming this into a format that I could import to my database. However a change in the OS has meant that I now need to use a new javascript database manager (the database I use is Frontbase which is free from [login to view URL]) . The javascript database manager does not see the data in my existing format so it would be much better if the files processed were delimited by TAB and with record separators as “\n”. ie as if the files were saved as windows tab delimited format from Excel. So the job is to adjust the syntax of the 2 commands below to produce the exact same data but formatted with TAB delimiters and “\n” rather than with the column separator “!@!” and the record separator “\r” 1. awk '{OFS="!@!"};{print substr($0,6,14)}’ [login to view URL] > [login to view URL] 2 awk '{OFS="!@!"};{print substr($0,6,14),substr($0,20,8),substr($0,128,100),substr($0,228,100),substr($0,328,2),substr($0,330,100)}' [login to view URL] > [login to view URL] LANG=C sed 's/ //g' [login to view URL] > [login to view URL] LANG=C sed 's/ / /g' [login to view URL] > [login to view URL] LANG=C sed 's/ !@!/!@!/g' [login to view URL] > [login to view URL] LANG=C sed 's/ !@!/!@!/g' [login to view URL] > [login to view URL] (a sample of this one is appended) The project will be successfully completed if I can import the 2 files: [login to view URL] as were produced by my original AWK & SED commands described above using the jsfrontbasemanager
ID projekta: 15328191

Več o projektu

5 ponudb
Projekt na daljavo
Aktivno pred 7 leti

Želite zaslužiti?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Prejmite plačilo za svoje delo
Povzetek predloga
Registracija in oddajanje ponudb sta brezplačna
Dodeljeno:
Avatar uporabnika
I can have your format changed and tested this morning. Stay tuned, I'm still working on this proposal.
$35 USD v 1 dnevu
5,0 (1 ocena)
1,7
1,7
5 freelancerjev je oddalo ponudbo s povprečno vrednostjo $110 USD za to delo
Avatar uporabnika
A proposal has not yet been provided
$111 USD v 5 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
Hi there. I can set up the conversion formulation in Excel to edit .csv file. So that when you export it back to csv, you will be able to import as you like. COntact me to discuss further. Relevant Skills and Experience Excel, VBA. I can make you an sample work so that we see if it works as you wish. Proposed Milestones $250 USD - Job Done
$250 USD v 5 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
Hi dear, i can do this project in a day. Please respond so that we can finalize the details Relevant Skills and Experience I have 3+ years of experience in working on shell and linux scripting. Working in the field since 2014. Proposed Milestones $100 USD - shell Skype meeting for further details?
$100 USD v 3 dneh
0,0 (0 ocen)
0,0
0,0

O stranki

Zastava UNITED KINGDOM
Dunoon, United Kingdom
5,0
240
Plačilna metoda je verificirana
Član(ica) od jan. 17, 2005

Verifikacija stranke

Hvala! Po e-pošti smo vam poslali povezavo za prevzem brezplačnega dobropisa.
Pri pošiljanju vašega e-sporočila je šlo nekaj narobe. Poskusite znova.
Registrirani uporabniki Skupaj objavljenih del
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Nalaganje predogleda
Geolociranje je bilo dovoljeno.
Vaša prijavna seja je potekla, zato ste bili odjavljeni. Prosimo, da se znova prijavite.