Python File Creation based on Templates and CSV input
$10-30 USD
In Progress
Posted almost 6 years ago
$10-30 USD
Paid on delivery
I need to create files in batch from a CSV input based on a template.
Construction Of file example:
:79:/HSMT/ZHDR
:79:/HVRN/001
:79:/HMDE/G
:79:/HSEQ/00000001
:79:/UFTQ/0000745
:79:/IUSE/SVSCGBK1
:79:/UOPR/FTOP1
:79:/HSMT/ADVN
:79:/HVRN/005
:79:/HMDE/G
:79:/HSEQ/00000002
:79:/HFPI/010A
:79:/HDPI/010A
:20:PM8HQAQ0001A
:31P:20180419
:79:/EISD/20180419
:79:/CTSU/S
:79:/CTSS/V
:79:/CTRM/T
:79:/IPRT/010A
:83C:POOL
:79:/IPRT/8HQAQ
:18A:2
:79:/IDPS/8HQAQ
:79:/ICPS/010A
:35B:ISIN GB0007980591
:35A:280,00
:18A:1
:18A:0
:18A:0
:79:/HSMT/ZTLR
:79:/HVRN/001
:79:/HMDE/G
:79:/HSEQ/00000003
:79:/NFTC/00000003
I should be able to edit a template which will allow me to:
• Specify input based on a column number from a csv file within the template.
Example line from above template:
:79:/IUSE/SVSCGBK1
Imagine I have a CSV with any number of columns, and the first row in the first column contains the “test”
I would specify in the template:
:79:/IUSE/$COLUMN1
The output file would show
:79:/IUSE/test
Other requirements:
• The name of the file output file should also be specified from a column.
• The csv file can contain any number of columns.
• A different output file for each line of the csv must be created.
• A blank line at the end of every file must be present
Payment will be released on testing and a milestone will be set up.
Hello
I have few questions about template :
Does it mean I should take last word after / as column name?
What is beginning part like ":79:/IUSE/"? Should it just stay the same?
Thanks