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
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
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?