windows - Batch file to process csv document to add space in postcode field -

-

i have csv file populated name, address, , postcode. large number of postcodes not have required space in between e.g lu79gh should lu7 9gh , w13tp should w1 3tp. need add space in each postcode field if not there already, space should before last 3 characters.

what best way solve via windows command line? many thanks

you can for /f follows:

@echo off setlocal enabledelayedexpansion  if "%~1" equ "" (echo.%~0: usage: missing file name.& exit /b 1) if "%~2" neq "" (echo.%~0: usage: many arguments.& exit /b 1)  /f %%i in (%~1) (echo.%%i& goto :afterheader) :afterheader /f "skip=1 tokens=1-3 delims=," %%i in (%~1) (     set name=%%i     set address=%%j     set postcode=%%k     set postcode=!postcode: =!     echo.!name!,!address!,!postcode:~0,-3! !postcode:~-3! )  exit /b 0

demo:

> type data.csv name,address,postcode n1,a1,lu79gh n2,a2,w13tp n1,a1,lu7 9gh n2,a2,w1 3tp  > .\add-space.bat data.csv name,address,postcode n1,a1,lu7 9gh n2,a2,w1 3tp n1,a1,lu7 9gh n2,a2,w1 3tp

you can redirect output file capture it. (but can't redirect same file input, because redirection overwrite input file before can read script. if want overwrite original file, can redirect output new file, , move new file on original after script has finished.)


Comments

Post a Comment

Popular posts from this blog

python - TypeError: start must be a integer -

-
i trying draw 5 turtles, getting typeerror on line 25. here code: import turtle wn = turtle.screen() redrose = turtle.turtle() color = input("what background color be?") fillcolor_f = input("what color of rose be?") redrose.hideturtle() redrose.speed(30) redrose.penup() redrose.left(180) redrose.forward(175) redrose.right(90) redrose.forward(30) redrose.right(90) redrose.pendown() def drawrose(red): redrose.color("pink") redrose.fillcolor(fillcolor_f) redrose.fill(true) in range(red): redrose.forward(i) redrose.right(49) in range(5): drawrose(redrose) redrose.penup() redrose.forward(350) redrose.right(144) redrose.pendown() redrose.fill(false) drawrose(50) wn.bgcolor(color) i trying draw 5 roses, produces errors. doing in interactivepython.org. you recursively calling drawrose wrong parameter. on line 23 ( for in range(red): ) expect red integer...
Read more

c# - DevExpress RepositoryItemComboBox BackColor property ignored -

-
i have following code almost works properly; private void cbstatus_drawitem(object sender, listboxdrawitemeventargs e) { string item = e.item string; if (item != null) { switch (item) { case "1": e.appearance.forecolor = color.green; e.appearance.backcolor = color.green; break; case "2": e.appearance.forecolor = color.orange; e.appearance.backcolor = color.orange; break; case "3": e.appearance.forecolor = color.red; e.appearance.backcolor = color.red; break; } } } when dropdown shown, items forecolor correct, backcolor remains whatever backcolor of theme is; i.e. if i've got set dark theme, backcolor dark, cells in gridview, rather being green/orange/red. i've tried setting e.appearance.options.usebackcolor trying set e....
Read more

django - Creating multiple model instances in DRF3 -

-
1) create multiple model instances 1 api call, asked here: how create multiple model instances django rest framework? tried solution named in link, no success. i trying upload multiple files in 1 api call. result: files uploaded (only once overwrote perform_create) 1 instance created (if send 2 files, latter created instance). my code: class fileuploadserializer(serializers.modelserializer): def __init__(self, *args, **kwargs): many = kwargs.pop('many', true) super(fileuploadserializer, self).__init__(many=many, *args, **kwargs) class meta: model = fileupload read_only_fields = ('created', 'datafile', 'owner') class fileuploadviewset(viewsets.modelviewset): queryset = fileupload.objects.all() serializer_class = fileuploadserializer parser_classes = (multipartparser, formparser, ) def perform_create(self, serializer): file_list = self.request.data.getlist('file') ...
Read more