Windows批处理编程 - 从csv文件中读取并提取某些数据列基于第一列的值 [英] Windows Batch programming - Reading from a csv file and extracting certain data columns based on first column value

问题描述

这是我的第一批计划，我一直在网上寻找，但仍然在努力写了一个解决方案。

我有以下CSV文件：

 RH，2013/6月15日2点14分58秒-0400，X，LQ3SUEEWPWKL6，005，
FH，01
SH，2013/6月14日00:00:00 -0400,2013 / 6月14日23:59:59 -0400LQ3SUEEWPWKL6，
CH，值TransactionID，InvoiceID，
......
 

我试着写一个简单的程序来执行以下操作：
- 如果COLUMN1 =RH，然后提取列2值（2013年6月15日二时十四分58秒-0400）
- 如果COLUMN1 =SH，然后提取column4值（LQ3SUEEWPWKL6）

和管道输出到文件。

感谢您

---

这是我的code，到目前为止，但如果条件不为我工作

 关闭@echo
::在变量设置输入文件
::设为_InputFile =％1::存储输入行成不同的变量
FOR / F令牌= 1-18 * delims =%% A IN（％_InputFile％）DO（
设置_var1 = %%一
设置_var2 = %%乙
设置_var3 = %%Ç
设置_var4 = %%ð
设置_var5 = %%Ë
设置_var6 = %%˚F
设置_var7 = %%摹
设置_var8 = %% ^ h
设置_var9 = %%我
设置_var10 = %%Ĵ
设置_var11 = %%ķ
设置_var12 = %%大号
设置_var13 = %%中号
设置_var14 = %%ñ
设置_var15 = %%Ø
设置_var16 = %% P
设置_var17 = %% Q
设置_var18 = %%  -  [R
IF％_var1％==RH回声％VAR2％
 

）

我的CSV文件看起来在Excel和记事本正常，但当我执行脚本中显示的第一个变量，它看起来像上的第一个记录是一些垃圾字符只是RH之前 - 我不能绕过它，因为我需要提取附加列的数据，如果VAR1 =RH

 RH
FH
01
SH
CH
的TransactionID，PaymentTrackingID，
SF
SF
SC
RF
CAD，CR，0
RF
美元，CR，0
RC
FF
 

解决方案

 （
FOR / F令牌= 1-18 * delims =%% A IN（％_InputFile％）DO（
  如果%%〜A==RH回声%%一B
  如果%%〜A==SH呼应%%〜ð
 ）
）＆GT; youroutputfilename
 

应该努力 - 没有必要将所有的值不同的变量 - 但是如果你打算使用它们，然后

  FOR / F令牌= 1-18 * delims =%% A IN（％_InputFile％）DO（
...
设置_var17 = %% Q
设置_var18 = %%  -  [R
CALL：PROCESS
）
...
GOTO：EOF：处理
IF％_var1％==RH回声％_var2％
IF％_var1％==SH回声％_var4％
GOTO：EOF
 

请注意，使用这种方法，因为你正在分配 %% X 到 _varx 则如果 %% X 被引用，引号将被分配中的价值包括在内。要删除封闭引号（如果存在的话）使用 SET _varx = %%〜X 。

---

补遗20130703-1956Z为OP的问题。

  @ECHO OFF
SETLOCAL
SET _Inputfile = U：\\ noname1.txt
（
FOR / F令牌= 1-18 * delims =%% A IN（％_InputFile％）DO（
  SETRH =
  SETSH =
  ECHO（%% A | FINDSTR / L / C：\\RH \\＆GT; NUL
  IF NOT ERRORLEVEL 1套RH = Y
  ECHO（%% A | FINDSTR / L / C：\\SH \\＆GT; NUL
  IF NOT ERRORLEVEL 1组SH = Y
  如果定义RH呼应%%一B
  如果定义SH回声%%〜ð
 ）
）＆GT; U：\\ youroutputfilename
U型：\\ youroutputfilename
德尔U：\\ youroutputfilename
呼应========第一种方式（
FOR / F令牌= 1-18 * delims =%% A IN（％_InputFile％）DO（
  SET _var1 = %%一
  SETRH =
  SETSH =
  CALL：过程
  如果定义RH呼应%%一B
  如果定义SH回声%%〜ð
 ）
）＆GT; U：\\ youroutputfilenameU型：\\ youroutputfilename
德尔U：\\ youroutputfilename
呼应========方式二SETLOCAL ENABLEDELAYEDEXPANSION
（
FOR / F令牌= 1-18 * delims =%% A IN（％_InputFile％）DO（
  SET _var1 = %%一
  IF_var1：！〜-4==RH，回声%%一B
  IF_var1：！〜-4==SH，回声%%〜ð
 ）
）＆GT; U：\\ youroutputfilenameU型：\\ youroutputfilename
德尔U：\\ youroutputfilename
呼应========第三条道路
ENDLOCALGOTO：EOF：处理
IF％_var1：〜-4％==RH，SET RH = Y
IF％_var1：〜-4％==SHSET SH = Y
GOTO：EOF
 

This is my first batch program and I have been searching online but still struggling to write up a solution.

I have the following CSV file:

"RH",2013/06/15 02:14:58 -0400,"X","LQ3SUEEWPWKL6",005,
"FH",01
"SH",2013/06/14 00:00:00 -0400,2013/06/14 23:59:59 -0400,"LQ3SUEEWPWKL6",""
"CH","TransactionID","InvoiceID", 
......

I'm trying to write a simple program to do the following: - If column1 = "RH", then extract column2 value (2013/06/15 02:14:58 -0400) - If column1 = "SH", then extract column4 value (LQ3SUEEWPWKL6)

and pipe output to a file.

Thank you

---

This is my code so far but the if condition is not working for me

@echo off
:: Set input file in variable
::Set _InputFile=%1

:: Store input line into different variables
FOR /F "tokens=1-18* delims=," %%A IN (%_InputFile%) DO (
Set _var1=%%A
Set _var2=%%B
Set _var3=%%C
Set _var4=%%D
Set _var5=%%E
Set _var6=%%F
Set _var7=%%G
Set _var8=%%H
Set _var9=%%I
Set _var10=%%J
Set _var11=%%K
Set _var12=%%L
Set _var13=%%M
Set _var14=%%N
Set _var15=%%O
Set _var16=%%P
Set _var17=%%Q
Set _var18=%%R


IF "%_var1%"=="RH" echo %var2%

)

My CSV file looks fine in Excel and Notepad but when I execute the script to display the first variable, it looks like there's some garbage characters just before the "RH" on the first record - I cannot bypass it since I need to extract additional column data if var1 = "RH":

"RH"
FH
01
SH
CH
TransactionID,PaymentTrackingID,
SF
SF
SC
RF
CAD,CR,0
RF
USD,CR,0
RC
FF

解决方案

(
FOR /F "tokens=1-18* delims=," %%A IN (%_InputFile%) DO (
  if "%%~A"=="RH" echo %%~B
  if "%%~A"=="SH" echo %%~D
 )
)>youroutputfilename

Should work - no need to assign all the values to different variables - BUT if you plan to use them, then

FOR /F "tokens=1-18* delims=," %%A IN (%_InputFile%) DO (
...
Set _var17=%%Q
Set _var18=%%R
CALL :PROCESS
)
...
GOTO :EOF

:PROCESS
IF %_var1%=="RH" echo %_var2%
IF %_var1%=="SH" echo %_var4%
GOTO :EOF

Note that with this method, since you are assigning %%x to _varx then if %%x is quoted, the quotes will be INCLUDED in the value assigned. To remove the enclosing quotes (if they exist) use SET _varx=%%~x.

---

Addendum 20130703-1956Z for OP's problem

@ECHO OFF
SETLOCAL
SET _Inputfile=u:\noname1.txt
(
FOR /F "tokens=1-18* delims=," %%A IN (%_InputFile%) DO (
  SET "RH="
  SET "SH="
  ECHO(%%A|FINDSTR /l /c:"\"RH\"" >NUL
  IF NOT ERRORLEVEL 1 SET RH=Y
  ECHO(%%A|FINDSTR /l /c:"\"SH\"" >NUL
  IF NOT ERRORLEVEL 1 SET SH=Y
  if DEFINED RH echo %%~B
  if DEFINED SH echo %%~D
 )
)>u:\youroutputfilename
TYPE u:\youroutputfilename
del u:\youroutputfilename
echo========First way

(
FOR /F "tokens=1-18* delims=," %%A IN (%_InputFile%) DO (
  SET _var1=%%A
  SET "RH="
  SET "SH="
  CALL :process
  if DEFINED RH echo %%~B
  if DEFINED SH echo %%~D
 )
)>u:\youroutputfilename

TYPE u:\youroutputfilename
del u:\youroutputfilename
echo========Second way

SETLOCAL ENABLEDELAYEDEXPANSION 
(
FOR /F "tokens=1-18* delims=," %%A IN (%_InputFile%) DO (
  SET _var1=%%A
  IF "!_var1:~-4!"==""RH"" echo %%~B
  IF "!_var1:~-4!"==""SH"" echo %%~D
 )
)>u:\youroutputfilename

TYPE u:\youroutputfilename
del u:\youroutputfilename
echo========Third way
ENDLOCAL

GOTO :EOF

:process
IF "%_var1:~-4%"==""RH"" SET RH=Y
IF "%_var1:~-4%"==""SH"" SET SH=Y
GOTO :EOF

这篇关于Windows批处理编程 - 从csv文件中读取并提取某些数据列基于第一列的值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！